Collecting actual execution showplan, however, is an expensive operation. To provide an alternative that incurs less performance impact on query execution, new Extended Event query_thread_profile was added in SQL Server 2014 SP2. This event is triggered for each query plan operator and execution thread at the end of query execution. The node_id attribute can be used to correlate this information with the query plan, which can be obtained, such as, from query plan cache by using the plan handle and sys.dm_exec_query_plan Dynamic Management Function.
While the performance impact of enabling the query_thread_profile Extended Event is significantly less than the impact of enabling the query_post_execution_showplan Extended Event, the actual performance may vary depending on the workload.
Service pack informationService Pack 2 for SQL Server 2014
About Service packs for SQL Server
Service packs are cumulative. Each new service pack contains all the fixes that are in previous service packs, together with any new fixes. Our recommendation is to apply the latest service pack and the latest cumulative update for that service pack. You do not have to install a previous service pack before you install the latest service pack. Use Table 1 in the following article for finding more information about the latest service pack and latest cumulative update.
How to determine the version, edition and update level of SQL Server and its components
Artikel-id: 3170113 - Laatst bijgewerkt: 11 jul. 2016 - Revisie: 1