Question

Point out the correct statement.

(a) Slow SELECT queries with high physical reads and low queue lengths demonstrates under performance of Disk read and write

(b) If many simultaneous requests are waiting, investigate the process which is taking less time

(c) SQL Server 2008 R2 Data Collection provides information about SQL Server processes and how these processes affect the current instance of SQL Server

(d) All of the mentioned

I had been asked this question in an interview.

Origin of the question is Performance Monitoring in portion Monitoring and Auditing of SQL Server

Answer 1

Right option is (a) Slow SELECT queries with high physical reads and low queue lengths demonstrates under performance of Disk read and write

Explanation: Index optimization can reduce this problem.