Improvement: Update to add spill information of batch-mode operators to "Warnings" section of Showplan XML in SQL Server 2016 and 2017

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

Improvement


This update improves the TempDB spill diagnostics information in Showplan XML in Microsoft SQL Server 2016 and 2017 to include the following support information for batch-mode hash and sort operators in the "Warnings" section:

  • Page numbers to show how many pages were written to tempDB
  • Memory Statistics for the operator

Resolution


This improvement is included in the following cumulative updates for SQL Server:

       Cumulative Update 11 for SQL Server 2017

       Cumulative Update 3 for SQL Server 2016 SP2

References


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