DBCC SQLPERF

Display transaction-log space statistics. Reset wait and latch statistics.

Syntax
      DBCC SQLPERF ( Option ) [WITH NO_INFOMSGS ]
     
Options:
   LOGSPACE
   'sys.dm_os_latch_stats' , CLEAR 
   'sys.dm_os_wait_stats' , CLEAR

Key:
   LOGSPACE          - Monitor log space, indicates when to back up or truncate the tx log.
   dm_os_latch_stats - Reset the latch statistics.
   dm_os_wait_stats  - Reset the wait statistics.
	NO_INFOMSGS       - Suppress all information messages (severity 0-10)

Example

DBCC SQLPERF(LOGSPACE)
GO

“If you happen to be one of the fretful minority... never force an idea; you'll abort it if you do. Be patient and you'll give birth to it when the time is
ripe. Learn to wait” - Robert A. Heinlein

Related commands:

sp_spaceused
sys.dm_os_latch_stats
sys.dm_os_wait_stats

Equivalent Oracle commands:

Oracle deals with transaction logs in a *totally* different way
See V$LOG and V$LOGFILE