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’


Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment