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 > NTA Summary page take a long time to load

NTA Summary page take a long time to load

Updated 21-11-2018

Overview

When loading the NTA Summary page it takes a long time to show because there is a huge amount of interfaces sending flows to NTA on the resource NetFlow Sources, thus the page loads slowly.

Environment

  • Any NTA version

Cause

Amount of NetFlow Sources cause the page to load slowly. Most customers have a high percentage of these sources not sending information to NTA. The resolution below will clear the sources that are not sending information.

Resolution

  • Create a backup of the SQL Database
  • Login into the Orion Server
  • Open Database Manager
  • Click "Add Default Server"
  • Expand the SQL Server and right-click the Orion DB selecting New Query
  • Paste the queries below and press Execute

UPDATE NetflowSources set Enabled = 0
where (LastTime is NULL or LastTime<DATEADD(day, -1, GETDATE()))

UPDATE NetFlowSources set cbQoSEnabled = 0
WHERE (CBQoSLastTime is NULL or CBQoSLastTime<DATEADD(day, -1, GETDATE()))

 

Note: this queries will disable the NetFlow Sources that did not send flows in the last day and CBQoS is not being polled

 

 
Last modified

Tags

Classifications

Public