Submit a ticketCall us

AnnouncementsChange Is Inevitable

Get valuable help when it comes to tracking and monitoring changes. SolarWinds® Server Configuration Monitor (SCM) is designed to help you: detect, track, and receive alerts when changes occur, correlate system performance against configuration changes, compare server and application configuration against custom baselines, and verify application and system changes.

Learn more.

Home > Success Center > Netflow Traffic Analyzer (NTA) > NTA - Knowledgebase Articles > How do I determine the right amount of storage capacity for my NTA Flow Storage Database

How do I determine the right amount of storage capacity for my NTA Flow Storage Database

Table of contents

Updated January 11, 2017

Overview

How do I determine the right amount of storage capacity for my NTA Flow Storage Database?

 

Environment

  • NTA 4.x

Detail

Reference the Average PDU’s processed per second number. We recommend a minimum of 20GB of local NTFS storage, plus at least 8GB for each 1000 sustained flows per second, provided that you use the default 30-day retention period. Please take into account how much data you will be migrating from your previous SQL flow storage. The space required for the migration will be displayed during the Configuration Wizard before you launch the migration.
To approximately find out the space required for the migration, run the following query on your Orion SQL DB:

SELECT SUM(Size_GB) as Space_required_to_migrate_in_GB FROM (
  SELECT (SELECT SUM(reserved_page_count)*8.0*2.0/1024/1024 FROM sys.dm_db_partition_stats stats WHERE stats.object_id = id) as [Size_GB]
 FROM (
  SELECT id FROM dbo.sysobjects WITH(NOLOCK) WHERE name LIKE 'NetFlowDetail[_][0-9]%' AND OBJECTPROPERTY(id, N'IsUserTable') = 1
  UNION ALL
  SELECT id FROM dbo.sysobjects WITH(NOLOCK) WHERE name LIKE 'NetFlowSummary[1-3]' AND OBJECTPROPERTY(id, N'IsUserTable') = 1
 ) B
 ) A

 

 

Last modified

Tags

Classifications

Public