SQLhas encountered 2 occurrence(s) of IO requests taking longer th

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


HI All,

Environment:

WIN2003 Enterprise Edition
SQL2000 with SP4(cluster with 2 nodes)

I see below messages in SQL logs almost everyday for tempdb and for other
few databases. They are more for tempdb. The Tempdb is on seperate drives.

SQL Server has encountered 1 occurrence(s) of IO requests taking longer than
15 seconds to complete on file [V:\MSSQL\Data\tempdata7.NDF] in database
[tempdb] (2).
The OS file handle is 0x000004B1. The offset of the late st long IO is:
0x00000005acb90000 1
2009-07-02 01:47:31.31 spid1 SQL Server has encountered 1 occurrence(s)
of IO requests taking longer than 15 seconds to complete on file
[X:\mssql\data\database1.MDF] in database [database1] (12). The OS file
handle is 0x00000628. The off 0
set of the latest long IO is: 0x0000000da88000 1
2009-07-02 01:47:31.31 spid1 SQL Server has encountered 1 occurrence(s)
of IO requests taking longer than 15 seconds to complete on file
[P:\mssql\data\tempdata1.ndf] in database [tempdb] (2). The OS file handle
is 0x00000550. The offset of the late 0
st long IO is: 0x000000297b4000 1


We have total 10 tempdb files(8 data and 2 log) spread on 2 Drives.Our
windows team checked the health of the physical drives and they said no
issues with the disk drives.The tempdb is auto growth is turned on .

How i resolve this issue? Any ideas?

Thanks in Advance
Suchi
.

Relevant Pages

  • Re: SQLhas encountered 2 occurrence(s) of IO requests taking longer th
    ... I see below messages in SQL logs almost everyday for tempdb and for other ... few databases. ... They are more for tempdb. ... SQL Server has encountered 1 occurrenceof IO requests taking longer ...
    (microsoft.public.sqlserver.server)
  • Re: tempdb mdf and ldf placement
    ... > or LDF files from user or system databases. ... > the tempdb MDF and LDF to separate hard drives or can they ... If it has a LOT of activity, then a RAID 0 might be your best choice. ...
    (microsoft.public.sqlserver.server)
  • Re: Migrating to new hardward
    ... Moving SQL Server databases to a new location with Detach/Attach ... There is a specific section on moving tempdb. ... recreating the clustered index and specifying a filegroup for the new table. ...
    (microsoft.public.sqlserver.setup)
  • Re: SQLhas encountered 2 occurrence(s) of IO requests taking longer th
    ... I see below messages in SQL logs almost everyday for tempdb and for other ... They are more for tempdb. ... SQL Server has encountered 1 occurrenceof IO requests taking longer ... The offset of the late st long IO is: ...
    (microsoft.public.sqlserver.server)
  • Re: Moving tempdb
    ... there are two databases on the server that are being used. ... I also have another server running a database about 16GB in size. ... I'm planning on moving our tempdb to it's own LUN but I'm not sure what ...
    (microsoft.public.sqlserver.setup)