February 9, 2012 at 9:26 am
I came across the following errors in SQL logs.
SQL Server has encountered 3 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [filePath] in database [DatabaseName] (8). The OS file handle is 0x000000000000088C. The offset of the latest long I/O is: 0x00000351580000
How to fix this issue?
Any input will be greatly appreciated.
February 9, 2012 at 9:39 am
Your I/O subsystem seems to have performance issues.
Is this a dedicated box or there are other processes running on the machine?
Is this a SAN or DAS?
-- Gianluca Sartori
February 9, 2012 at 9:41 am
BTW, a simple Google search could have helped:
(fourth result in my Google search)
-- Gianluca Sartori
February 9, 2012 at 9:59 am
Additionally this could be caused by database file growth when instant file initialization is not enabled, in particular when growing very frequently in tiny (1MB increments) or when a file is growing by a percentage and is in a large chuck (say > 5GB)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply