A DBCC PAGE Example with Output

This post will demonstrate how to run the undocumented DBCC PAGE command to view the properties of a page. First we execute the…

The the most blocked queries

Views – 721

Find resource currently involved in blocking

Views – 676

T-SQL for identifying slow-running queries on a database

Views – 694

Using sp_WhoIsActive

Here is an awesome extentions of the sp_who and sp_who2 (undocumented) sprocs DBA’s use to see slow running queries etc. Download link for…

Getting the plan handle for a sproc

You can use this T-SQL to get the plan handle for a sproc that has a bad execution plan:

Make sure, to…