Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
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"
