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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-10-27 : 07:58:26
|
| Craig writes "Since upgrading to SQL Server SP4 build 2187, when running DBCC INDEXDEFRAG, our application receives 'OLE DB Provider for SQL Server - Timeout Expired' errors. We have the timeout set at the default of 15 seconds, and plan to increase it. However, since we never experienced this problem prior to SP4; I would like to find a better solution that speeds up the IO. We are tunning all the queries and have seen minimal blocking; so it appears to be a massive slowdown in IO produced by INDEXDEFRAG running that worked fine in prior service packs. We are also getting the 'IO operation required more than 15 seconds' errors that previously never occurred. Has anyone experienced similar problems and found a resolution?" |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-10-27 : 09:59:00
|
| Sounds like you're experiencing thishttp://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=58294 |
 |
|
|
|
|
|
Indexdefrag Causes Timeouts