Submit a ticketCall us

Training ClassSign up for Network Performance Monitor (NPM) and Scalability instructor-led classes

Attend our instructor-led classes, provided by SolarWinds® Academy, to discuss the more advanced monitoring mechanisms available in NPM as well as how to tune your equipment to optimize its polling capabilities. NPM classes offered:
NPM Custom Monitoring and Polling
Orion Platform Scalability

Reserve your seat.

Home > Success Center > Server & Application Monitor (SAM) > SAM - Knowledgebase Articles > How to Filter Out Indexes by Size within the Appinsight For SQL Template

How to Filter Out Indexes by Size within the Appinsight For SQL Template

Table of contents

Updated November 7, 2017


This article discusses how to filter out indexes by size within the AppInsight for SQL Template to avoid small indexes from being flagged as critical or warning. Indexes with only a few pages are likely to be fragmented. There is nothing you can do about it, and there is no real performance impact due to their small size.


  • SAM 6.2 and later


  1. Go to your Application Details page for the Appinsight template.
  2. Edit the application monitor.
  3. Expand the component 'Top Indexes to Retrieve'.
  4. Edit the threshold 'Minimum Size (KB) of Indexes to Retrieve' .

  5. Apply a value suitable to your environment. 

This will now filter out any indexes smaller than the specified size from being reported or alerted on by Appinsight for SQL Template.




Last modified