January 3, 2014 at 9:26 am
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.
January 3, 2014 at 9:57 am
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
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 3, 2014 at 10:02 am
Not that I could see. The query was filtered by is user query though so it is a remote possibility
January 4, 2014 at 3:20 am
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
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply