Posts tagged Transaction Logs

Finding Log Size for all Databases in SQL Server

Jun 4th

Posted by Brumedishetty in SQL Server

No comments

Monitoring the size of Transaction Log files is one of those important tasks for a SQL Server Database Administrator. I monitor regularly in order to ensure that my database log files do not grow tremendously in size and potentially run out of space. The script in this article will give the list of Databases and their Transaction Log files size in MB in the descending order.

Script used in this blog…

SELECT INSTANCE_NAME AS [DATABASE],(CNTR_VALUE/1000) AS Size_In_MB
FROM MASTER.dbo.SYSPERFINFO 
WHERE COUNTER_NAME LIKE '%Log File(s) Size (KB) %'
AND INSTANCE_NAME NOT IN ('_Total','mssqlsystemresource')
ORDER BY Size_In_MB DESC 

 You may also take a look at one of my previous blogs related to transaction logs. Find Transaction Log Space Used

Comments / feedback will be highly appreciated.

–Bru Medishetty

, ,

Find Transaction Log Space Used

Mar 31st

Posted by Brumedishetty in SQL Server

1 comment

To query the space used by the transaction logs use the command, use DBCC SQLPERF(LOGSPACE). The command displays the Database Name, Log Size in Mega Bytes, the % of  log file used, remember the value is not the size it is the percentage used from the actual space of the log files. The results displayed is for all databases on the SQL Server instance.

Find the script below…

DBCC SQLPERF(LOGSPACE)


Monitoring transaction log files for the free space is a one of the very important tasks for a DBA.

– Bru Medishetty

, , ,