| Track: | Enterprise Database Administration and Deployment |
|---|---|
| Level: | 200 (Intermediate) |
| Abstract: | Over the years, Microsoft Customer Service and Support has developed a number of amazing tools for troubleshooting SQL Server. Thankfully many of these tools have been shared with the public. In this session I will demonstrate the configuration and usage of PSSDiag (for SQL Server 2000) and SQLDiag (for SQL Server 2005 and 2008), which collect valuable diagnostic data. We will then analyze the data using PAL, SQL Nexus, and a few scripts of my own. Come and see how these tools can save you massive amounts of troubleshooting time! |
| Goals: |
|
This presentation has been/will be delivered at the following event(s):
| Version | Date | Event |
|---|---|---|
| 1.1 | 2009-10-10 | SQLSaturday #25 |
| 1.2 | 2009-10-15 | NTSSUG user group meeting |
| 1.3 | 2009-10-21 | FWSSUG user group meeting |
| 1.4 | 2009-11-03 | 2009 North American PASS Summit |
| 1.5 | 2009-12-16 | EDMPASS user group meeting |
| 2.6 | 2010-05-22 | SQLSaturday #35 |
The following Zip files contain the downloadable presentation materials (slides, code, and handout(s)):
- Release 2.0006.0001.0017 (2010-10-27)
