Documentation forServer & Application Monitor
Monitoring your applications and environment is a key capability of Hybrid Cloud Observability and is also available in a standalone module, Server & Application Monitor (SAM). Hybrid Cloud Observability and SAM are built on the self-hosted SolarWinds Platform.

Top 10 Clustered Indexes by Fragmentation

A clustered index determines the physical order of data in a table. This widget displays the clustered indexes with the highest level of fragmentation. If the Warning or Critical threshold is breached, the color of the bar chart changes from green to yellow or red, respectively.

  • Table Name: Displays the name of the listed table.
  • Index Name: Displays the name listed index.
  • Fragmentation: Numerically and graphically displays the percentage of fragmentation of the listed index.

The Top Indexes for Database performance counter provides metrics for this widget. This counter is not listed.

You can change thresholds:

You may need to log in with an administrator account to perform these actions.

  1. From the Database Details view, locate the Database Details widget and click Edit in the Management field.
  2. Locate the Top Indexes for Database performance counter and click [+] to expand the counter and reveal the counter details.
  3. Click Override Template and adjust the thresholds to suit your needs.
  4. When done, click Submit.

Changing the number of tables displayed in this widget requires values be changed in two locations:

  1. In the widget, click Edit.
  2. Change the value for the field: Maximum Number of Records to Display, and then click Submit.
  3. Edit the application or the template that the application is based on.

To edit the template which affects applications based on it:

  1. In the SolarWinds Platform Web Console, navigate to Settings > All Settings > SAM Settings > Manage Templates.
  2. Check the AppInsight for SQL application and click Edit in the toolbar.
  3. Expand the Top Indexes for Database component monitor by clicking [+].

  4. Change the value for the field, Number of Records to Retrieve and then click Submit.

To edit the individual application:

  1. In the SolarWinds Platform Web Console, click the Applications tab.
  2. From the All Applications resource, click an AppInsight for SQL application to select it.
  3. From the Application Details resource, click Edit Application Monitor.
  4. Expand the Top Indexes for Database component monitor by clicking [+].
  5. Click Override Template corresponding to the row, Number of Records to Retrieve.

  6. Change the value for the field, Number of Records to Retrieve and then click Submit.