Post reply

sys.dm_exec_query_memory_grants

  • July 4, 2011 at 9:51 pm

    #253819

    hello experts,

    got a server with 32GB of RAM, configured max memory as 28GB.

    with this query --> "select session_id, requested_memory_kb, granted_memory_kb, required_memory_kb from sys.dm_exec_query_memory_grants"

    Result :

    session_id requested_memory_kb granted_memory_kb required_memory_kb

    ---------- -------------------- -------------------- --------------------

    66 234752 234752 4864

    here is my question --> is the mermory 234752KB comes from the 28GB i configured for SQL server or from 4GB?

    Thanks in advance.

  • July 5, 2011 at 6:47 am

    #1348239

    Max memory settings controls only the max size of buffer pool(paged memory).

    So in short the memory of 234752KB comes from 28 GB max setting.

    --------------------------------------------------------------------------------------------------
    I am just an another naive wannabe DBA trying to learn SQL Server

  • December 5, 2012 at 6:08 am

    #1565708

    Hi,

    Server 32 bit or 64 bit and awe enabled?

  • December 5, 2012 at 6:27 am

    #1565719

    murugan.shanmugam (12/5/2012)

    Hi,

    Server 32 bit or 64 bit and awe enabled?

    Irrelevant to this question.

    Year and a half old thread

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply