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) > 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: 222 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