Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

Query Store - Add Actual Memory Grant Used From sys.dm_exec_query_stats

Currently the Query Store only records data on the total memory grant size. It would be useful for it to also store sys.dm_exec_query_stats.last_used_grant_kb.

This would help us inform decisions around resource governor max memory grant settings as well as troubleshoot query performance.

3 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    AdminMicrosoft SQL Server (Admin, Microsoft Azure) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base