How to query SQL Server Memory Manager performance counters in DMV?

1 vote

2 answers

638 views

memory sql-server-2017 dmv performance-counters memory-manager

                          Is there any system catalog views or DMVs that can be used to query (in SSMS for example) below performance counters from SQL Server:Memory Manager ?

    Free Memory (KB)
    Target Server Memory
    Total Server Memory
    Maximum Workspace Memory (KB)
    Database Cache Memory (KB)
    Granted Workspace Memory (KB)
    Lock Memory (KB)
    Log Pool Memory (KB)
    Optimizer Memory (KB)
    Connection Memory (KB)
    SQL Cache Memory (KB)
    Reserved Server Memory (KB)
    Stolen Server Memory (KB)


                        

Asked by Aleksey Vitsko (6195 rep)

Oct 29, 2019, 07:41 PM
Last activity: Nov 1, 2019, 09:36 AM

How to query SQL Server Memory Manager performance counters in DMV?

Related Questions