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

“There are three types of lies ― lies, damn lies, and statistics” ~ Benjamin Disraeli

Related commands:

sp_spaceused
sys.dm_os_latch_stats
sys.dm_os_wait_stats
Equivalent Oracle commands: V$LOG and V$LOGFILE


 
Copyright © 1999-2021 SS64.com
Some rights reserved