Applications Systems

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

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.

First published date

11/8/2018 6:16 PM

Last published date

11/8/2018 6:16 PM

Overview

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.

Product section

Server Application Monitor

Resolution

  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.