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

Why do we use trigger?

971

Can I run multiple instances of sql server 2000 at the same time on one computer?

1074

What are two difference between sql azure and azure tables?

159

How do you test your database? : sql server database administration

1020

What is merge join?

1196

How to check table values in sql server?

955

How can we migrate from SQL server to SQL Azure?

113

Is port 1433 secure?

997

How to download microsoft sql server 2005 express edition?

1047

What is data set in report?

135

How do I create a partition table in sql server?

1123

How will you make an attribute not process? : sql server analysis services, ssas

1089

What are tables in sql server?

1039

How to create a new schema in a database?

1151

How to filter records of table in SQL SERVER?

1086