Submit a ticketCall us

WebinarFREE IT Monitoring Webcast

Don’t miss out on our webcast, Essential IT Monitoring with SolarWinds ipMonitor, where we will show you how to keep an eye on your IT environment from one centralized, affordable, and lightweight monitoring tool: SolarWinds® ipMonitor®.

Register now.

Home > Success Center > Server & Application Monitor (SAM) > SAM - Knowledgebase Articles > How to filter the Top XX Nonclustered indexes resources in AppInsight for SQL

How to filter the Top XX Nonclustered indexes resources in AppInsight for SQL

Updated: November 10, 2017

Overview

This article describes how to filter the Top XX resource associated with Index Fragmentation to only display indexes over a specific size.

Environment

  • SAM 6.2 and later

Steps

  1. Log in to the Orion Web Console.
  2. Click My Dashboards > Applications > SAM Summary. 
  3. Navigate to the Appinsight for SQL Application Details page.
    1. Click My Dashboards > Applications > SQL Server.
    2. In the All Applications box, click an application .
    3. Click AppInsight for SQL > Default SQL instance. 
  4. Click a Database
    image.png
     
  5. Locate the Top Indexes by Fragmentation resources.

    Before Filter
    1.png
     
  6. Click Edit in the top corner of the resource.
  7. Enter a filter similar to the illustration below.

    This query filters the resource to only display indexes where the index size is greater than 4MB.


    After Filter
    3.png


    Where did the Size string come from to create the filter since the column in the resource is Index Size? When you generate the query, you must create it based on the table columns in the database. 

    4.png

How do I know which column to use?

It requires a strong working knowledge of the Orion Database structure to correctly and easily manipulate the resources to your preference. See the Orion SDK for reference. 
 

 

 

Last modified

Tags

Classifications

Public