End-to-End Troubleshooting Checklist for Microsoft SQL Server

Title: End-to-End Troubleshooting Checklist for Microsoft SQL Server

Level: 200

Abstract: Learning how to detect, diagnose and resolve performance problems in SQL Server is tough.  It often takes years of on-the-job experience to learn how to use the tools and techniques that help you detect when a problem is occurring, diagnose the root-cause of the problem, and then resolve the problem.  So strap yourself in to a time machine, because you’ll learn in less than two hours what it took Kevin years to figure out through hands-on troubleshooting and problem solving.

This hands-on session will take you from the very start of a problem situation on SQL Server, showing you how to use the native tools that help you keep SQL Server at top performance and problem free.  This session will detail and demonstrate:

–       Performance Monitor (PerfMon)

–    ��  SQL Profiler/Server-side Trace

–       Correlating PerfMon and Profiler results

–       Using Dynamic Management Views (DMVs)

– ����������������������������������������������������������     Advanced Diagnostics Using Wait Stats

-����������������      Graphic Execution Plan and Transact-SQL Showplan

–       When to use Trace Flags

These tools and techniques can make your long days shorter and make difficult troubleshooting activities much faster and easier.  Every DBA needs to know how to keep their SQL Server in tip-top condition, and you’ll need these skills to do it.

Prerequisites: Intermediate database administration and development skills on SQL Server 2000 and 2005

Goal 1: Learn how to get alerts for errors, rather than having to check for errors.

Goal 2: Understand how to use native SQL Server tools for troubleshooting.

Goal 3: Learn how to resolve both errors and to improve SQL Server performance using its own native instrumentation.


Recommendation: This session is a great way to introduce attendees to sessions on individual topics listed about.  I suggest that, if you chose to schedule this session, that you set it early in the Summit schedule so that attendees can go even deeper by attending individual topic sessions, such as wait stats, SQL Profiler, reading execution plans, etc.

Download it! Download the slides from SlideShare.Net.