DBCC checkdb for SQL Server database
DBCC CHECKDB Generally in a very large database it's no feasible to run the check for complete database because it's a resource intensive, so we different option to check the health. Command-1: DBCC CHECKDB ('AdventureWorks2012') Output: DBCC results for 'AdventureWorks2012'. Service Broker Msg 9675, State 1: Message Types analyzed: 14. Service Broker Msg 9676, State 1: Service Contracts analyzed: 6. Service Broker Msg 9667, State 1: Services analyzed: 3. Service Broker Msg 9668, State 1: Service Queues analyzed: 3. Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0. Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0. Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0. Service Broker Msg 9605, State 1: Conversation Priorities analyzed: 0. DBCC results for 'sys.sysrscols'. There are 1754 rows in 21 pages for object "sys.sysrscols". DBCC results for 'sys.sysrowsets'. There are 324 rows i...