Update to expose maximum memory enabled for a single query in Showplan XML in SQL Server 2014 or 2016

Summary

This update adds the following new attributes to the Showplan XML schema in SQL Server 2014 or 2016:
  • MaxCompileMemory under OptimizerHardwareDependentProperties: Maximum amount of memory available to compile a single query in kilobytes (KB).
  • MaxQueryMemory under MemoryGrantInfo: Maximum amount of memory available for individual query grant in KB, if the query requires memory to run.

The values for these attributes are provided in compliance with current server configuration and Resource Governor settings, as they are applied during query compilation and execution.

More Information

This update is included in the following service pack for SQL Server:


About service packs for SQL Server
About service packs for SQL Server

References

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

ID do Artigo: 3170112 - Última Revisão: 16 de nov de 2016 - Revisão: 1

Comentários