Knowledge Base

Support WebCast: Microsoft SQL Server: Rapid Blocker Script Analysis

Article ID: 324885

Article Last Modified on 8/9/2004

APPLIES TO

Microsoft SQL Server 2000 Standard Edition

This article was previously published under Q324885

Session Summary

During this session, we will show a practical approach to analyze performance tuning problems that involve Microsoft SQL Server lock monitoring data. We will briefly discuss sp_who2, sysprocesses, and syslocks. You should have a firm understanding of lock compatibility, lock escalation, and know how to read syslock and sysprocesses data. The primary discussion will highlight a few field-tested trending techniques that are low impact and fast to deploy to quickly evaluate server lock activity. Many critical tuning issues can be verified by using the Blocker Script method of writing and filtering syslock and sysprocesses data.

Participants are encouraged to view the archives from the Support WebCast How to Collect and Analyze Performance Data in Microsoft SQL Server prior to viewing this broadcast.

This is a Level 200 session that was recorded January 15, 2002 and presented by David G. Brown. David G. Brown joined Microsoft Product Support Services in February 1992, supporting Windows 3.0, Windows 286/386, and helped with the Windows 3.1 launch. David has a Bachelor of Science degree in computer science. David joined Microsoft Access product support team during its debut of Microsoft Access version 1.0, and later became the Tech Lead and held that position for two years. He left Microsoft to work for another company, but returned as a SQL support professional in February 1999 before the launch of SQL Server 7.0, where his focus has been on serving the enterprise customer segment.

Viewing the Presentation

To view, please click on the link: [javascript:fnViewMMC('http://support.microsoft.com/servicedesks/webcasts/seminar/shared/asp/view.asp?url=/servicedesks/webcasts/en/wc011502/manifest.xml'); View this Support Webcast] (Length: 1 hour 50 minutes)

'

This Windows Streaming Media archive requires an Internet connection of 28.8 Kbps or faster, and is best viewed with a minimum screen resolution of 800 X 600.