Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

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: 547 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

Tags

Classifications

Public