In SQL Server 2005, 2008, 2008 R2,... Select Session_ID, Blocking

how to know Who Is Blocking Your SQL Server?

Question Posted / pandians

Answer Posted / pandians

In SQL Server 2005, 2008, 2008 R2,...

Select Session_ID, Blocking_Session_ID From
Sys.Dm_Os_Waiting_Tasks Where Blocking_Session_ID Is Not
Null

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain few examples of stored procedure over triggers?

693

What is the Disadvantage of indexed sequential file.

783

What is difference between Datepart() and Datename() in SqlServer?

902

Define self join in sql server joins?

700

what is checksum in sql server.........???

1376

how to define testing of network layers? : Sql server database administration

657

What are cursors in ms sql server?

789

What is importing utility?

719

Can you roll back the ddl statement in a trigger?

697

What are sql servers used for?

721

What do you mean by sql server 2005 express management tools?

1017

Can you explain different types of locks in sql server?

709

Explain about system stored procedure?

773

What are the limitations in ssrs on sql server express edition?

158

What is a deadlock and what is a live lock?

752