How to check transaction log file size in Sql server
In SQL server to check transaction log file size you can simply run this dbcc sqlperf(“logspace”) . This query will provide you the transaction log usage statistics for all the databases.
The other way round is to run this DMV query which will provide you the usage for the selected database. Note,this will provide you usage only for the
selected database.
Use tempdb
SELECT total_log_size_in_bytes *1.0/1024/1024 AS [ Total log space in MB],
used_log_space_in_bytes *1.0/1024/1024 AS [ Used log space in MB],
(total_log_size_in_bytes – used_log_space_in_bytes)*1.0/1024/1024 AS [free log space in MB]
FROM sys.dm_db_log_space_usage;
8,990 total views, 2 views today
What Is the Power BI New Card Feature? The new card feature allows you to:…
The attribute value in Dimension table are going to change slowly over time and they…
Changing Database compatibility level will be required when you upgrade your database from one…
To know what is compatibility Level check this post link. You can view the compatibility…
SQL Server Compatibility level will be used to decide how SQL will use it features.…
A view is a virtual table. View will not store any data physically. The data…