Useful Undocumented SQL Server 2017 DBCC Commands (Part 2) In this article, you can find the description of some useful undocumented DBCC commands, and find out how you can use these commands in SQL Server 2017. 1. DBCC addinstance This DBCC command can be used to add an object instance to track in Performance Monitor. Syntax: DBCC addinstance (objectname, instancename)...
Tag: DBCC PAGE
Useful Undocumented SQL Server 2012 DBCC Commands (Part 2)
Useful Undocumented SQL Server 2012 DBCC Commands (Part 2) DBCC is an abbreviation for Database Console Command. DBCC commands are generally used to check the physical and logical consistency of a database, although they are also used for a variety of miscellaneous tasks. Note, the command: DBCC TRACEON (3604) is issued before some of the following DBCC examples in order...