Article ID: 324692
Article Last Modified on 8/9/2004
APPLIES TO
- Microsoft SQL Server 2000 Standard Edition
This article was previously published under Q324692
Session Summary
Support WebCasts Home Support WebCast: How to Collect and Analyze Performance Data in Microsoft SQL Server August 24, 2001 Level:200 During this session, we will discuss the tools used to collect performance data and how to use this data to analyze some common SQL Server performance issues. We will review how to set up these tools and analyze the data collected. In addition, we will talk about troubleshooting techniques used to identify SQL Server performance issues.
This is a Level 200 session that was recordedDATE
and presented by William P. Carroll. Bill Carroll has worked with SQL Server since version 4.2. He works for Microsoft as a developer support professional in the SQL Server Database Development team. His primary responsibilities include database performance issues. Bill has been a Microsoft Certified Trainer since 1996, and previously worked with Household International and GE Capitol.
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/WC082401/manifest.xml'); View this Support Webcast] (Length: 1 hour 32 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 WC082401.ppt. This is a 397-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
[GRAPHIC: Tell a friend]Tell a friend about this Support WebCast
Supplemental reading:
- Q224587 Troubleshooting Application Performance with SQL Server
- Q251004 How to Monitor SQL Server 2000 Blocking
- Q224453 Understanding and Resolving SQL Server 7.0 Blocking Problem
- Q243589 Troubleshooting Slow-Running Queries on SQL Server 7.0 or Later
- Q243588 Troubleshooting Performance of Ad-Hoc Queries
- Q243586 Troubleshooting Stored Procedure Recompilation
- Q244455 Definition of Sysprocesses Waittype and Lastwaittype Fields for SQL Server 7.0
- Index Tuning Wizard for Microsoft SQL Server 2000
- Microsoft SQL Server 7.0 Performance Tuning Guide
Keywords: kbinfo kbdownload kbtshoot kbwebcastsupport KB324692