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