Date: Thu, 28 Mar 2024 12:37:51 +0000 (UTC) Message-ID: <765846715.67893.1711629471678@ip-10-0-1-26.ec2.internal> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_67892_1700091760.1711629471673" ------=_Part_67892_1700091760.1711629471673 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
The Query Waits view displays the queries on your SQL Server instanc= e with the longest wait times. By default, the chart at the bottom of the v= iew displays the query waits over time and allows you to further investigat= e based on Statements, Applications, Databases, Clients, Sessions, and User= s.
By ana= lyzing these waits you can better determine where your biggest bottlenecks = are occurring and what changes could potentially have the biggest performan= ce boost on your SQL Server instance.
You ca=
n select to view query waits as the waits appear over time or by duration o=
f the wait, color coded by query. The chart includes each of the following =
wait type categories: Backup, I/O, Lock, <=
a class=3D"external-link" href=3D"http://wiki.idera.com/x/OgE1" rel=3D"nofo=
llow">Memory, Non-I/O Page Latch, Non-Page Latch,=
Transaction Log, and Other.
=
To pen= the Query Waits view of the SQL Diagnostic Manager Queries tab, select the= appropriate SQL Server instance, select Queries, and= click Query Waits.
=
span>