Version

Argent Advanced Technology 1304-L and above

Date

Friday, 3 May 2013

Summary

Argent Advanced Technology has been enhanced with a new Rule category ‘Average Fragmentation In Percent Rules‘ in Argent for SQL Server to identify the percentage of fragmentation for indexes

Click For Full Size

Example 1:

‘Average Fragmentation In Percent Rules‘ check SQL database index fragmentation. Rule ‘AVG_FRAG_SQL2008_APPROACHING_LIMIT‘ is broken if the SQL database index fragmentation percent is between 0.10% and 0.30%

Click For Full Size

Example 2:

‘Average Fragmentation In Percent Rules‘ check SQL database index fragmentation. Rule ‘AVG_FRAG_SQL2008_AT_LIMIT‘ is broken if the SQL database index fragmentation percent is equal to 0.30%

Click For Full Size

Example 3:

‘Average Fragmentation In Percent Rules‘ check SQL database index fragmentation. Rule ‘AVG_FRAG_SQL2008_EXCEEDING_LIMIT‘ is broken if the SQL database index fragmentation percent is between 0.30% and 0.35%

Click For Full Size

Technical Background

Average Fragmentation In Percent Rules help Database Administrators to identify the percentage of fragmentation for indexes larger than 5,000 pages

Resolution

N/A