Submit a ticketCall us

Announcing NCM 7.7
With NCM 7.7, you can examine the rules that make up an access control list for a Cisco ASA device. Then you can apply filters to display only rules that meet the specified criteria, order the rules by line number or by the hit count, and much more.
See new features and improvements.

Home > Success Center > Netflow Traffic Analyzer (NTA) > NTA 4.2.3 Administrator Guide > NTA Installation > Orion SQL database requirements

Orion SQL database requirements

Table of contents
No headers

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

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

These minimum requirements are for the Orion Platform. Products that run on the Orion Platform may have different requirements, such as different OS or memory requirements. Consult your product-specific documentation for the exact requirements.

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

Requirements SL100, SL250, SL500 SL2000 SLX

SQL Server

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

  • 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
  • SQL Server 2017
  • The FullWithSQL installer package automatically installs SQL Server 2014 Express. This is recommended for evaluations.
  • Set the recovery model of the database to Simple. SolarWinds does not support other methods.
  • SQL Server Compact Edition 3.5 SP2 is only supported for evaluations.
  • 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.

SQL Server collation

  • English with collation setting SQL_Latin1_General_CP1_CI_AS
  • English with collation setting SQL_Latin1_General_CP1_CS_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, 3.0 GHz or better

Dual quad core processor, 3.0 GHz or better

Dual quad core processor, 3.0 GHz or better

Hard drive space

20 GB minimum

Mirrored drives for the OS and 6 disk RAID 1+0 for database data files is recommended.

50 GB minimum

Mirrored drives for the OS and 6 disk RAID 1+0 for database data files is recommended.

100 GB minimum

SolarWinds recommends the following configuration:

  • A hardware RAID Controller with a battery backed-up write back cache
  • Disk Subsystem 1 Array 1: 2 x 146 GB 15K disks RAID 1 (mirroring) for the OS
  • Disc Subsystem 2 Array 2: 2 x 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 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

Due to intense I/O requirements, a RAID 1+0 drive is strongly recommended for the SolarWinds database, data, and log files. RAID 5 is not recommended for the SQL Server hard 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

Authentication

Both Windows Integrated Authentication and SQL authentication mechanisms are supported.

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
03:01, 13 Sep 2017

Tags

Classifications

Public