The Patch Manager database stores all consolidated data from a WSUS inventory, Managed Computer inventory, and Discovery tasks. To generate a WSUS inventory report for this data, the Patch Manager Administrator Console pulls the data directly from the database.
When you install your Patch Manager servers, you have several Microsoft® SQL Server® database configuration options. You can install:
- SQL Server Express on the Patch Manager server
- SQL Server on the Patch Manager server
- SQL Server on a remote server
To ensure optimal performance, SolarWinds recommends the following:
- Use SQL Server 2008 R2 Express Edition (included with the Patch Manager installer) for Patch Manager servers that require less than 10 GB of storage space.
If you exceed 10 GB, you must migrate your database to an SQL Server instance.
- Use a licensed version of SQL Server for Patch Manager servers that support multiple console users, inventory multiple WSUS servers, or execute simultaneous WMI-based tasks. These configurations require high reporting services.
- Use a remote database server for Patch Manager server roles hosted on a WSUS or SCCM server.
- Deploy additional Management Server roles to split storage requirements between each additional server.