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:
Join this webcast and get ready to take your SQL Server Performance tuning to the next level.
Tuesday, May 2, 2023
1:00:00 PM EDT (New York) | 5:00:00 PM UTC
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.
Copyright (c) 2006-2023 Edgewood Solutions, LLC All rights reserved
Some names and products listed are the registered trademarks of their respective owners.