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 |
|
Gangrel189
Starting Member
1 Post |
 Posted - 2011-07-06 : 15:04:40
|
| While running a VB6 application on a SQL 2005 SP2 database:- Every day about twice a day a user gets a RTE 2147217871 Timeout Expired. Twice over the past couple months a complete system and SQL slow down has occurred where the entire application was getting RTE. The CPU did not move above 1% and I/O and memory were fine. SQL itself was running extremely slow trying to accomplish anything. After about 45 minutes of this the CPU suddenly and without any of our doing jumped up to 90% and within minutes SQL was running normally and up to speed.-How do we go about getting to the problem of the RTE 2147217871 Timeout Expired if it is happening randomly throughout the day? Is there any advice that you might prevent as we are at the end of our ropes at this point |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-07-06 : 15:54:00
|
| Is the application running on the same machine as the server? If not which machine does the io and cpu monitoring come from?Can't immediately think of anything that could cause this apart from blocking.Slowdown like this usually happens due to something taking up all the io.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
RTE 2147217871 Timeout Expired