February 8, 2016 at 6:26 pm
Hi,
We have Sql server 2005. User databases are in one drive and system databases are in C:/ drive.
We are gettting alerts about Event ID: 833 from both user databases and system databases?
Is surely indicate IO issues?
February 9, 2016 at 2:03 am
For anyone reading this who doesn't memorise error numbers.
Error 833: SQL Server has encountered <n> occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [<full path of file>] in database [<database name.>] (<dbid>). The OS file handle is <file handle>. The offset of the latest long I/O is: <offset in hexadecimal>
Yes, it's an IO latency problem. IO requests, which should take no more than 50ms are taking over 15 seconds.
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