Transaction log space usage (MS2000 / MS2005 / MS2008)

Name:	Transaction log space usage
Platform:	Sqlserver
Category:	Capacity
Description:	This procedure checks information returned by DBCC SQLPERF which is used to monitor the amount of space used in the transaction log.
Long description:	The procedure indicates (by warning or alarm) when to back up or truncate the transaction logs. If parameter ‘include unallocated free space’ is set to ‘YES’, the procedure will compute the free space in each transaction log file based on available space in each file plus all unallocated space this file (or files) could autoextend to (maxsize – current size).
Version:	1.8
Default schedule:	10,40 * * *
Requires engine install:	Yes
Compatibility tag:	[CDATA[.[type=‘instance’ & databasetype=‘sqlserver’]/instance[maj_version < ‘2008’ & hasengine=‘YES’ & engine_edition = ‘Microsoft SQL Server’

Feedback