Security Compliance

Patch Manager SQL database requirements

This article details the SQL Server size and version, Server CPU, and Server RAM requirements for the Patch Manager database.

First published date

11/29/2018 10:38 PM

Last published date

11/29/2018 10:38 PM

Overview

This article lists the Microsoft® SQL Server® requirements for the SolarWinds Patch Manager database.

Product section

Patch Manager

Resolution

SQL Server database size

The SolarWinds Patch Manager database stores all consolidated data from the Windows Server Update Services (WSUS) inventory, managed computer inventory, and discovery tasks.

When you generate a report, the SolarWinds Patch Manager Admin Console pulls the data directly from the database. The database size corresponds with the size of your environment.

The SQL Server Express database is limited to 10 GB with 1 GB RAM (minimum). 
 

SQL Server version

To ensure optimal performance, SolarWinds recommends an external SQL Server database instance running one of the following versions:

  • SQL Server 2012, 2012 SP1, 2012 SP2, or 2012 SP3
  • SQL Server 2014 or 2014 SP1
  • SQL Server 2016
  • SQL Server 2016 Express SP1
  • SQL Server 2016 SP2
  • SQL Server 2017
  • SQL Server 2019
SQL Server 2016 or later is required for an Orion Platform installation. 


Server CPU requirements

The minimum CPU requirement is:

  • 1.0 GHz (32-bit x86 implementation)
  • 1.4 GHz (64-bit x64 implementation)

Microsoft recommends a 2.0 GHz CPU (minimum).
 

Server RAM requirements

The minimum RAM requirement is:

  • 512 RAM (SQL Server 2008 and 2012)
  • 1 GB RAM (SQL Server 2014 and 2016)

Microsoft recommends 4 GB RAM (minimum) for SQL Server.