Posted by NiponW on 01/12/06 02:37

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
Nipon

• Next in forum: Re: selecting only numeric data from a string
• Prev in forum: selecting only numeric data from a string
• Thread view: mesage in Sql Server 2000 log

[Reply to this message]