cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post

SQL Server Max Server Memory

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

Labels (1)
Version history
Revision #:
1 of 1
Last update:
‎02-05-2019 11:45 AM
Updated by: