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 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 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...
>> 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
>|||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
>

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
vt
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 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
>

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
>

mesage in Sql Server 2000 log

I 'm using SQL Server 2000 Enterprise Edition in Windows 2000 Sever
box.

Now , message

"SQL Server has encountered 1 occurrence(s) of IO requests taking
longer than 15 seconds to complete on file [D:\DATABASE\xxxxxx.MDF] in
database [aaaaaaa] (7). The OS file handle is 0x00000354. The offset
of the latest long IO is: 0x00000086692000"

has occasionally occurred during a scheduled task of reorganize data
and index pages of
database maintenance plan.

The scheduled task is running every day started at 1:00 am and the
message occurs during
no users have connected to the DB.

Please kindly explain what the message is about and how to prevent it
to occurred if it is
serious

Thank you
NiponNiponW (niponw@.yahoo.com) writes:
> I 'm using SQL Server 2000 Enterprise Edition in Windows 2000 Sever
> box.
> Now , message
> "SQL Server has encountered 1 occurrence(s) of IO requests taking
> longer than 15 seconds to complete on file [D:\DATABASE\xxxxxx.MDF] in
> database [aaaaaaa] (7). The OS file handle is 0x00000354. The offset
> of the latest long IO is: 0x00000086692000"
> has occasionally occurred during a scheduled task of reorganize data
> and index pages of
> database maintenance plan.
> The scheduled task is running every day started at 1:00 am and the
> message occurs during
> no users have connected to the DB.
> Please kindly explain what the message is about and how to prevent it
> to occurred if it is
> serious

This is a diagnostic message, that indeed may indicate that things are
not really up to shape. But if it occurs only occasionally, I would not
take any action now more than to continue to monitori the situation.

You can read more in this KB article:
http://support.microsoft.com/?kbid=897284

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx