Monday, February 20, 2012

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

No comments:

Post a Comment