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 DBCCSQLPERF which is used to monitor the amount of space used in the transaction log.
Post your comment on this topic.