Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

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
More on storage requirements here.

 

 

Last modified
15:32, 12 Jan 2017

Tags

Classifications

Public