Management Data Collection Disk Usage Summary Report Timeout

Question

SQL Server 2008 10.0.2766 

When we run a disk summary report the system hangs on the "retrieving data" panel for about 10 minutes and then time's out.  Anyone else having a similar issue? 

The error is the following:

"

Error:

timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding

"

Is there a setting to allow a longer period of time to generate disk summary reports? 

Answer 1

It looks the query have timed out due to exceed the time out value although it is much wide ( Around 25 times as estimated query execution time) , thereby you have to give insight on the below check list to be able to fix it :

• Check expensive queries to find out relevant query and try to conduct any possible enhancements
• Check heavy locks /deadlocks and double check it this query is participating  within any locks circumstances
• Check Server resources utilization in particular more CPU +Memory and assure they are healthy

Irrespective that , kindly share with me this expensive query that time out to be able t help in figuring out any possible enhancements

Kindly check on them and let me know your feedback

---

Shehap (DB Consultant/DB Architect) Think More deeply of DB Stress Stabilities