Post reply

SQL Server Memory

  • July 4, 2017 at 6:51 pm

    #1949387

    "Available MBytes
    ....
    This counter cannot be queried through T-SQL; it has to be observed through Perfmon only."

    Can't you use sys.dm_os_sys_memory to pick that up?

    SELECT available_physical_memory_kb FROM sys.dm_os_sys_memory

  • July 5, 2017 at 11:49 am

    #1949546

    Can I repost the performance metrics you discuss to my wiki?

    • Page Life Expectancy
    • Available Bytes
    • Buffer Cache Hit Ratio
    • Target & Total Server Memory
    • Memory Grants Pending
    • Pages/sec (Hard Page Faults)
    • Batch Requests/sec & Compilations/sec

    Thanks!

    412-977-3526 call/text

Viewing 2 posts - 16 through 16 (of 16 total)

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