Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Error

Author  Topic 

Peter99
Constraint Violating Yak Guru

498 Posts

Posted - 2012-06-07 : 12:24:33
Hi,

we received this error:

The database command timed out. The command category was DatabaseCommand.ExecuteNoRowsetInternal and the timeout was set to 5 seconds. More details have been logged to the Windows Event Viewer's Application log.

Can we do something from database side or application/server guys should fix it.

Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-06-07 : 13:18:53
Well it depends why it timed out. Grab the query and put it into SSMS to do some analysis. Check statistics IO and time as well as the query plan.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Peter99
Constraint Violating Yak Guru

498 Posts

Posted - 2012-06-07 : 15:12:10
Thanks Tara.
Go to Top of Page
   

- Advertisement -