Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

Home > Success Center > Server & Application Monitor (SAM) > AppInsight for SQL shows critical for Orion database index fragmentation

AppInsight for SQL shows critical for Orion database index fragmentation

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

Views: 127 Votes: 4 Revisions: 4

Overview

When using SAM to monitor the Orion database instance, it is showing as critical for SolarWinds index Fragmentation.

What does this mean and is it important to address?

Environment

  • SAM v6.0 or later versions
  • Any Orion database version

Detail

When drilling into the Orion database if monitored by AppInsight for SQL, you may see some critical alerts for the index fragmentation similar to the screenshot below.

 

 

This is a normal behavior. As we build out new daily tables and move the data to our summary tables, there will always be fragmentation on the indexes for those objects until we run our database maintenance to rebuild the indexes.

If the desired behavior is to not see these as critical, the component can be disabled for indexes or thresholds can be set to essentially 100%. The recommendation is to disable this one component within AppInsight for SQL for the Orion database monitor.

 

Disable index fragmentation component:

Navigate to the specific application monitor and click Edit Application Monitor.

Scroll down to the component list and expand Top Indexes for Database.

Click on the override Template button to the right of the Enable/Disable option which will then show a dropdown.

Choose Disable, then scroll to the bottom and click Submit.

Note: It will take a few minutes to clear the critical alerts and flags as we have to get through at least one poll and update the database to reflect this new change in the web console.

 

 

 

 

 

Last modified
02:46, 23 Jun 2016

Tags

Classifications

Public