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) > Website performance issues caused by bad Limitations "1=1"

Website performance issues caused by bad Limitations "1=1"

Updated March 11th, 2016

Overview

This article describes website performance, which may be affected by bad limitations in the Limitations table of the database.

Environment

All NPM versions

Cause 

Bad limitations can be created in the limitations table in the database, which affects the website performance. Bad limitations happen if do not complete creating a limitation. Check the limitations table in the database for limitations where the WhereClause is 1=1.

Resolution

  1. Check the limitations table in the database for Limitations where the WhereClause is 1=1.
  2. If the limitations exist, run the following query to remove them:
    Delete from Limitations Where WhereClause = '1=1'
  3. After the limitations have been removed, stop all Orion services using the Orion Service Manager.
  4. Run the following Queries to remove the references to the limitations from the tables.
    • Delete From LimitationSnapShots
    • Delete from ContainerMemberSnapshots
  5. Restart the Orion Services using the Orion Service Manager.
     

The tables would rebuild, which should improve the Orion performance.

Last modified

Tags

Classifications

Public