IO requests and update statistics

Last Post 04 May 2008 11:33 PM by SQLUSA. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
trans53
New Member
New Member

--
04 May 2008 08: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

--
04 May 2008 11:33 PM
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


Acceptable Use Policy
---