Submit a ticketCall us

AnnouncementsFace your biggest database issues head-on

Our new eCourse helps you navigate SQL Server performance blocks by teaching you how to recognize and deal with the three DBA Disruptors: Performance Hog, Blame Shifter, and Query Blocker. Register today to learn how to defend your environment and fend off menacing disruptions.

Register for your free eCourse.

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