IO requests and update statistics

Last Post 05 May 2008 12:33 AM by SQLUSA. 1 Replies.
AddThis - Bookmarking and Sharing Button
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


Acceptable Use Policy
---