February 28, 2009 at 9:36 am
All of a sudden all the processes are failing on SQL Server because of the timeout error. It was running fine before but not lot of processes are giving timeout error.
I appreciate if somebody will help me. What need to be check on sql server.?
February 28, 2009 at 8:07 pm
Hello,
Did you see this TechNet article:-
http://technet.microsoft.com/en-us/library/ms190181(SQL.90).aspx
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
March 1, 2009 at 12:58 am
balbirsinghsodhi (2/28/2009)
All of a sudden all the processes are failing on SQL Server because of the timeout error. It was running fine before but not lot of processes are giving timeout error.I appreciate if somebody will help me. What need to be check on sql server.?
review the sql server and event logs for more details...It may happen b'cause of blocking/deadlock
Regards,
[font="Verdana"]Sqlfrenzy[/font]
March 2, 2009 at 7:20 am
I had this issue come up in November. This is SO generic you probably will never track down where it is coming from. I placed a call to Microsoft for help and they gave us a Windows patch (Win2003) to apply to the server and basically what it does is will not fix the problem but will give more detailed info on what is causing this. In the meantime the query that was causing it I rebuilt the indexes and the query was able to run in less than 60 seconds and the problem went away.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply