SQL SERVER – Types of DBCC Commands When Used as Database Console Commands

Just a day ago, while discussing some SQL issues with one of the Sr. Database Administrator in India, we end up discussing DBCC as Database Console Commands when used as T-SQL. We both tried to remember what are the types of DBCC as Database Console Commands and could not come up with more than two types, however we both knew there are four.

When the conversation was over, I looked up MSDN for the types of the DBCC. I found following documentation here. There are four types of the Database Console Commands.

Maintenance

Maintenance tasks on a database, index, or filegroup.

Examples:

DBCC INPUTBUFFER

DBCC SHOWCONTIG

Miscellaneous

Miscellaneous tasks such as enabling trace flags or removing a DLL from memory.

Examples:

DBCC CHECKCATALOG

DBCC CHECKIDENT

Informational

Tasks that gather and display various types of information.

Examples:

DBCC DROPCLEANBUFFERS

DBCC SHRINKFILE

Validation

Validation operations on a database, table, index, catalog, filegroup, or allocation of database pages.

Examples:

DBCC dllname (FREE)

DBCC TRACEOFF

Reference : Pinal Dave (http://blog.SQLAuthority.com), BOL – DBCC

About these ads

5 thoughts on “SQL SERVER – Types of DBCC Commands When Used as Database Console Commands

  1. hi pinal,
    i found the information useful, however i checked with the msdn page you hyperlinked, the dbcc commands are listed incorrectly.
    Hope you checkout.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s