Update adds overall query execution statistics information to the STATISTICS XML output in SQL Server 2012, 2014 and 2016

Applies to: SQL Server 2016 DeveloperSQL Server 2016 EnterpriseSQL Server 2016 Enterprise Core More

Summary


An update is available that adds the following overall query execution statistics information to the STATISTICS XML output in SQL Server 2012, 2014 and 2016:
  • CPU time and Elapsed time under the new QueryTimeStats element for the QueryPlan showplan XML element
  • Top 10 longest wait types and durations under new WaitStats element for the QueryPlan showplan XML element

More Information


Service pack information for SQL Server

This update is fixed in the following service packs for SQL Server:

Service Pack 1 for SQL Server 2016.

Service Pack 3 for SQL Server 2014

Service Pack 4 for SQL Server 2012

References


Learn about the terminology  that Microsoft uses to describe software updates.