April 3, 2014 at 2:39 pm
Hi,
I want to find out the way to finding to know which processor is blocking another from the profiler trace.
Actually we took profiler trace. We observed one process is taking long time but there is no cpu time. We suspect of blocking. How to identify from that trace which process is blocking that? Are really blocking occurred or not?
In the profiler trace, if we find less cpu and high reads. Is that means something is blocking? Please let me know
Thanks,
Ramana
April 3, 2014 at 4:08 pm
Query performance measures alone won't show you what is blocking or being blocked. Since you're on 2012 you can use the blocked_process_report extended event. That will tell you what is blocked and blocking. You can read more about it here.
"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
April 3, 2014 at 4:48 pm
You can't find it that way. Either you need to use Blocked Process report in profiler or use extended events as Grant mentioned.
--
SQLBuddy
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply