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

Write a SQL query to make a column as unique?

1077

What are the diifferences between the ms sql server vs mysql?

1234

What are the instances when triggers are appropriate?

1019

what is the system function to get the current user's user id? : Sql server database administration

1068

Give an example of SQL injection attack ?

1048

What is store procedure? When do you use?

985

Can group by and orderby be used together?

1067

How many types of attribute relationships are there? : sql server analysis services, ssas

1128

Does sql server 2016 have ssms?

1004

What's the information that can be stored inside a bit column?

1067

How to use go command in "sqlcmd"?

1262

How global temporary tables are represented and its scope?

1012

How do I view a trc file?

977

Which tools are available to manage SQL Azure databases and servers?

115

List the advantages of using stored procedures?

1106