Transaction Log informations

To get information about transaction log, usually  we use :

DBCC SQLPerf(LogSpace) = how much log space it’s used

DBCC LogInfo = information about vlf virtual log files

 

But there are new dmvs ,that can do the same things maybe more:

for DBCC SQLPerf , we can use sys.dm_db_log_space_usage
for DBCC LogInfo , we can use sys.dm_db_log_info
also can be used sys.dm_db_log_stats

 

 

S