Post reply

check the physical memory in use by sql

  • August 15, 2012 at 7:06 am

    #279686

    HI

    I use sys.dm_os_process_memory in sql server 2008 for checking the physical memory in use

    Is there any way I could script to check the physical memory in use by sql for the server running sql 2005?

  • August 15, 2012 at 7:08 am

    #1525979

    query sys.dm_os_performance_counters

    ---------------------------------------------------------------------

  • August 15, 2012 at 7:15 am

    #1525984

    Thanks

    but it does not show large_page_allocations_kb and locked_page_allocations_kb

    if they are available.

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

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