Message

Hi All,
Our SQL server is logging following message. Most of these message are
logged by spid 2: (lazyWriter)
SQL Server has encountered 1 occurrence(s) of IO requests taking longer than
15 seconds to complete on file [I:\XXX_Data.MDF] in database [XXX] (
17).
The OS file handle is 0x00000554. The offset of the latest long IO is:
0x000000175b8000
Any idea how can i get to the bottom of it.
Thanks
vtvt
run DBCC CHECKDB command to see what is going on.
"vt" <vinu.t.1976@.gmail.com> wrote in message
news:e4TGCvuEHHA.5028@.TK2MSFTNGP03.phx.gbl...
> Hi All,
> Our SQL server is logging following message. Most of these message are
> logged by spid 2: (lazyWriter)
> SQL Server has encountered 1 occurrence(s) of IO requests taking longer
> than 15 seconds to complete on file [I:\XXX_Data.MDF] in database [
;XXX]
> (17). The OS file handle is 0x00000554. The offset of the latest long IO
> is: 0x000000175b8000
> Any idea how can i get to the bottom of it.
> Thanks
> vt
>|||Hi,
This message was introduced from SQL 2000 SP4. This denotes that I/O
processing of SQL Sever is slowed down. This normally comes if the disk
write speed is slow down.
Take a look into the below URL:-
"vt" <vinu.t.1976@.gmail.com> wrote in message
news:e4TGCvuEHHA.5028@.TK2MSFTNGP03.phx.gbl...
> Hi All,
> Our SQL server is logging following message. Most of these message are
> logged by spid 2: (lazyWriter)
> SQL Server has encountered 1 occurrence(s) of IO requests taking longer
> than 15 seconds to complete on file [I:\XXX_Data.MDF] in database [
;XXX]
> (17). The OS file handle is 0x00000554. The offset of the latest long IO
> is: 0x000000175b8000
> Any idea how can i get to the bottom of it.
> Thanks
> vt
>|||Hi,
This message was introduced from SQL 2000 SP4. This denotes that I/O
processing of SQL Sever is slowed down. This normally comes if the disk
write speed is slow down.
Take a look into the below URL:-
http://support.microsoft.com/kb/897284
Thanks
Hari
"vt" <vinu.t.1976@.gmail.com> wrote in message
news:e4TGCvuEHHA.5028@.TK2MSFTNGP03.phx.gbl...
> Hi All,
> Our SQL server is logging following message. Most of these message are
> logged by spid 2: (lazyWriter)
> SQL Server has encountered 1 occurrence(s) of IO requests taking longer
> than 15 seconds to complete on file [I:\XXX_Data.MDF] in database [
;XXX]
> (17). The OS file handle is 0x00000554. The offset of the latest long IO
> is: 0x000000175b8000
> Any idea how can i get to the bottom of it.
> Thanks
> vt
>|||Done that.. not showing any problem..
it is not just on one database, all the database that are on one specific
drive..
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:O9bE9yuEHHA.1224@.TK2MSFTNGP04.phx.gbl...
> vt
> run DBCC CHECKDB command to see what is going on.
>
>
> "vt" <vinu.t.1976@.gmail.com> wrote in message
> news:e4TGCvuEHHA.5028@.TK2MSFTNGP03.phx.gbl...
>|||Hi hari,
I know that its a disk performance problem.. Ours is a RAID5 setup.
We have done the disk diagnostic, but it came up with no errors...
Another question is why LazyWriter process is logging it..
vt
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:uzVi%230uEHHA.992@.TK2MSFTNGP03.phx.gbl...
> Hi,
> This message was introduced from SQL 2000 SP4. This denotes that I/O
> processing of SQL Sever is slowed down. This normally comes if the disk
> write speed is slow down.
>
> Take a look into the below URL:-
>
> "vt" <vinu.t.1976@.gmail.com> wrote in message
> news:e4TGCvuEHHA.5028@.TK2MSFTNGP03.phx.gbl...
>|||Take a look at Performance Monitor disk counters, particularly disk queue
length. A value that averages more than 2 * the number of physical disks in
the logical drive indicates a bottleneck. Distributing the workload over
more disks can help, either by adding more drives to the array or placing
database files on other drives/arrays. If you do a lot of writes, use RAID
10 instead of RAID 5.
Hope this helps.
Dan Guzman
SQL Server MVP
"vt" <vinu.t.1976@.gmail.com> wrote in message
news:e4TGCvuEHHA.5028@.TK2MSFTNGP03.phx.gbl...
> Hi All,
> Our SQL server is logging following message. Most of these message are
> logged by spid 2: (lazyWriter)
> SQL Server has encountered 1 occurrence(s) of IO requests taking longer
> than 15 seconds to complete on file [I:\XXX_Data.MDF] in database [
;XXX]
> (17). The OS file handle is 0x00000554. The offset of the latest long IO
> is: 0x000000175b8000
> Any idea how can i get to the bottom of it.
> Thanks
> vt
>