Post reply

SQL Server Memeory Usage

  • July 30, 2010 at 7:07 am

    #146484

    Below is the procedure I peformed while configuring SQL Server.

    Total Memory available on Windows Server : 10GB

    Configured SQL Server to use 80% of 10GB ie....8GB by setting 'min server Memory' and 'Max Server Memory' to 8GB.

    After Restarting the SQL Server services, SQL Server is allocated with 8GB on Memory as Intended.

    Now, My question here is,...Out of this 8GB Memory allocated to SQL Server how can I find how much actual memory is being used by SQL Server memory at any given point of time.

    This is for SQL Server 2005.

    Please Advise.

    Thanks

    SQLHarry

  • July 30, 2010 at 9:11 am

    #1200426

    The "SQL***MemoryManager" counter in Perfmon will give you the details.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • July 30, 2010 at 10:45 am

    #1200471

    Pradeep,

    Thanks for the Reply.....but still did not resolve the issue (Total memory used by SQL Server).

    In the SQL Server Memory Manager counters

    Target Server Memory (KB) : Total amount of dynamic memory the server can consume

    Total Server Memory (KB) : The committed memory from the buffer pool (in kilobytes).

    Note : This is not the total memory used by SQL Server.

    Please Refer.

    http://technet.microsoft.com/en-us/library/ms190924.aspx

    Thanks

    SQLHarry

  • July 30, 2010 at 4:59 pm

    #1200572

    You should not set the min memory = max memory. That could cause issues within SQL Server.

    Since this is a dedicated box - there is no reason to set the min memory. SQL Server does not pre-allocate memory on startup. It will start allocating memory as needed up to the max setting.

    Once SQL Server reaches the max memory target - it is using all of that memory.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • July 30, 2010 at 6:16 pm

    #1200581

    Hi Harry,

    Use DBCC Memory Status and Task manager.

    http://support.microsoft.com/kb/271624

    Thank You,

    Best Regards,

    SQLBuddy

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

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