Transaction Log Size Check

Supported versions Description Adjustable Settings Schedule
SQL Server 2000, 2005, 2008 Checks size of the transaction logs, and compares it to the database size.

min transaction log size  - The minimum size (in MB) of the transation log file to be examined.

warning threshold  - The threshold (in percent) to trigger a warning. If the size of the transaction log file is greater than f.exp. 100% (the default value of the parameter) of the total size of the data file(s), the check returns a warning.

alarm threshold  - The threshold (in percent) to trigger an alarm. If the size of the transaction log file is greater than f.exp. 200% (the default value of the parameter) of the total size of the data file(s), the check returns an alarm.

ignore offline databases  - If set to YES, the check will ignore databases which are offline.

ignore databases  - The list of databases to be ignored from being checked (separated by coma).

ignore offline databases  - If set to YES, the check will ignore databases which are offline.

Example drill-down report

Download full local report example  (997.38 kB PDF)