Performance Troubleshooting SQL Server with Native Tools

Learning how to detect, diagnose, and resolve performance problems in SQL Server® is tough. Often, people spend years learning how to use tools and techniques to help them detect when a problem is occurring, diagnose the root cause of the problem, and resolve it. By attending this session on SQL Server and Azure® SQL performance troubleshooting and optimization (PTO), you'll condense years of on-the-job experience into a single hour.

In this session, you'll learn a bulletproof workflow for PTO. Attendees will see demonstrations of the tools and techniques designed to make difficult troubleshooting scenarios much faster and easier, including the following:

• Old technologies like profiler/traces and Performance Monitor
• Current technologies using Dynamic Management Views (DMVs)
  • Using wait statistics
  • Specialty DMVs for CPU, I/O, memory, and more
• Newer technologies like Query Store and Extended Events (XEvents)

Every DBA needs to know how to keep their SQL Server instance in tip-top condition, and you'll need the skills covered in this session to do it. In addition, you'll leave the session with a high-quality Transact-SQL script toolkit to use whenever you face a PTO scenario.

Prerequisites: Intermediate database administration and development skills—especially competence with SQL Server Management Studio (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 and 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.

Webcast Date

Tuesday, June 21, 2022
1:00:00 PM EDT (New York) | 6:00:00 PM UTC

Speaker(s)

Kevin Kline

Kline is a noted database expert and software industry veteran. At previous companies, his product designs won multiple "Best of" and "Readers' Choice" awards.

Kline was a founding board member and former president of the Professional Association for SQL Server (PASS), is an avid blogger and database columnist, author of the best-selling book, SQL in a Nutshell, and ten other books. He is a frequent webinar host and speaker at various industry conferences and user groups and has traveled the world as part of his multi-continent roadshows.

A Microsoft SQL Server MVP since 2003, Kline is passionate about improving the quality of life for Microsoft database professionals and their customers. As a SolarWinds Head Geek, he focuses on helping customers with troubleshooting and adopting best practices for optimal database performance monitoring, on-premises and in the cloud.

Sponsored by

Register for this webinar: