Friday, March 23, 2012 7:34 PM
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:
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?
- Edited by MikeyBlueEyes Friday, March 23, 2012 7:34 PM
Wednesday, July 18, 2012 5:30 AM
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