Posts Tagged ‘PSSDiag’

Speaking at the PASS Community Summit 2009

2009-07-01

One of my abstracts was selected for the PASS Community Summit 2009! It is an immense honor to get to speak at the conference, and it’s humbling to see my name listed amongst those of so many renowned SQL Server experts! According to Andy Warren (blog, Twitter), a member of the PASS Board of Directors, I am one of thirteen speakers who will be presenting at a PASS Summit for the first time.

I want to thank two friends and mentors who helped me to secure this opportunity, Peter DeBetta (blog, Twitter) and Jason Massie (blog, Twitter). Both are SQL Server MVPs that I met through the North Texas SQL Server Users Group. Each has presented at previous PASS conferences and sat on committees to select conference speakers (Peter for DevTeach/SQLTeach and Jason for the PASS Summit). Their advice has helped me get into speaking at the local user groups, position my abstracts for selection, and simply grow as a SQL Server professional!

Here are the details on my session:

Session Name: Leveraging PSSDiag/SQLDiag for Efficient Troubleshooting
Track: Enterprise Database Administration and Deployment
Description: 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 RML Utilities as well as a few scripts of my own. Come and see how these tools can save you massive amounts of troubleshooting time!
Prerequisites: A basic understanding of SQL Server diagnostic data (such as traces, server metadata, and performance counters)
Session Goals:
  1. Familiarity with the setup and usage of the PSSDiag and SQLDiag utilities
  2. Familiarity with analyzing diagnostic data with the RML Utilities
  3. The ability to use PSSDiag/SQLDiag data to diagnose problems

I’ll post information on this blog as I refine the presentation and its demonstrations over the next few months.