SETTING: Memory Allocation - % of Data Size

Other memory settings in RockSolid allow you to identify if the target SQL Server instance(s) have the correct amount of available OSE memory allocated to the SQL Server process. If not, then a compliance alert will be raised and managed via the RockSolid console.

This setting however takes a slightly different approach. This setting allows you to specify the minimum amount of memory that should be allocated based on the total database data size currently located on a given instance. This allows you to set a minimum memory to data ratio, which when exceed will raise a compliance alert.

Usage

Memory and other resources are typically allocated based on expected database size when deploying the application. Overtime databases typically increase in size. Sometimes this is based on expectations and sometimes this vastly exceeds the expected growth as usage of the application may change over time.

This setting in RockSolid allows you to identify instances which have low memory allocations based on their current data volumes, allowing you to review and determine if memory allocations should be increased to ensure optimal performance. Once compliance alerts are raised by RockSolid the administrator can:

Review memory allocations and memory performance indicators to determine if additional memory is required, if so allocate additional memory closing off the compliance alert; or

Make a determination that the memory allocation is sufficient for the relevant instance and update the instance level policy, specifying a custom memory to data ratio or a specific memory allocation setting.

NOTE: This is a basic form of determining if memory allocation is insufficient designed to allow administrators to implement global best practices. RockSolid also provides more in-depth memory analysis capabilities which can raise alerts if current memory allocations are generating performance statistics that indicate memory as a bottleneck.