Hi - has anyone tried partitioning the syslog table in the "SolarWinds" database?
This table takes a huge hammering & partitioning would allow us to eliminate all of the database IO around deleting old syslog data by "switching" out partitions.
I hope I'm making some sense to the non-SQL Server people out there? It just seems like a total no-brainer on such a busy table, I'm surprised its not built into the product already?
Apologies if this one has been asked before!
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.