Support WebCast: Microsoft SQL Server: Rapid Blocker Script Analysis

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 (http://support.microsoft.com/kb/324692) prior to viewing this broadcast.


This is a Level 200 (http://support.microsoft.com/default.aspx?scid=gp;en-us;webcastlevels&sd=gn) 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: 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.

Additional Resources

Download presentation (http://download.microsoft.com/download/b/a/1/ba130bda-9ae7-444e-943d-a6cbf5058b87/wc011502.exe) wc011502. This is a 344-KB Microsoft PowerPoint (.ppt) file.
If you do not have PowerPoint and you want a copy of the slides, use the PowerPoint Viewer (http://office.microsoft.com/downloads/2000/Ppview97.aspx) (1,911 KB).

Read the transcript from this Support WebCast (http://support.microsoft.com/?scid=http%3a%2f%2fsupport.microsoft.com%2fservicedesks%2fwebcasts%2fen%2fwc011502%2fwct011502.asp)

Tell a friend about this Support WebCast (mailto:?subject=Support WebCast: Microsoft SQL Server: Rapid Blocker Script Analysis&body=Take a look at this Microsoft Support WebCast about Microsoft SQL Server: Rapid Blocker Script Analysis (January 15, 2002). More information about this WebCast is available at http://support.microsoft.com/WebCasts.)

Supplemental reading:

• Inside Microsoft SQL Server 7.0 ­ Chapter 13 Locking or Inside Microsoft SQL Server 2000 Chapter 14 Locking.
• Q251175 INF: How to Monitor SQL Server 6.5 Blocking (http://support.microsoft.com/default.aspx?scid=kb;en-us;q251175)
• Q251004 INF: How to Monitor SQL Server 7.0 Blocking (http://support.microsoft.com/default.aspx?scid=kb;en-us;q251004)
• Q224587 INF: Troubleshooting Application Performance with SQL Server (http://support.microsoft.com/default.aspx?scid=kb;en-us;q224587)
• Q243589 INF: Troubleshooting Slow-running Queries (http://support.microsoft.com/default.aspx?scid=kb;en-us;q243589)
• Q243586 INF: Troubleshooting Stored Procedure Recompilation (http://support.microsoft.com/default.aspx?scid=kb;en-us;q243586)
• Q224453 INF: Understanding and Resolving SQL Server 7.0 and 2000 Blocking Problems (http://support.microsoft.com/default.aspx?scid=kb;en-us;q224453)
• Q243588 INF: Troubleshooting Performance of Ad-Hoc Queries (http://support.microsoft.com/default.aspx?scid=kb;en-us;q243588)
• Q150934 How to Create a Performance Monitor Log for NT Troubleshooting (http://support.microsoft.com/default.aspx?scid=kb;en-us;q150934)
• Q255596 sp_lock2 Returns Additional Data (http://support.microsoft.com/default.aspx?scid=kb;en-us;q255596)
• Q283696 Job to Monitor SQL Server 2000 Performance and Activity (http://support.microsoft.com/default.aspx?scid=kb;en-us;q283696)
• Q283784 How to View SQL Server 2000 Activity Data (http://support.microsoft.com/default.aspx?scid=kb;en-us;q283784)
• (http://support.microsoft.com/default.aspx?scid=kb;en-us;q283784)

Provide Feedback on this Broadcast (http://support.microsoft.com/common/survey.aspx?scid=sw;en;1073&p0=wc&p1=en-us&p2=wc011502)

Support WebCasts Home (http://support.microsoft.com/webcasts)