BL0B_EATER (5/28/2015)
I agree with Grant I have used Jonathan Kehayias's Extended Events script to get an idea of blocking, I just changed it slightly because I knew the database_ID that I wanted to concentrate on and I let in run for a while.cheers.
I did a quick search. If I'd thought about it, I would have gone straight to Jonathan.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning