Performance Tuning SQL Server using Wait Statistics

In this session we will examine how the SQL Server engine processes queries, allowing us to dive deep into wait events. SQL Server Wait Statistics are one of the most important and common performance tuning metrics that can be used to track and troubleshoot query performance by identifying resource bottlenecks the query is waiting for such as IO, CPU, memory, network, etc.

We will discover what causes wait events, review common wait events, as well as ways to remedy issues using wait time response analysis.

Attend this session and leave with the knowledge of:

• How the SQL Server engine works
• How to collect Wait Statistics
• How to use and interpret the Wait Statistics data
• What knobs you can turn to improve performance

Join this webcast and get ready to take your SQL Server Performance tuning to the next level.

Webcast Date

Tuesday, May 2, 2023
1:00:00 PM EDT (New York) | 5:00:00 PM UTC

Speaker(s)

Thomas LaRock

Thomas LaRock is a Head Geek™ at SolarWinds and a Microsoft® Certified Master, Microsoft Data Platform MVP, VMware® vExpert, and former Microsoft Certified Trainer. He has over 20 years’ experience in the IT industry as a programmer, developer, analyst, and database administrator. LaRock has spent much of his career focused on data and database administration, which led to his being chosen as a Technical Evangelist for Confio Software in 2010, where his research and experience helped to create the initial versions of the software now known as SolarWinds® Database Performance Analyzer. LaRock has served on the board of directors for the Professional Association for SQL Server® (PASS), and is an avid blogger, author, and technical reviewer for numerous books about SQL Server management.

Sponsored by

Register for this webinar: