Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

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: 322 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