Ratheesh.K.Nair (10/1/2014)
Hi experts,Is there anyway to check if server is having disk latency or IO issues?
Found below in SQL error log
Date10/1/2014 8:28:58 AM
LogSQL Server (Current - 10/1/2014 12:00:00 AM)
Sourcespid10s
Message
SQL Server has encountered 8500 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [D:\Fin.mdf] in database [Fin] (5). The OS file handle is 0x0000000000001368. The offset of the latest long I/O is: 0x0001104a7da000
If you are getting that message, there is no need to check if the server has IO problems. It can hardly get worse than >15000 milliseconds for an IO to happen!!
You have VERY BAD IO problems. There are LOTS of things that can be at fault here. Most common is a) too little RAM in server and b) too few rotating spindles serving up data/log.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service