Post reply

SQL Server memory question

  • January 25, 2012 at 3:16 pm

    #254236

    I have a sql server 2008 R2 production system with 32 GB memory and 26GB of memory is set as max memory for SQL Server rather than the default to use all the memory. I am seeing gradual increase of memory when I look into the task manager to 26 GB over a period. How do I check the actual memory being used by SQL Server ? what DMV or counters I can set to see this value? For example SQL Server may not be using the 26 GB although the task manager showing SQL Server is allocated for 26 GB.

    thanks in advance for an answer.

  • January 25, 2012 at 3:22 pm

    #1438481

    LGDBA (1/25/2012)

    I have a sql server 2008 R2 production system with 32 GB memory and 26GB of memory is set as max memory for SQL Server rather than the default to use all the memory. I am seeing gradual increase of memory when I look into the task manager to 26 GB over a period. How do I check the actual memory being used by SQL Server ? what DMV or counters I can set to see this value? For example SQL Server may not be using the 26 GB although the task manager showing SQL Server is allocated for 26 GB.

    thanks in advance for an answer.

    You are probably ok, unless you are seeing memory pressure. The recommended amount for 32gb is 29000mb max. Check out this article[/url].

    Jared
    CE - Microsoft

  • January 25, 2012 at 8:30 pm

    #1438549

    See also http://www.simple-talk.com/sql/database-administration/great-sql-server-debates-lock-pages-in-memory/

    Paul White
    All articles available on SQL.kiwi
    @SQL_Kiwi

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

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