Submit a ticketCall us
Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > Warning about the size of Syslog table

Warning about the size of Syslog table

Table of contents
Created by Erin Stenzel, last modified by Marc.Fobair on Jun 29, 2018

Views: 2,969 Votes: 4 Revisions: 5

Updated  (Unknown)


Syslog and TRAPS  table runs out of space.


Syslog messages, existing traps and trap variable bindings continue to pile up, consuming space in the Orion NPM database.

Note: Before attempting the procedure in this article, see the KB Article -  SQL reports the NPM database is currently out of space.


  • NPM



  1. Start > All Programs > SolarWinds Orion > Advanced Features > Database Manager.
  2. Click Add Server.
  3. Select or provide your SQL Server.
    Note: If you do not know your SQL Server, complete the following steps:
    1. Click Start > All Programs > Solarwinds Orion > Documentation and Support > Configuration Wizard.
    2. Check Database, and then click Next.
    Your SQL Server credentials are now displayed in this window.
  4. Select your preferred login method, and then, if you are using a SQL Server userid and password, provide your User Name and Password.
  5. Click Connect to Database Server.
  6. Click + to expand your SQL instance.
  7. Click + to expand your Orion NPM database.
    Note: The default Orion NPM database name is NetPerfMon.
  8. If you are also running Orion NCM, click + to expand your Orion NCM database.
    Note: The default Orion NCM database name is ConfigMgmt.
  9. Right-click Syslog, and then click Query Table.
  10. Clear the provided query, and then enter the following query to delete all Syslog messages, traps, and trap variable bindings that are older than a designated date:
    Delete from Syslog Where datetime <= '4/1/2018'
    Delete from Traps Where datetime <= '4/1/2018'
    Delete from TrapVarBinds where TrapID not in (select TrapID from Traps)
  11. If you want to delete all existing Syslog messages, traps, and trap variable bindings, use the following Truncate commands:
    Truncate Table Syslog
    Truncate Table Traps
    Truncate Table TrapVarBinds


Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment.  You elect to use third party content at your own risk, and you will be solely responsible for the incorporation of the same, if any.



Last modified