In this article, we are going to show the command to find the Microsoft SQL Server transaction log used space.
The transaction log is a critical component which use to record all the transactions happening in the database.
Type in the command as below and press execute. You will get the output similar like below screenshot, the database name, log size, log space used and status.
DBCC SQLPERF ('LOGSPACE')
