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!
I'm interested in this, and also for the Traps table.
You would also have to update the database maintenance tasks to take advantage of this.