Version 1


    Get the Max Server Memory and plot it over time. Adjust the frequency accordingly, but typically, this metric will not change often.



    To create the custom metric, click on Options -> Custom Resource Metrics and configure the metric similar to this:


    Database Versions: 10.0.0 and above

    Display Name:  Max Server Memory

    Description:  Get Max Server Memory size that this SQL Server instance can grow into

    Category:  Memory

    Units:  MB

    Metric Type:  Single Value

    Frequency:  600

    Timeout:  20


    SQL Statement:


    select cast(value as int)/1024/1024 from sys.configurations where name = 'max server memory (MB)'