Submit a ticketCall us

AnnouncementsAre You “Flying Blind?”

When it comes to your complex IT infrastructure, you want to ensure you have a good grasp of what’s going on to avoid any fire drills that result from guesswork. Read our white paper to learn how proactively monitoring your IT environment can help your organization while giving you peace of mind.

Get your free white paper.

Home > Success Center > Netflow Traffic Analyzer (NTA) > NTA - Knowledgebase Articles > Impact of using SQL Express server for flow data storage

Impact of using SQL Express server for flow data storage

Table of contents

Updated October 17, 2017

Overview

You are using SQL Express server to store your flow data for the evaluation copy of NTA 4.4. The performance of this SQL server edition is lower than the performance of SQL Standard or Enterprise editions.

Environment

  • NTA 4.4

Detail

If you install an evaluation copy of NTA 4.4, NTA automatically deploys the SQL Express server for storing your flow data. The performance of this SQL server edition is lower than the performance of SQL Standard or Enterprise editions. Also, the SQL Express server has specific limitations and therefore is not supported for a production deployment.

  • Limitation of maximum memory utilized - affects performance
  • Limitation of maximum database size - affects the flow count limit which can be exhausted very quickly
  • SQL Express uses only single CPU - affects performance

For production deployment and installation, please use either SQL Standard or SQL Enterprise. 

 

 

Last modified

Tags

Classifications

Public