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

Help trying to read sys.dm_exec_requests result Expand / Collapse
Author
Message
Posted Friday, January 3, 2014 9:26 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Sunday, August 24, 2014 6:58 AM
Points: 61, Visits: 280
Hi Guys,

Please could I get a hand understanding something that is really confusing me. I keep getting the following requests showing up in sys.dm_exec_requests:

Command: EXECUTE
Wait Type: NULL
Wait Resource: Blank
Wait_Time: 0
Session_Id: 104
Sql_Handle: 0x000000000000000000000000000000000000000000000000
Plan_Handle: 0x000000000000000000000000000000000000000000000000

What does the blank sql_handle and plan_handle mean and why is it executing if there is no handle? We are getting performance issues at the moment and I think that this is somehow linked up as they seem to become more frequent as the issue is occurring.
Post #1527618
Posted Friday, January 3, 2014 9:57 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 4:14 PM
Points: 15,725, Visits: 28,130
Do you notice if there are other entrees for the same session_id?

----------------------------------------------------
"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 #1527633
Posted Friday, January 3, 2014 10:02 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Sunday, August 24, 2014 6:58 AM
Points: 61, Visits: 280
Not that I could see. The query was filtered by is user query though so it is a remote possibility
Post #1527636
Posted Saturday, January 4, 2014 3:20 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 4:14 PM
Points: 15,725, Visits: 28,130
I was thinking it could be parallel processes. That would show why you couldn't see the statement and plan on all of them.

----------------------------------------------------
"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 #1527795
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse