IO requests and update statistics

Last Post 05 May 2008 12:33 AM by SQLUSA. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
trans53
New Member
New Member

--
04 May 2008 09:40 PM

Hi all,

I noticed that during nightly update statistics job we have warning below:

SQL Server has encountered 19 occurrence(s) of IO requests taking longer than 15 seconds to complete on file.


Is this usualy an indication of saturated disk subsystem?

Thanks
SQLUSA
New Member
New Member

--
05 May 2008 12:33 AM
Check out this article:

http://support.microsoft.com/kb/897284


Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQL Server Training, SSAS, SSIS, SSRS, Performance Tuning: http://www.sqlusa.com/order2005highperformance
You are not authorized to post a reply.

Acceptable Use Policy