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

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


Also
http://blogs.msdn.com/sqlserverstorageengine/archive/2006/06/21/642314.aspx




"Uri Dimant" <urid@xxxxxxxxxxx> wrote in message
news:e8XVkHw%23JHA.5092@xxxxxxxxxxxxxxxxxxxxxxx
See if this helps
http://support.microsoft.com/kb/897284




"Suchi" <Suchi@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BBA56E61-81BB-4B07-8F9E-D3D193FFC474@xxxxxxxxxxxxxxxx
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

  • 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 than ...
    (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)