Submit a ticketCall us

AnnouncementsFace your biggest database issues head-on

Our new eCourse helps you navigate SQL Server performance blocks by teaching you how to recognize and deal with the three DBA Disruptors: Performance Hog, Blame Shifter, and Query Blocker. Register today to learn how to defend your environment and fend off menacing disruptions.

Register for your free eCourse.

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