SolarWinds SAM database server (SQL server) requirements

Your Orion Platform product and your SolarWinds Orion database should use separate servers.

Multiple Orion server installations using the same database are not supported.

The following table lists software and hardware requirements for your SolarWinds Orion database server using SolarWinds SAM license levels as a reference.

Important End of Support
Microsoft SQL Server: Support for SQL 2008 and 2008 R2 is deprecated as of this release. Future releases will no longer support using SQL 2008 or 2008 R2 as your database server. SolarWinds recommends that you upgrade directly to SQL 2016 at your earliest convenience.

Requirements AL150 - AL300 AL700 - AL1100 AL1500-ALX

SQL Server

SolarWinds supports Express, Standard, or Enterprise versions of the following:

  • SQL Server 2008, 2008 SP1, 2008 SP2, 2008 SP3, or 2008 SP4

  • SQL Server 2008 R2, 2008 R2 SP1, 2008 R2 SP2, or 2008 R2 SP3

  • SQL Server 2012, 2012 SP1, 2012 SP2, or 2012 SP3 (also with AlwaysOn Availability Groups)
  • SQL Server 2014 (also with AlwaysOn Availability Groups) or 2014 SP1
  • SQL Server 2016
  • SolarWinds strongly recommends using 64-bit version of SQL Server.
  • The FullWithSQL installer package automatically installs SQL Server 2014 Express. This is recommended for evaluations.
  • Due to latency effects, SolarWinds does not recommend installing your SQL Server and your SolarWinds server or additional polling engine in different locations across a WAN. For more information, see this SolarWinds Knowledge Base article.
  • Either mixed-mode or SQL authentication must be supported.
  • If you are managing your Orion database, SolarWinds recommends you install the SQL Server Management Studio component.
  • You can set the database recovery model to Full recovery mode only if you use Always On Availability. We strongly recommend Simple recovery mode due to ensure best performance.

CPU speed

Quad core processor, 2.5 GHz or better

Quad core processor,
2.5 GHz or better

Dual quad core processor,
3.0 GHz or better

Hard drive space

20 GB minimum

40 GB recommended

50 GB minimum

100 GB recommended

100 GB minimum

400 GB recommended

SolarWinds recommends the following configuration:

  • A hardware RAID Controller with a battery backed-up write back cache
  • Disk Subsystem 1 Array : 2x 146 GB 115K disks RAID 1 (mirroring) for the OS
  • Disk Subsystem 2 Array 2: 1x 146 GB 15K disks RAID 1 (Pagefile + Extra Storage)
  • Disk Subsystem 3 Array 3: with 6 x 15K 146 GB or 300 GB disks configured in a RAID 1+0 array to allow for maximum write performance for your SQL MDF and FILEGROUPS
  • Disk Subsystem 4 Array 4: with 4x 15K 146 GB or 300 GB disks configured in a RAID 1+0 array to allow for maximum write performance for your SQL LDF Transaction LOG file
  • Disk Subsystem 5 Array 5: with 4x 15k 146 GB or 300 GB disks configured in a RAID 1+0 array to allow for maximum write performance for your tempDB data file
  • Disk Subsystem 6 Array 6: with 4x 15k 146 GB or 300 GB disks configured in a RAID 0 array to allow for maximum write performance for your tempDB LOG file

  • Due to intense I/O requirements, a RAID 1+0 drive is strongly recommended for the SolarWinds database, data, and log files with a dedicated drive for the server operating system and tempdb files.
  • Other RAID configurations can negatively affect your SQL Server's performance.
  • Mirrored drives for the OS and RAID 1+0 for database data files are recommended.
  • Solid state drives are recommended for all components except the OS drive.

Per Windows standards, some common files may need to be installed on the same drive as your server operating system. For more information, see Working with Temporary Directories.

Memory

4 GB minimum

8 GB recommended

8 GB minimum

16 GB recommended

16 GB minimum

32 GB recommended

Additional memory improves both performance and reliability.
Memory and Additional Pollers Each additional poller requires 16 GB of additional RAM. For example, SAM plus 2 additional pollers would require 32GB of RAM. 3 additional pollers would require 48GB of RAM, and so on.

Authentication

Either mixed-mode or SQL authentication

Other software

If you are managing your SolarWinds Orion database, SolarWinds recommends you install the SQL Server Management Studio component.

The Installation Wizard installs the following required x86 components if they are not found on your Orion database server:

  • SQL Server System Common Language Runtime (CLR) Types. Orion products use secure SQL CLR stored procedures for selected, non-business data operations to improve overall performance.
  • Microsoft SQL Server Native Client
  • Microsoft SQL Server Management Objects

SAM's PowerShell Script Monitor works with PowerShell 1.0 and higher for local execution.

PowerShell 2.0 or higher is required for remote execution.