Transaction Log Space Usage

Supported versions Description Adjustable Settings Schedule
SQL Server 2000, 2005, 2008 Executes when to back up or truncate the transaction logs.

min histr interval  - The minimum number of minutes before a new history record will be collected in the history table.

warning threshold  - The maximum percentage of space usage allowed in the transaction log before a warning is triggered.

alarm threshold  - The maximum percentage of space usage allowed in the transaction log before an alarm is triggered.

history threshold  - The amount of hours the statistics are registered in the history table.

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

max num db  - The maximum number of databases to be collected in the history tables (sort by transaction log size).

Example drill-down report

Download full local report example  (1,049.43 kB PDF)