Post reply

SQL server Memory Usage

  • April 15, 2004 at 12:27 pm

    #179174

    Hi Team,

    How can i find how much memory currently the SQL is using ?

    Thanks


    venkatesh

  • April 15, 2004 at 2:46 pm

    #503029

    There are several easy ways:

    Performance Monitor (Perfmon.exe)

    - SQL Server:Memory Manager >> Total Server Memory (KB)

    Using a tool like pslist.exe from SysInternals

    Looking at Task Manager locally on the server.

    K. Brian Kelley
    @kbriankelley

  • April 16, 2004 at 7:23 am

    #503123

    I want to rephrase the question.

    I want to find exactly how much memory utilizing for SQL server as I have allocated min and max values as 4mb to 2.5 GB. When I try to capture from perform it gives me 2.5gb, I doubt it is correct.

    Thanks


    venkatesh

  • April 16, 2004 at 1:11 pm

    #503193

    Total Server Memory is the "total amount of dynamic memory the server is currently consuming."

    Target Server Memory is the "total amount of dynamic memory the server is willing to consume."

    K. Brian Kelley
    @kbriankelley

  • April 16, 2004 at 1:32 pm

    #503200

    Hi Brain, Thanks for you quick replay, but i have a doubt. The memory which shows under task manager for SQLSERVer.exe process is current memory usage of that process. could you please clear my doubt. Thanks in advance.

    Thanks


    venkatesh

  • June 21, 2005 at 5:45 am

    #566981

    Hi,

    You can use following dbcc command and getting the details of memory usage MS SQL Server.

    Use master

    go

    DBCC memorystatus

    go

     

    Thanks

    Chandra

     

     

  • June 23, 2005 at 3:17 am

    #567804

    you can also look in sysperfinfo table for the information

    select * from master.dbo.sysperfinfo where counter_name like '%server memory%'

    When using extended memory I've found it's usually better to set min and max memory the same - on a dedicated box what else would need the memory ?

    Note that when using awe task manager processes does not report the correct memory usuage e.g. my prod server which has 30Gb allocated reports 350mb in processes !

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

Viewing 7 posts - 1 through 6 (of 6 total)

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