Extended Events query_hash and query_plan_hash data types - by Ola Hallengren

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


2
0
Sign in
to vote
ID 1934583 Comments
Status Closed Workarounds
Type Suggestion Repros 1
Opened 10/23/2015 12:24:19 PM
Access Restriction Public

Description

The query_hash and query_plan_hash actions in extended events do not have the same data types as the columns in the DMVs sys.dm_exec_requests, and sys.dm_exec_query_stats. That makes it difficult to correlate the information.

It would be good if the data types for the actions in extended events could be changed to the same that are used in the DMVs. If you don't want to change the data types for the existing actions, you could also add new actions. Another option could be to provide a conversion function.
Sign in to post a comment.
Posted by Microsoft on 5/17/2016 at 8:28 AM
On the relevant xEvents, new columns query_hash_signed and query_plan_hash_signed allow you to join with DMVs.
Posted by Cody Konior on 5/17/2016 at 7:03 AM
I would also like a description of how this has been fixed, so we know what to expect.
Posted by Koen Verbeeck on 5/17/2016 at 3:07 AM
Are there any additional details? Will they be included in the release notes?