For some unknown reason my SQL 2005 NetPerfMon database has grown to a WHOPPING 163Gb the past 2 days. Needless to say it is killing me as I can't get backups of it, etc. and other issues with a bloated database.
I spent all day yesterday trying to find ways to shrink the database by prunning data, etc. I was running a query last night to delete all old syslog data but since my SQL server is so large it is taking forever to respond to any new queries. Yesterday the table size query told me that the largest tables were syslog and netflowsummary3 (I think).
If I run the compact command from Orion's database manager I eventually get a SQL error and then the database goes into recovery mode.
I am restarting the SQL service and will see what is what but need some assitance here.
We had a similar issue with the syslogs inflating the database. We finally re-evaluated what we "truly" needed syslogs from and then ported syslogs to thier own dedicated server so that it did not inflate NetPerfMon anymore.
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. Learn more today by joining now.