Frequently reported in Error log file.
SQL Server has encountered 116 occurrence(s) of I/O requests taking longer than 15 seconds
to complete on file [E:\Program Files\Microsoft SQL Server
\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\datafile.mdf] in database [DBNAME] (6).
The OS file handle is 0x0000000000000B30.
The offset of the latest long I/O is: 0x00000265590000
Generally Longer IO cause of Index fragementation is high. so configured Index rebuild on daily at off peak time then error was not reported at error log file and resolved. Before that I used rebuild index Management plan option on weekly basis.
I used customize index rebuild script by Mr. Michelle (http://sqlfool.com/). Thank you Michelle. It is very useful for biggest database.
http://www.sqlservercentral.com/Forums/Topic762772-146-2.aspx - there is one thread as Gila suggested, there is problem in IO subsystem at H/W side. Pls.suggestion me what are the points should be check at H/W?
Currently DB version: SQL 2K8R2 x64 bit with SP2, CU1.