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 |
|
RandyLisle
Starting Member
2 Posts |
 Posted - 2008-06-25 : 08:26:56
|
| The once a day for the past 3 days one of our clients has been getting a series of SQL timeouts from our .Net app on any insert or updates. When I go to the database I can query easily but the first update I run (updating one field, on one record to its current value, by the primary key) takes over 2 minutes. However, once that fist update has run the timeouts stop, and other updates are back under a second. It seems since my management studio doesn't have a low timeout it lets the update finish and that "unclogs the drain". I did not see any blocks when I was running the update.Does anyone have any idea why the db would seemingly need one long running update before others could process at a normal speed?In case you were wondering:The timeouts had been going on for at least 30 minutes before I got into the DB to look at what was happening. This application has been in production for 2 years, with the last major update being several months ago. |
|
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
Posted - 2008-06-25 : 11:23:42
|
| Are you indices on tables are healthy? (Check DBCC Showcontig on tables and check the result.)Are the statisitcs updated one? (Check DBCC Show_statistics for all tables)Don't sit back because of failure. It will come back to check if you still available. -- Binu |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-27 : 23:09:03
|
| Checked blocking on the table? |
|
|
|
RandyLisle
Starting Member
2 Posts |
Posted - 2008-06-28 : 11:44:09
|
| I don't see any problems with the statistics or contig. Everything seems healthy. It also seems to be the entire DB, not just one table.There is no blocking showing when I'm running the updates it just seems to require one long running update to let everything else run free.I'm really stumped |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-28 : 21:59:45
|
| Tried trace it in profiler? |
|
|
|
|
|
|
Strange Timeout Issue