You are a database administrator for AIOTestKing.com. Users report that a SQL Server 2005 application is performing slowly. You need to identify the queries that are experiencing slow performance due to blocking. What should you do?
A.
In a SQL Trace log file, look for queries that have low duration values and high read and write values.
B.
In a SQL Trace log file, look for queries that have high duration values and low read and write values.
C.
In a query execution plan, look for queries that have a large number of table scans.
D.
In a query execution plan, look for queries that have missing or out-of-date statistics.
Explanation:
A high duration value in combination with low read and write values indicates that the query has trouble finding the data it is searching for and uses most of the time just to search for the location of the data.