Submit a ticketCall us

Announcing NPM 12.2
With NPM 12.2 you can monitor your Cisco ASA firewalls, to monitor VPN tunnels for basic visibility and troubleshooting tunnels. NPM 12.2 also uses the SolarWinds Orion Installer so you can easily install and upgrade one or more Orion Platform products simultaneously.
See new features and improvements.

Home > Success Center > Network Performance Monitor (NPM) > Determine the Orion SQL database size

Determine the Orion SQL database size

Table of contents
Created by Kevin Twomey, last modified by Kevin Twomey on Feb 08, 2017

Views: 410 Votes: 3 Revisions: 6

Overview

This article discusses how to determine the space to allocate for the Orion SQL database.

Environment

All Orion Core versions

Detail

There is no fixed formula to determine how much space to allocate for the Orion SQL database. SolarWinds recommends a 30-day evaluation of your environment to observe the growth of your database and then adjust the retention settings. 

The database size depends on the number of the following:

  • Nodes, interfaces, and volumes you are polling
  • How much traffic is going through the devices, your retention setting for statistical polling
  • Syslog messages (if you receive them and how much you are receiving)
  • Trap messages (if you receive them and how much you are receiving)
  • Retention settings for syslogs/traps messages
  • NetFlow (95% Top Talker? DNS? IpAddressLookup?)
  • Wireless, UnDP, hardware health and other modules.


A rough guide if you have a full SLX with NetFlow, Syslog, Traps for seven days retention, is to allot an approximate of 10-50 GB to Orion Database.

  • Lastly, there are plenty of “Database Sizing” Posts on Thwack that customer can read to make a judgement on their Database Sizing.

 

Last modified
06:31, 8 Feb 2017

Tags

Classifications

Public