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.
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.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.