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

__________________
The KINGMAKER
Makes Every Thing Possible

Stuffs (My Blog)