Data cache memory usage


Job details

Name: Data cache memory usage
Platform: Sqlserver
Category: Performance
Description: Collects data cache memory usage per database (for top 10 databases).
Long description: Collects data cache memory usage per database (for top 10 databases).
Version: 2
Default schedule: 0 * * *
Requires engine install: Yes
Compatibility tag: .[type=‘instance’ & databasetype=‘sqlserver’]/instance[maj_version > ‘2008′ & hasengine=‘YES’ & (engine_edition = ‘Microsoft SQL Server’ engine_edition = ‘Azure SQL Managed Instance’)]

Parameters

Name Default value Description
history threshold 7 The number of days the statistics are hold in the history table.
memory threshold 100 This procedure is automatically disabled if the amount of memory allocated to the MS SQL Server is higher than this parameter value (in GB). This is because it takes too many resources to read from dynamic performance view sys.dm_os_buffer_descriptors.

Job Summary

Job Description and Dependencies

Implementation

Upgrades and Maintenance

Reporting and Visualization

Operational Context

Overall, this job is essential in maintaining optimal database performance through proactive monitoring and analysis of crucial memory usage metrics.