Submit a ticketCall us

Don’t fall victim to a ransomware attack
Backups are helpful, but sometimes that’s not enough to protect your business against ransomware. At our live webcast we will discuss how to protect against ransomware attacks with SolarWinds® Patch Manager and how to leverage log data to detect ransomware. Register now for our live webcast.

Home > Success Center > Network Performance Monitor (NPM) > Network Operations Manager > Network Operations Manager Installation Guide > Requirements > Database server (SQL Server) requirements

Database server (SQL Server) requirements

Table of contents
No headers
Created by Caroline Juszczak, last modified by Caroline Juszczak on Oct 04, 2016

Views: 16 Votes: 0 Revisions: 1

Network Operations Manager and your SolarWinds Orion database must use separate servers.

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

If you install on a virtual machine, you must maintain your SQL Server database on a separate, physical drive.

The following table lists software and hardware requirements for your SolarWinds Orion database server.

Hardware/
Software
Requirements

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
  • SQL Server 2014 or 2014 SP1
  • SQL Server 2016
  • SolarWinds strongly recommends using the 64-bit version of SQL Server.
  • The FullWithSQL installer package automatically installs SQL Server 2014 Express. This is recommended for evaluations. You must install .NET 3.5 manually with this option.
  • Due to latency effects, SolarWinds does not recommend installing your SQL Server and your Orion server or additional polling engine in different locations across a WAN. For more information, see Install SolarWinds software and SolarWinds database (SQL Server) across a WAN.
  • 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. SolarWinds does not support Full recovery mode.

SQL Server collation

  • English with collation setting SQL_Latin1_General_CP1_CI_AS
  • German with collation setting German_PhoneBook_CI_AS
  • Japanese with collation setting Japanese_CI_AS
  • Simplified Chinese with collation setting Chinese_PRC_CI_AS

We support CI database on an CS SQL Server.

We do not support case-sensitive databases.

CPU speed

Dual quad core processor or better

Hard drive space

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 1: 2x 146 GB 15K disks RAID 1 (mirroring) for the OS
  • Disc Subsystem 2 Array 2: 2x 146 GB 15K disks RAID 1 (Pagefile + Extra Storage)
  • Disk Subsystem 3 Array 3: with 6x 15k 146 GB or 300 GB disks configured in a RAID 1+0 array 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 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 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 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 (SSD) are recommended for all components.

Per Windows standards, some common files may need to be installed on the same drive as your server operating system. You may want to move or expand the Windows or SQL temporary directories.

Memory

64 GB minimum

128 GB recommended

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
Last modified
06:03, 4 Oct 2016

Tags

This page has no custom tags.

Classifications

Public