PASS Community Summit 2008: Spotlight Session (Database Administration)

End-to-End Troubleshooting for SQL Server 2005

Kevin Kline

Session Details

Learning how to detect, diagnose and resolve performance problems in SQL Server can be very difficult. 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. 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. This session will detail and demonstrate: - Performance Monitor (PerfMon) - SQL Profiler/Server-side Trace - Correlating PerfMon and Profiler results - Graphic Explain Plan and Transact-SQL Showplan - SQL Server 2005 and 2008 DMVs - 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.

Register Now for PASS Community Summit 2008!