Version 1

    DESCRIPTION

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

     

    METRIC DEFINITION

    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)'