Submit a ticketCall us

WebinarUpcoming Webinar: Should I Move My Database to the Cloud?

So you’ve been running an on-premises SQL Server® for a while now. Maybe you’ve moved it from bare metal to a VM, and have seen some positive benefits. But, do you want to see more? If you said “YES!”, then this session is for you, as James Serra will review the many benefits that can be gained by moving your on-prem SQL Server to an Azure® VM (IaaS). He’ll also talk about the many hybrid approaches, so you can gradually move to the cloud. If you are interested in cost savings, additional features, ease of use, quick scaling, improved reliability, and ending the days of upgrading hardware, this is the session for you.

Register now.

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: 3,167 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