Post reply

Memory Utilised by SQL Server

  • October 11, 2011 at 12:38 am

    #249656

    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

  • October 11, 2011 at 1:56 am

    This was removed by the editor as SPAM

  • October 11, 2011 at 2:03 am

    #1392699

    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

  • October 11, 2011 at 3:50 am

    #1392737

    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

  • October 11, 2011 at 9:14 am

    #1392937

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

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