Monitoring blocking on a Microsoft SQL 2000

Quite often, due to a bad application design, SQL Server connection/process blocking becomes a major issue with application performance and in worse-case scenarios, the break-point of the applications.

Developers may be good at programming code writing but they are not experts at writing T-SQL. A true DBA would know the exact T-SQL syntax which would bring out the best of performance.

The main point of this blog entry is to let developers know that there is published techniques in obtaining detailed instrumentation of blocking activities on a SQL Server

The original articles was published for SQL 7.0.

This articles document the usage and design of a stored procedure that you can use to diagnose blocking and performance issues.

251004 How to monitor SQL Server 7.0 blocking
224453 Understanding and resolving SQL Server 7.0 blocking problem


The articles has now been updates for SQL 2000 and the latest is here:
How to monitor SQL Server 2000 blocking.

Cheers
Gill

What is this blog is for.

Greetings,

As a Microsoft Certified Trainer, I provide training and pre-sales services to Microsoft Learning Partners. Occasionally I get to present at TechNet and MSDN events for Microsoft Singapore. There are times where I am on-site for trouble shooting, development, design or merely working on a tender.

Anyway back to the point of me starting this blog, I get asked a lot of questions during and after courses with regards to .Net development for the Microsoft Official Curriculum courses that I conduct. So this blog is for those questions. Also from time to time, I will be writing my experiences as I learn/explore new technologies with regards to Microsoft Technologies as part of my preparation for training and projects.

/Gill