Monitor Blocking in SQL Server 2000 – Part 1

(Muthusamy Anantha Kumar) Part of Database Administrator’s job is to monitor blocking in SQL Server. By taking advantage of the Microsoft Knowledge Base article 271509, we can monitor the blocking and capture the SQL statements that are involved in the blocking to a file. This can be accomplished by

Read More - Register for Free Membership