cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post

Orion - SQL Query issue

From yesterday, we are facing issue like, our Orion database log file is getting increased abruptly due to continuous SQL delete query request from Orion solarwinds. Instead of sending request in batch, orion is flushing out all requests at a time which causing orion database size getting increased a lot.

Store Procedured Name: swsp_DeleteFlowsByIntervalRange

Database is simple recovery model

Please help on this to stop increasing the database size and also to mitigate the flow from orion.

regards

Gokul kurunthasalam

0 Kudos
4 Replies

NTA Version details:

LicenseProduction
Module NameNetFlow Traffic Analyzer
Version3.9.0
Service PackNone
0 Kudos
Level 17

This version is not only has reached End of Life, but also the End of Support milestone for almost an year. 

NTA 4.x has numerous benefits

- stores the netflow data in an efficient proprietary database

- doesn't constantly churn your SQL database like what you are experiencing

- stores the entire history at 1 minute granularity

- loads the web console views *significantly* faster.

It is definitely time to start planning your upgrade.

Thanks,

We will plan for an upgrade. Do we have any other possibilities to overcome this issue for time being?

-Gokul Kurunthasalam

0 Kudos
Level 17

Please move this to the NTA forum. Which version of NTA do you have?

0 Kudos