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 Log File Rules‘ in Argent for SQL Server to calculate the percentage of free space remaining in log file of each database in an SQL Server

Click For Full Size

Example 1:

‘Free Space In Database Log File Rules‘ check the percentage of free space remaining in log file of each database in an SQL Server. Rule ‘LOG_FILE_FREE_SPACE_SQL2008_APPROACHING_LIMIT‘ is broken if the free space remaining in log file is between 30% and 50%

Click For Full Size

Example 2:

‘Free Space In Database Log File Rules‘ check the percentage of free space remaining in log file of each database in an SQL Server. Rule ‘LOG_FILE_FREE_SPACE_SQL2008_AT_LIMIT‘ is broken if the free space remaining in log file is equal to 30%

Click For Full Size

Example 3:

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

Click For Full Size

Technical Background

N/A

Resolution

N/A