Explanation:If counter is between 50 to 70 % consistently, investigate the process which is taking long time. 5. 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
Answer:A
Explanation:If counter is between 50 to 70 % consistently, investigate the process which is taking long time. 5. 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
Explanation: Index optimization can reduce this problem. 6. Which of the following stored procedure reports snapshot information about current SQL Server user ?