Find Resource Currently Involved in Blocking

Posted by Derek Dieter
on May 31 2009

SELECT DISTINCT
	objname = object_name(p.object_id)
FROM sys.partitions p
JOIN sys.dm_tran_locks t1
ON p.hobt_id = t1.resource_associated_entity_id

Related Posts:
»Monitor Queries against a Table
»Rebuild and Reorganize Fragmented Indexes
»Find Best Clustered Index
»Index Usage DMV
»Reindex All Tables in a Database
»Select Distinct
»List All Tables in a Database
»Query Which Tables are Partitioned
»Find All Queries Run Against a Table
»Choosing the Best Clustered Index

Popular search terms:

Filed under DMV Queries Tagged blocking, DMV

Comment (RSS) | Permalink

post a comment OR Post Your Question on our ASK! Community!

Random MVP RSS Feeds
- [SQLTeam] How to import in BIDS more than one SSIS package in one shot!: Have you ever wanted to add more than o... http://t.co/ZfC9u8I1 about 9 hours ago from twitterfeed
- Avoiding IF.. ELSE by using WHERE EXISTS - When coming from a programming... http://t.co/QdT0Ebyq #fb 01:33:19 AM January 31, 2012 from SQL Server Planet
- Avoiding IF.. ELSE by using WHERE EXISTS - When coming from a programming... http://t.co/QdT0Ebyq #fb 07:58:09 PM January 29, 2012 from SQL Server Planet
- DROP INDEX SYNTAX - Here is the syntax needed in o... http://t.co/ElqNyG3e #fb 07:05:16 PM January 29, 2012 from SQL Server Planet
- SET TRANSACTION ISOLATION LEVEL - This statement is used to set... http://t.co/0zGtNE1X #fb 06:10:38 PM January 29, 2012 from SQL Server Planet
- [Aaron Bertrand] Bad Habits to Kick : Thinking a WHILE loop isn't a CURSOR: I see a lot of people suggest while ... http://t.co/oDLn0pVs 10:12:20 PM January 26, 2012 from twitterfeed
- [Simon Sabin] Ten reasons to attend SQLBits X: If you are contemplating attending then I hope the following will... http://t.co/Zg6uqojD 12:54:21 PM January 26, 2012 from twitterfeed
- [Simon Sabin] SQLBits x an awesome line up –1100 people have already registered: I was really happy to have put ... http://t.co/zQu3m5ix 07:48:47 PM January 25, 2012 from twitterfeed
- [Aaron Bertrand] SQL Server 2012 : The "Launch Date" is not what you think it is: I see a lot of people getting ... http://t.co/i87shAFB 02:18:00 AM January 24, 2012 from twitterfeed
- [Aaron Bertrand] Bad Habits to Kick : Using AS instead of = for column aliases: This one is quite subjective, an... http://t.co/5uzyQWCv 05:49:21 PM January 23, 2012 from twitterfeed

SQL Server Planet

Find Resource Currently Involved in Blocking

post a comment OR Post Your Question on our ASK! Community!

Random MVP RSS Feeds

Newsletter Signup

Connect

Categories