SQL's and execution plans may not be collected on SQL Server 2014
说明
The values of column query_hash and query_plan_hash are NULL for DMV sys.dm_exec_requests in SQL Server 2014 causing SQLs and execution plans not to be collected.
解决办法
Refer to Microsoft KB Article ID: 2953592 - "FIX: The value of statement_start_offset column is incorrect in DMV sys.dm_exec_requests in SQL Server 2014"
