Submit a ticketCall us

AnnouncementsCome see SolarWinds at VMUG Frankfurt

SolarWinds is delighted to attend the upcoming VMUG which will take place at Kap Europa in Frankfurt on June 19th, 2018.

See event details.

Home > Success Center > Netflow Traffic Analyzer (NTA) > 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