End-to-End Troubleshooting for SQL Server
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.
Technical Strategy Manager
Kevin Kline is the Strategy Manager for SQL Server Solutions at Quest Software. A Microsoft SQL Server MVP since 2004, Kevin is a founding board member and former president of PASS and the author of popular IT books like “SQL in a Nutshell” (O’Reilly & Associates). Kevin is a top-rated speaker at industry trade shows and has been active in the IT industry for over 20 years.
Register Now for PASS Summit 2010!