DBCC SQLPERF Usage

DBCC SQLPERF has three uses: provides transaction log space usage statistics for all databases. In SQL Server It can also is used to reset wait and latch statistics.

Syntax

DBCC SQLPERF (     []      |          []     |     [])      []

Arguments

Logspace

Returns the current size of the transaction logs and the percentage of log space used for each database. You can use this information to monitor the amount of space used in a transaction log.

" sys.dm_os_latch_stats ", CLEAR

Resets the latch statistics. For more information, see SYS.DM_OS_LATCH_STATS (Transact-SQL).

"Sys.dm_os_wait_stats", CLEAR

Resets the wait statistics. For more information, see SYS.DM_OS_WAIT_STATS (Transact-SQL).

When DBCC SQLPERF is used to empty the statistics for wait and latch, it is instance-level emptying, which causes wait and latch statistics for all DB on that instance to be reset.

Resets the wait statistics for the instance of SQL Server.

DBCC SQLPERF ("Sys.dm_os_wait_stats", CLEAR);

DBCC SQLPERF Usage