Loading the player...

Transcript

Expand

Hello and welcome to this video on how to view and use the query waits. The Query Waits tab allows you to analyze weights over time in two different views: the query weights over time and the query weights by duration. This will allow you to better determine where your biggest bottlenecks are occurring and what changes could potentially have the biggest performance boost in your SQL Server instance. The chart includes each of the following way type categories: backup, […ka], lock, memory, […], page latch, page launch transaction log, and others. The first view would be query weights over time. Under queries and query weights you can see what types of queries you have in your SQL Server in real-time or historical time. You will see the weight categories along with the time frame on the bottom. On the y-axis, you will see the total wait time in milliseconds. My preferred way of doing this is by selecting the query weights by duration. Switching the view here allows you to see a different representation of the weights. This time by duration. I can approach this in a few ways. One is by drilling down from the biggest weight offender to understand what statements from what applications, what databases, users in sessions this is coming from. The second approach will be from an application standpoint. Let us say a user will call me and they say a particular application is slow. I can narrow down all the categories statements databases and users that are only being used by that application. Drilling down allows me to see the wait category. The statement that I can right-click. And see the complete sequence. And copied that to the clip. Going further I can see the database client sessions and user affecting this wait. Thank you. And for more information visit idera.com.

How to View and Use Query Waits in SQL Diagnostic Manager

IDERA SQL Diagnostic Manager is a powerful performance monitoring and diagnostics solution that proactively alerts administrators to health, performance, or availability problems within their SQL Server environment. SQL Diagnostic Manager allows DBAs to discover potential and existing problems, analyze the state of their SQL Server enterprise, and generate reports.

Using a unique agent-less architecture, SQL Diagnostic Manager gathers diagnostic information in real time, keeping database administrators and managers informed by providing customized alerts The deployment of SQL Diagnostic Manager comes in two parts. The installer automatically deploys the IDERA Dashboard which is an interface for IDERA products and next it installs SQL Diagnostic Manager application Learn More →

Start a FREE Trial of SQL Diagnostic Manager
Share This
Contact IDERA:
+1 (713) 523-4433