Author:

Author Bio:

Jonathan Kehayias is a SQL Server MVP with experience in Database Administrator and Development. He is currently the SQL Database Administrator for OSI Restaurant Partners in Tampa, FL. His primary passion is performance tuning, where he frequently rewrites queries for better performance and performs in depth analysis of index implementation and usage. His current projects include building http:/...

How to Find Blocked Processes in SQL Server - Part 1

Blocking is part of a life in a production database management system, but it can lead to very visible performance issues. SQL MVP Jon Kehayias shows how to detect blocking using a couple different methods. Tomorrow we'll show you Part 2 (but you can watch it today if you want!).

Video Information
Publish Date:	January 27, 2009
Length:	2:6
Skill Level:	300
Rating:	4.15 out of 5

After watching you should be able to answer these questions:

Which of the following best defines blocking in SQL Server?

When we query sys.dm_exec_requests why do we filter out sessions (spids) under 50?

You must be logged in to view this video.

Rate This Video:	12345
	1=Poor, 3=Good, 5=Excellent

Comments:

BillRoger on 2/21/2009

short but nice information.

Luca Zavarella on 4/29/2009

Is possible to get the code I can see in the video?

Marc Voyer on 4/29/2009

too short

Diana Dee on 4/29/2009

Question 1's answer, though the best of the 4 suggested answers, is incorrect. A SELECT can be blocked; it is not waiting for exclusive access -- it is waiting for a SHARED lock.

Lonnie Meinke on 5/5/2009

Need a bit more info (such as on SPIDs < 50..etc...) and a little less "reading" to instill confidence from the listener....Good content though.

4B47653576 on 5/17/2009

does it need a restart to take effect? no details of how to set this specific trace up. Very good demo.

Syed Arshad on 8/21/2009

Sound is too bad


Must Be Logged In

References

Demos from Video

Zip file of the .SQL files from this video