Optimize-WSUS

1.0

Optimize WSUS and its DB using official Microsoft SQL script and performs server maintenance.
    
  Prerequisites for running Invoke-Sqlcmd

  1. Save T-SQL script as WsusDBMaintenance.sql from: https://docs.microsoft.com/en-us/troubleshoot/mem/configmgr/reindex-the-wsus-database
  
  2. Navigate to: https://www.microsoft.com/en-US/download/details.aspx?id=55992
Optimize WSUS and its DB using official Microsoft SQL script and performs server maintenance.
    
  Prerequisites for running Invoke-Sqlcmd

  1. Save T-SQL script as WsusDBMaintenance.sql from: https://docs.microsoft.com/en-us/troubleshoot/mem/configmgr/reindex-the-wsus-database
  
  2. Navigate to: https://www.microsoft.com/en-US/download/details.aspx?id=55992 and install SQLSysClrTypes.msi
  
  3. Run from PowerShell
      - Register-PackageSource -provider NuGet -name nugetRepository -location https://www.nuget.org/api/v2
      - Install-Package Microsoft.SqlServer.SqlManagementObjects  
  
  4. Run from PowerShell: Install-Module -Name SqlServer
  

Installation Options

Copy and Paste the following command to install this package using PowerShellGet More Info

Install-Script -Name Optimize-WSUS

You can deploy this package directly to Azure Automation. Note that deploying packages with dependencies will deploy all the dependencies to Azure Automation. Learn More

Manually download the .nupkg file to your system's default download location. Note that the file won't be unpacked, and won't include any dependencies. Learn More

Author(s)

Juan Granados

Copyright

2021 Juan Granados

Owners

Tags

WSUS Optimice Database SQL WID DB

Functions

check-requisites

Dependencies

This script has no dependencies.

Release Notes

Initial release

Version History

Version Downloads Last updated
1.0 (current version) 24 8/27/2021