SqlShare.com Logo
 
Skip Navigation Links
Home
Channels
Classes
About Us
Login / Register
Subscribe to the All channels feed  Goto the SqlShare.com blog
Image of Jonathan Kehayias
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

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:
  1. Which of the following best defines blocking in SQL Server?

  2. 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.    

Bookmark and Share

  Rate This Video:  
 
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
Zip file of the .SQL files from this video

Sponsored Ads
 

How Do I Become a Video Author? |  Newsletter History

Copyright © Fourdeuce, Inc., 2005-2009. All Rights Reserved | Privacy Policy | Terms & Conditions