Version

Argent Advanced Technology 3.1A-1601-T14 and later

Date

Friday, 24 June 2016

Summary

Added the option to specify scan level in Average Fragmentation In Percent Rules in Argent for SQL Server

Scan level can be specified as ‘Detailed’, ‘Sampled’ or ‘Limited’

‘Detailed’ is the default option

Technical Background

Average Fragmentation In Percent Rules internally uses the dynamic management function ‘sys.dm_db_index_physical_stats’ to get the statistics details

The last parameter of this function specifies the scan level that is used to obtain statistics

It can be specified as DETAILED, SAMPLED or LIMITED

But in the current implementation, it is hardcoded as DETAILED

This Rule is enhanced by adding an option to specify the scan level in the Rule definition screen

Using this option, scan level can be specified as ‘Detailed’, ‘Sampled’ or ‘Limited’

‘Detailed’ is the default option

The below screenshot shows the Rule definition screen containing the scan level option:

Click For Full Size

Resolution

Upgrade to Argent Advanced Technology 1601-T14 or later