SQL Server has encountered 17 occurrence(s) of IO requests taking longer than 15 seconds to complete on file
Posted on 2008-06-20
I recieved following errors in one of the sql server today morning.
1. 2008-06-17 21:52:55.42 server Insufficient memory available..
2.2008-06-20 07:30:30.40 spid55 SQL Server has encountered 17 occurrence(s) of IO requests taking longer than 15 seconds to complete on file [E:\Program Files\Microsoft SQL Server\MSSQL\data\MYDATABASE3.mdf] in database [MYDATABASE2] (9). The OS file handle is 0x0000 0
0430. The offset of the latest long IO is: 0x000000b4bcc000
3. 2008-06-17 21:54:19.90 server Process 12:0 (fe8) UMS Context 0x002A8DD0 appears to be non-yielding on Scheduler 3.
4.2008-06-17 21:47:19.91 server Potential deadlocks exist on all the schedulers.
Today morning customer reported the timeouts for thier application. PLease help me on this.