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

    syslog SQL table - partitioning?

    MichaelKnee

      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!

       

      Thanks

       

      Mike