Summarized SQL DB Log file(s), Virtual Log File(s) & Size analysis

 

Summary:

Analyze SQL DB Log file(s), Virtual Log files & Size information for all online SQL Databases

 Compatible & Tested SQL Versions: 2005, 2008, 2008 R2, 2012, 2014 & 2016 

 

Sample result of the attached script would look like below

 

Usage:

1. Open SQL Server Management Studio (SSMS) and connect to SQL Server. 

2. Click on “New Query”, copy the complete code and, paste it and run (Complete code). 

 

Base information is gathered from Below mentioned DBCC commands in all SQL Server versions (2005 - 2016).  


DBCC SQLPERF(LOGSPACE) is gathered SQL Instance level
SQL
Edit|Remove
DBCC SQLPERF(LOGSPACE)
 

DBCC LOGINFO is gathered every individual database on SQL Instance

SQL
Edit|Remove
DBCC LOGINFO()