sp_what

Better* than sp_who2, with less re-checking data to get answers. Also, it is SnaZy. With a capital Z.

*Dont you just love totally non subjective assessments like this?

How to Create Deadlocks and Troubleshoot Them

Watch in awe and wonder as Brent Ozar creates a deadlock, then uses sp_BlitzLock after the fact to show you which queries and tables were involved.

Dealing with High Concurrency with Table Hints

Systems with a large number of requests on a critical database table are prone to blocking and slowness. We take a look at getting things done using T-SQL table hints.

GetDate() in blocked sessions

Diagnosing parallelism-related latching

Diagnosing and resolving parallelism-related latching and blocking in SQL Server using DMV’s, the activity monitor, procedure execution plans, and index tuning.

Open Transaction details

sql server blocking, open transaction

Executing Process Details

Script identifies running processes, blocking, waits, and duration

Figure out the Blocking issue

This script will help you to get the culprit along with IP address and User name which helps us to determine the Blocking root cause.

Locking, Blocking and Deadlocking

Introduction into Locking, Blocking and Deadlocks in SQL Server, and why SQL Server uses these actions.

Blocking Chain (SQL Spackle)

Problems with blocking processes can be easy to identify with SQL Server DMV's.