How To Troubleshoot SQL Server Using Wait Stats

SolarWinds sponsored on-demand webinar

Webcast Abstract

Databases are the backbone of business-critical applications. There are many approaches to troubleshooting, tuning, and optimizing SQL Server® performance. But where should you begin to look when performance degrades and users complain?

One of the first things you should check when investigating performance issues are wait statistics - as these can often point you in the direction for further analysis.

In this webcast, SolarWinds PMM Owen Murphy will explore the world of SQL Server wait stats. We will discuss how wait stats can be combined with other SQL Server metrics to provide the necessary information to resolve performance issues.

There are hundreds of wait stats available in SQL Server, in this session we’ll deep dive into a few including:

• CXPACKET Waits
• ASYNC_NETWORK_IO Waits
• PAGEIOLATCH_SH
• LCK_M_XX Waits

Speaker - Owen Murphy and Thomas LaRock

To access materials please fill out the form below.