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

SYSLOG Table OverLimit

Anybody who can help me to minimize the size of SYSLOG Table, i am currently using Orion NPM v.7.8.5 with SQL 2000 Enterprise. Curretly i have 370 GB Space available for SQL Data File but in NetPerfMon Database SYSLOG Table acquired 150 GB For Tabl and 141 GB For Indexing now i am out of space... kindly anyone who can help me in this regard?
0 Kudos
2 Replies
Level 7

You can run a SQL query on the Syslog table that will delete everything in it besides the columns and structure. After this query is run, the entries in the table will not be recoverable. The Query you will want to run against it is:

TRUNCATE Table Syslog

Eric Martin
SolarWinds.Net
Technical Support
0 Kudos
Level 7

If you would like to discard messages before they reach SQL you can use the 'discard syslog message' rule in the alerts section of the syslog viewer. This will prevent it from reaching the SQL database.
0 Kudos