cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 9

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!

Thanks

Mike

1 Reply
Level 16

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.

/RjL

0 Kudos