Memory Utilised by SQL Server

  • Jeetendra

    SSCommitted

    Points: 1966

    Hi All,

    I am interested in finding out how much memory SQL Server is exactly utilising?

    But doesn't wanna use the Perfmon counters at all.

    Mine SQL Server version is SQL Server 2008 R2 EE 64 bit.


    Kindest Regards,

    Jeetendra

  • cindyaz

    Ten Centuries

    Points: 1229

    select name,type,

    sum(single_pages_kb+multi_pages_kb) as MemoryKB

    from sys.dm_os_memory_clerks

    group by name,type

    order by memorykb desc

  • Ali Tailor

    Hall of Fame

    Points: 3709

    Hi;

    See my blog post.

    http://mumbaisqldba.wordpress.com/2011/10/11/finding-out-how-much-memory-sql-server-is-utilizing/[/url]

    Ali
    MCTS SQL Server2k8

  • chris.mcgowan

    SSCarpal Tunnel

    Points: 4269

    You can use DBCC MEMORYSTATUS

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

    Thanks

    Chris

    ------------------------
    I am the master of my fate:
    I am the captain of my soul.
    ------------------------
    Blog: http://sqlserver365.blogspot.co.uk/
    Twitter: @ckwmcgowan
    ------------------------

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

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