DBCC SQLPERF (logspace) provides transaction log space usage statistics for all databases. The sample output returns
Database Name,Log Size (MB),Log Space Used (%),Status
master,1.242188,40.8805,0
tempdb,0.4921875,47.32143,0
model,6.117188,94.44444,0
msdb,1.992188,43.13726,0
No comments:
Post a Comment
Note: only a member of this blog may post a comment.