Name: Transaction log space usage
Platform: Sqlserver
Category: Capacity
Description: This procedure collects space usage in all filegroups defined in each database. The undocumented ‘sp_MSforeachdb’ Stored Procedure is used to execute T-SQL statements against dbo.sysfiles table in every database defined to a SQL Server instance.
Long description: This job checks information returned by DBCC SQLPERF which is used to monitor the amount of space used in the transaction log.
Version: 2
Default schedule: 13 * * *
Requires engine install: No
Compatibility tag: [CDATA[.[type=‘instance’ & databasetype=‘sqlserver’]/instance[(engine_edition = ‘Microsoft SQL Server’ | engine_edition = ‘Azure SQL Managed Instance’)

Feedback

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