Nov 18, 2025 · The Transact-SQL programming language provides DBCC statements that act as Database Console Commands for SQL Server. Database Console Command statements are …

DBCC CHECKDB checks the logical and physical integrity of all the objects in the specified database.

Sep 3, 2024 · DBCC CHECKTABLE checks the integrity of all the pages and structures that make up the table or indexed view.

Nov 18, 2025 · DBCC CHECKIDENT checks the current identity value for the specified table in SQL Server, and changes the value if needed.

Nov 18, 2025 · Executing DBCC FREEPROCCACHE in a user database clears the plan cache for that database. If the database is in an elastic pool, it also clears the plan cache in all other …

Nov 18, 2025 · Instead, use DBCC CLEANTABLE after you make significant changes to variable-length columns in a table or indexed view and you need to immediately reclaim the unused …

DBCC CLONEDATABASE creates a schema-only copy of a database that includes all the elements necessary to troubleshoot query performance issues without copying the data.

Dec 5, 2025 · SQL Server requires VIEW SERVER STATE permission on the server to run DBCC SQLPERF(LOGSPACE). To reset wait and latch statistics requires ALTER SERVER STATE …

Sep 3, 2024 · After you checkpoint the database, you can issue DBCC DROPCLEANBUFFERS command to remove all buffers from the buffer pool. In Azure SQL Database, DBCC …

Nov 18, 2025 · DBCC USEROPTIONS reports an isolation level of read committed snapshot when the database option READ_COMMITTED_SNAPSHOT is set to ON and the transaction …