IO requests and update statistics

Last Post 04 May 2008 11:33 PM 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 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
You are not authorized to post a reply.

Acceptable Use Policy