Understanding DBCC in SQL Server

SQL Server

When using SQL Server, you will need access to Database Console Commands, and this is exposed to the Database Administrator using DBCC commands. SQL Server Database Console Command statements are grouped into the following categories.

Category Action
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 commands take input parameters and return values.

These commands will create a read-only database snapshot. While this helps prevent concurrency and blocking issues, but it can cause issues with free drive space.

DBCC CHECKDB fails when it is run against master if an internal database snapshot cannot be created.

To get basic information about the DBCC command available, see this blog post.

 

Advertisements

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