Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Trace Analysis & Blocking Expand / Collapse
Author
Message
Posted Thursday, April 3, 2014 2:39 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 12:47 PM
Points: 510, Visits: 598
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
Post #1558257
Posted Thursday, April 3, 2014 4:08 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:38 AM
Points: 13,755, Visits: 28,147
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
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1558288
Posted Thursday, April 3, 2014 4:48 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, September 11, 2014 2:28 PM
Points: 1,194, Visits: 2,219
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
Post #1558307
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse