Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Network Performance Monitor (NPM) > Warning about the size of Syslog table

Warning about the size of Syslog table

Table of contents
Created by Erin Stenzel, last modified by MindTouch on Jun 23, 2016

Views: 599 Votes: 4 Revisions: 4

Updated  (Unknown)

Overview

Syslog 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.

Environment

  • NPM

Steps

 

  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/2010'
    Delete from Traps Where datetime <= '4/1/2010'
    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

Tags

Classifications

Public