Post reply

Query Memory Usage

  • October 6, 2012 at 3:11 pm

    #269026

    Hi All

    I'm using the sys.dm_exec_requests to check what's happening in my instance

    There is a column called granted_query_memory, what does this column indicate? Does this indicate how many pages were brought from disk into memory to satisfy the query?

    Thanks

  • October 7, 2012 at 3:32 am

    #1546482

    Nothing to do with the buffer pool. That's the workspace memory grant for the query to do operations that themselves require memory. Hashes, sorts, exchanges, that sort of thing.

    As I suggested a week or so ago (http://www.sqlservercentral.com/Forums/Topic1365762-1550-1.aspx), go look for Adam Machanic's workspace memory session videos. The one from PASS is online, so is the one he did at SQLBits

    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

  • October 8, 2012 at 12:56 am

    #1546573

    GilaMonster (10/7/2012)

    Nothing to do with the buffer pool. That's the workspace memory grant for the query to do operations that themselves require memory. Hashes, sorts, exchanges, that sort of thing.

    As I suggested a week or so ago (http://www.sqlservercentral.com/Forums/Topic1365762-1550-1.aspx), go look for Adam Machanic's workspace memory session videos. The one from PASS is online, so is the one he did at SQLBits

    Thanks Gail

    A question that might be out of the scope of this thread, are you aware of any upcoming SQL Server events in South Africa?

    Thanks

  • October 8, 2012 at 1:45 am

    #1546588

    SQLSACT (10/8/2012)

    GilaMonster (10/7/2012)

    Nothing to do with the buffer pool. That's the workspace memory grant for the query to do operations that themselves require memory. Hashes, sorts, exchanges, that sort of thing.

    As I suggested a week or so ago (http://www.sqlservercentral.com/Forums/Topic1365762-1550-1.aspx), go look for Adam Machanic's workspace memory session videos. The one from PASS is online, so is the one he did at SQLBits

    Thanks Gail

    A question that might be out of the scope of this thread, are you aware of any upcoming SQL Server events in South Africa?

    Thanks

    Other than the monthly usergroup meetings?

    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

  • October 8, 2012 at 1:52 am

    #1546591

    GilaMonster (10/8/2012)

    SQLSACT (10/8/2012)

    GilaMonster (10/7/2012)

    Nothing to do with the buffer pool. That's the workspace memory grant for the query to do operations that themselves require memory. Hashes, sorts, exchanges, that sort of thing.

    As I suggested a week or so ago (http://www.sqlservercentral.com/Forums/Topic1365762-1550-1.aspx), go look for Adam Machanic's workspace memory session videos. The one from PASS is online, so is the one he did at SQLBits

    Thanks Gail

    A question that might be out of the scope of this thread, are you aware of any upcoming SQL Server events in South Africa?

    Thanks

    Other than the monthly usergroup meetings?

    Usergroup meetings?

    I was wondering if there will be any SQLSaturdays\PASS Events happening on our side of the world anytime soon.

  • October 8, 2012 at 2:02 am

    #1546594

    SQLSACT (10/8/2012)

    Usergroup meetings?

    Yes, the monthly meetings of the SQL Server usergroups

    I was wondering if there will be any SQLSaturdays\PASS Events happening on our side of the world anytime soon.

    There were 2 SQLSaturdays, one in March this year, one in May

    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 6 posts - 1 through 5 (of 5 total)

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