1 Reply Latest reply on May 7, 2014 2:57 PM by RichardLetts

    syslog SQL table - partitioning?


      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!