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.
| Author |
Topic |
|
ias0nas
Starting Member
36 Posts |
 Posted - 2012-03-26 : 16:14:51
|
| Hello,Using SQL 2005, we have a few databases. For a couple of minutes we kept receiving timeouts from websites accessing at least two of the databases.The error message is the standard SqlClient one:Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.There is nothing in the Windows Event Log or the SQL logs around that time.Any ideas?Thanks |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-03-26 : 16:36:33
|
| Was that once off, or does it happen repeatedly?--Gail ShawSQL Server MVP |
 |
|
|
ias0nas
Starting Member
36 Posts |
Posted - 2012-03-27 : 02:26:42
|
| Hi Gila,Just once, we have had this set-up for four years now and haven't seen this happening before. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-03-27 : 04:31:02
|
| Unfortunately if you don't have stats from that period (sys.dm_exec_requests, sys.dm_os_waiting_tasks at a minimum) it's going to be very, very hard (or impossible) to figure out what happened. Could easily have been a single rogue query taking all the server's resources, could have been something in windows like a file copy, could have been a few other things--Gail ShawSQL Server MVP |
|
|
|
|
|
|
SQL not accessible for a few minutes, no logs