Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

It's very important to collect per-operator query execution statistics, such as actual number of rows, for query performance troubleshooting. In Microsoft SQL Server, this information is available in actual execution showplan. In SQL Server 2014 SP2 and SQL Server 2016, the actual execution showplan XML is extended to add more execution statistics in the RunTimeCountersPerThread element, including such information as elapsed time, CPU time, logical and physical reads (if applicable).

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.

How to get the new feature

Service pack information

Service 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

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×