adkmom
Technical User
- Nov 13, 2002
- 71
MS Exchange 2003
Approx. 130 users
SQL Server Std. Ed. 8.00.2194 (SP4)
The issue we're trying to pinpoint is the "freezing" of a database program while in use. The program hangs for anywhere from 5 secs- 2 min. The problem is intermittent but the log points to multiple instances...
This is one of the error messages in the SQL server log:
"SQL Server has encountered 11,184 occurances of I/O requests taking longer than 15 secs. to complete on file (tempdb.mdf) in database tempdb (2). The OS file handle is 0x000004D8. The offset of the latest long I/O is 0x0000009d4b2000"
We checked the file growth parameters (were set as "auto-grow", in 1mb increments)- and we changed to 50mb increments. Recommended MS setting is 10% according to the size of our temp DB (currently 3.3GB)- but we want to see if this marginal increase makes any difference to the DB programs freezing or not.
Any advice on how to go about resolving this is greatly appreciated. Server/SQL experience is not our strongest suit, so pointers/explanations in layman's terms (if possible) would be most helpful.
TIA,
Tracy
Approx. 130 users
SQL Server Std. Ed. 8.00.2194 (SP4)
The issue we're trying to pinpoint is the "freezing" of a database program while in use. The program hangs for anywhere from 5 secs- 2 min. The problem is intermittent but the log points to multiple instances...
This is one of the error messages in the SQL server log:
"SQL Server has encountered 11,184 occurances of I/O requests taking longer than 15 secs. to complete on file (tempdb.mdf) in database tempdb (2). The OS file handle is 0x000004D8. The offset of the latest long I/O is 0x0000009d4b2000"
We checked the file growth parameters (were set as "auto-grow", in 1mb increments)- and we changed to 50mb increments. Recommended MS setting is 10% according to the size of our temp DB (currently 3.3GB)- but we want to see if this marginal increase makes any difference to the DB programs freezing or not.
Any advice on how to go about resolving this is greatly appreciated. Server/SQL experience is not our strongest suit, so pointers/explanations in layman's terms (if possible) would be most helpful.
TIA,
Tracy
