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 ‘Free Space In Database Data Files Rules‘ in Argent for SQL Server to calculate the percentage of free space remaining in data file in database

Click For Full Size

Example 1:

‘Free Space In Database Data Files Rules‘ check the percentage of free space remaining in Data File of each database in an SQL Server. Rule ‘DATA_FILE_FREE_SPACE_SQL2008_APPROACHING_LIMIT‘ is broken if the percentage of free space remaining in data file is between 20% and 30%

Click For Full Size

Example 2:

‘Free Space In Database Data Files Rules‘ check the percentage of free space remaining in Data File of each database in an SQL Server. Rule ‘DATA_FILE_FREE_SPACE_SQL2008_AT_LIMIT‘ is broken if the percentage of free space remaining in data file is equal to 20%

Click For Full Size

Example 3:

‘Free Space In Database Data Files Rules‘ check the percentage of free space remaining in Data File of each database in an SQL Server. Rule ‘DATA_FILE_FREE_SPACE_SQL2008_EXCEEDING_LIMIT‘ is broken if the percentage of free space remaining in data file is between 10% and 20%

Click For Full Size

Technical Background

N/A

Resolution

N/A