Post reply

Microsoft Security Update for Windows Server 2003 (KB956572) increases I/O waits for SQL Server 2005

  • July 1, 2009 at 7:31 am

    #206123

    We have a database on a windows server 2003 server running SQL 2005. This database experiences an increase in all I/O related SQL waits when the KB956572 patch is installed. These waits include the WRITELOG, PAGEIOLATCH_SH and PAGEIOLATCH_EX. The wait times for these waits increase as much as 400% when the patch is in place and these three waits represent as much as 98% of the overall SQL wait times. If the patch is backed out the wait times decrease and return back to what we were seeing before. Has anyone experienced something similar with this patch or any other patch that will increase the I/O?

  • August 20, 2009 at 6:37 pm

    #1042531

    We are experiencing the same problem, several updates were applied couple weeks ago and one of them is the KB956572. Our ETL now takes more than twice as long. Planning to remove the update tomorrow and see how it goes.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply