If you're having trouble, there's also a -HelpMe option that will create a log so you can send it to me for support.Tip: How to correctly select the file you need If you wish to view or increase the Application Pool Memory Configuration, or run the Dirty Database Check, you must run it with the required switch. After installing the prerequisites and configuring the variables for your environment (email settings only if you are accepting all the defaults), simply run: There are some prerequisites and instructions at the top of the script. It will email the report out to you or save it to a file, or both.Īlthough the script is lengthy, it has been made to be super easy to setup and use so don't over think it. Run the Recommended SQL database Maintenance script on the actual SQL database. This is primarily for Server 2012 WSUS, and is a manual execution only.ġ1. Checks to see if you have a dirty database, and if you do, fixes it. Application Pool Memory Configuration to display the current private memory limit and easily set it to any configurable amount including 0 for unlimited. Computer Object Cleanup (configurable, with the default of deleting computer objects that have not synced within 30 days).ĩ. Clean out all the synchronization logs that have built up over time (configurable, with the default keeping the last 14 days of logs).Ĩ. Remove declined updates from the WSUS Database.ĥ.

Optional extras: Language Packs, IE7, IE8, IE9, IE10, Embedded, NonEnglishUpdates, ComputerUpdates32bit, WinXP.Ĥ. Shrink your WSUSContent folder's size by declining multiple types of updates including by default any superseded updates, preview updates, expired updates, Itanium updates, and beta updates. Remove all Drivers from the WSUS Database (Default Optional).ģ. Add WSUS Index Optimization to the database to increase the speed of many database operations in WSUS by approximately 1000-1500 times faster.Ģ. It is an automated maintenance system for WSUS, the last system you'll ever need to maintain WSUS!ġ. Please have a look at the WSUS Automated Maintenance (WAM) system. Then WAM your WSUS Server! - You will see the light! Notice how long everything takes when you're moving around in WSUS. Note the speed of how long they take to run. Once you get it up and running, run a few reports to see how you're getting along.

2008 report viewer download