Finding Suspect Pages

Here is where SQL Server stores any pages it has identified as suspect:

Views – 983

DBCC command list

DBCC activecursors [(spid)] DBCC addextendedproc (function_name, dll_name) DBCC addinstance (objectname, instancename) DBCC adduserobject (name) DBCC auditevent (eventclass, eventsubclass, success, loginname, rolename, dbusername, loginid)…

Using the undocumented command fn_dblog to view the SQL log

Reading the SQL Server Log file – and undocumented command

to get all the column, execute this:

Here is a blog…

Using DBCC SHOW_STATISTICS

This is a DBCC command I learned from Brent Ozar’s Indexing video. To get statistics on an index, simply use:

Views –…

Find Last LSN Applied to Database

Here is the SQL to display the last LSN applied to the database (think log-shipping)

Views – 1350

DBCC Notes

This post will be updated regularly as I work through all the DBCC commands. Using ‘DBCC HELP command’ will provide the help and…

DBCC (Transact-SQL) Overview

SQL Server 2012 Posted from TechNet The Transact-SQL programming language provides DBCC statements that act as Database Console Commands for SQL Server. Database…