This is the second in a series of posts in which I will try to journal some of the steps we took to address a busy hard drive.
In the previous post we spoke about how we configured svchost.exe to run on separate processes and thus we are better positioned to identify which specific services are driving I/O.
Inclusive in the services identified are Windows Management and Windows Updates.
Once we saw that Windows Update was one of the main drivers we tried to see which updates was causing the problem.
To launch the Automatic Updates we clicked on the icon on the right bottom panel.
Microsoft SQL Server 2005 Express Edition Service Pack 4 ( KB2463322 ) AND Microsoft SQL Server 2005 Express Edition Toolkit Service Pack 4 ( KB2463322 )
The screens that we encountered are:
- How do you want to install updates
- Choose Updates to install
- The updates are being installed
- Some updates could not be installed
How do you want to install the updates
Post Selection Screen
We chose “Custom Install (Advanced )” to gain better insight as to what is being installed are have more control as to which ones we can opt out of.
Choose Updates to install
Here are the updates
- Microsoft SQL Server 2005 Express Edition Service Pack 4 (KB2463332)
- Microsoft SQL Server 2005 Express Edition Toolkit Service Pack 4 (KB2463332)
The updates are being installed
Here are the first of two updates are being applied
The updates are being installed ( Post First Patch )
Unfortunately, the first patch failed.
And, the second patch is now being applied.
Some updates could not be installed.
Here both updates failed.
The troubleshooting steps available to us are the following:
- Check Event Viewer
- Check Windows Update log files
Here are some sample entries from c:\windows\windowsUpdate.log
Entries – 2017-03-19 3:54
Opted out SP4
Choose updates to install
Unchecked both packages.
Here we are opting out of this release not just for now, but for always.
A number of years ago all the cool kids wore a tee shirt that read “Got tired of patch Tuesday, went Googling”.
It is not that bad for us, we will just go the manual install path.