Support WebCast: How to Collect and Analyze Performance Data in Microsoft SQL Server

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 (http://support.microsoft.com/default.aspx?scid=gp;en-us;webcastlevels&sd=gn) 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: 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 (http://download.microsoft.com/download/e/b/6/eb6dac6b-cf5e-4f6b-aa13-03a4f022150d/wc082401.exe) 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 (http://office.microsoft.com/downloads/2000/Ppview97.aspx) (2,752 KB).

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

Tell a friend about this Support WebCast (mailto:?subject=Support WebCast: How to Collect and Analyze Performance Data in Microsoft SQL Server&body=Take a look at this Microsoft Support WebCast about How to Collect and Analyze Performance Data in Microsoft SQL Server (August 24, 2001). More information about this WebCast is available at http://support.microsoft.com/WebCasts.)

Supplemental reading:

• Q224587 Troubleshooting Application Performance with SQL Server (http://support.microsoft.com/default.aspx?scid=kb;en-us;q224587)
• Q251004 How to Monitor SQL Server 2000 Blocking (http://support.microsoft.com/default.aspx?scid=kb;en-us;q251004)
• Q224453 Understanding and Resolving SQL Server 7.0 Blocking Problem (http://support.microsoft.com/default.aspx?scid=kb;en-us;q224453)
• Q243589 Troubleshooting Slow-Running Queries on SQL Server 7.0 or Later (http://support.microsoft.com/default.aspx?scid=kb;en-us;q243589)
• Q243588 Troubleshooting Performance of Ad-Hoc Queries (http://support.microsoft.com/default.aspx?scid=kb;en-us;q243588)
• Q243586 Troubleshooting Stored Procedure Recompilation (http://support.microsoft.com/default.aspx?scid=kb;en-us;q243586)
• Q244455 Definition of Sysprocesses Waittype and Lastwaittype Fields for SQL Server 7.0 (http://support.microsoft.com/default.aspx?scid=kb;en-us;q244455)
• Index Tuning Wizard for Microsoft SQL Server 2000
• Microsoft SQL Server 7.0 Performance Tuning Guide

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

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