August 28, 2008 at 8:09 am
SQL Server has encountered % occurrence(s) of IO requests taking longer than 15 seconds to complete on file.
has any one encountered this error? We have A SQL Server 2000 Enterprise at SP4.
Warm Regards,
Arthur Lorenzini
Sioux Falls, SD
August 28, 2008 at 12:25 pm
It's teling you that there are slow IOs occuring. The typical range for a single IO operation should be 10-50 ms at the most. The warning is saying that in a period of (I think) 2 minutes, a certain number of IOs issued to the OS have not completed 15 seconds later.
Typically this indicates disk bottleneck problems, or a problem somewhere in the IO stack (like an antivirus)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply