Monitoring SQL  «Prev  Next»

SQL Server dbcc Commands

The following table contains a list of dbcc commands and their uses.
dbcc memusage monitor memory buffers
dbcc proccache monitor the procedure cache
dbcc buffer monitor data cache
dbcc perform monitor overall system performance
dbcc output buffer monitor data sent back to clients
dbcc input buffer monitor data sent from clients

DBCC (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview
The Transact-SQL programming language provides DBCC statements that act as Database Console Commands for SQL Server.
Database Console Command statements are grouped into the following categories.
Command category Perform
Maintenance Maintenance tasks on a database, index, or filegroup.
Miscellaneous Miscellaneous tasks such as enabling trace flags or removing a DLL from memory.
Informational Tasks that gather and display various types of information.
Validation Validation operations on a database, table, index, catalog, filegroup, or allocation of database pages.

DBCC Internal Database Snapshot Usage

The following DBCC commands operate on an internal read-only database snapshot that the Database Engine creates. This prevents blocking and concurrency problems when these commands are executed. For more information, see Database Snapshots (SQL Server).