Learning how to detect, diagnose and resolve performance problems in SQL Server is tough. Often, years are spent learning 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.
In this session, attendees will see demonstrations of the tools and techniques which make difficult troubleshooting scenarios much faster and easier, including:
• XEvents, Profiler/Traces, and PerfMon
• Using Dynamic Management Views (DMVs)
• Advanced Diagnostics Using Wait Stats
• Reading SQL Server execution plan
Every DBA needs to know how to keep their SQL Server in tip-top condition, and you’ll need skills the covered in this session to do it.
Prerequisites: Intermediate database administration and development skills, especially competence with SSMS.
Goal 1: Learn the "sieve" method of troubleshooting and problem solving, and how to make SQL Server alert you when problems arise.
Goal 2: Discover how to use wait stat analysis, as well as correlate performance information from other sources inside of SQL Server including DMVs, performance counters, and Xevent/trace information.
Goal 3: Learn how to use the most important native tools within SQL Server through live demos to successfully conduct troubleshooting and performance tuning.
Summary: Microsoft ships a multitude of tools to help detect, diagnose and resolve problems inside of SQL Server, but which is best to use and when? This session teaches attendees how to tackle the troubleshooting process to achieve repeated, optimal results.
Kevin Kline is a renowned database expert and software industry veteran currently serving as a principal program manager at SentryOne, a leading vendor of database tools for the Microsoft data platform. A Microsoft data platform MVP since 2003, Kevin was a founding board member and former president of PASS. He has written/co-written eleven books including the best-selling SQL in a Nutshell. Kevin is a monthly columnist for DBTA magazine. Kevin is a noted trainer and thought leader on IT leadership skills, data and database technology and practices, and SQL Server performance tuning and optimization. Kevin is a top-rated speaker at conferences worldwide such as Microsoft Ignite, the PASS Summit, Oracle OpenWorld, SQLBits, and IT/Dev Connections. He tweets at @kekline.