August 13, 2013 at 11:38 pm
Getting below message in error log when DBCC CHECKDB is running.
SQL Server has encountered x occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [Drive:\MSSQL\MSSQL.1\MSSQL\Data\xyz.mdf] in database [database]. The OS file handle is 0x00000000. The offset of the latest long I/O is: 0x00000000000000
I never see this message other than DBCC CHECKDB.
Is this indicating any IO bottleneck or its normal to see this message while running DBCC CHECKDB ?
August 14, 2013 at 2:44 am
can you provide more detail about your I\O subsystem?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2013 at 7:44 am
This is one of the most difficult things to debug. It indicates that sql server sent a request to your storage and it is taking over 15 seconds to get a response back when it should be below 10 milliseconds.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply