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:
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 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 (2,752 KB).
Read
the transcript from this Support WebCast
Tell
a friend about this Support WebCast
Supplemental reading:
Provide
Feedback on this BroadcastSupport WebCasts
Home