Submit a ticketCall us

Training Class Getting Started with SolarWinds Backup - February 28

This course offers customers an introduction to SolarWinds Backup, focusing on configuring the backup technology, taking backups, data restoration and data security. It is a great primer and will get you up to speed quickly on SolarWinds Backup.
Register for class.

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