KBI 311413 Enhancement: New Rule Category Database Fragmentation Details Reporting Only Rule In Argent for SQL Server
Version
Argent Advanced Technology 3.1A-1601-T10 and later
Date
Thursday, 16 June 2016
Summary
Argent for SQL Server has been enhanced with a new Rule category ‘Database Fragmentation Details Reporting Only Rules’ for the reporting of database index fragmentation statistics
Technical Background
The ‘Database Fragmentation Details Reporting Only Rule’ saves the database index fragmentation details like database name, table name, index name, index type, index size, fragmentation percentage etc. to the database table named
‘ARGSOFT_SQL_SERVER_DB_FRAG_DETAILS’
Argent Reports can use this table data for reporting purpose
There is an option to save the fragmentation statistics of specific databases by specifying the database names in Include/Exclude fields
There is an option named ‘Days To Keep Old Data’, that deletes all records older than specified number of days
Please see the screenshot of the Rule:
Resolution
Upgrade to Argent Advanced Technology 1601-T10 or later