Submit a ticketCall us

Training ClassThe Orion® Platform Instructor-led Classes

Provided by SolarWinds® Academy, these trainings will introduce users to the Orion Platform and its features, management, and navigation. These courses are suitable for users looking to discover new tips, tricks, and ways to adapt their Orion products to better suit their monitoring needs:
Deploying the Orion Platform
Configuring Orion views, maps, and accounts
Configuring Orion alerts and reports

Reserve your seat.

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