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 > Server & Application Monitor (SAM) > 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