DiskCacheFreeMemoryTarget

Integer

512M

Purpose

The DiskCacheFreeMemoryTarget parameter specifies the amount of physical memory the disk cache will try to keep free while honoring pool minimum and maximum segment settings. The minimum value is 32M bytes, the default value is 512M bytes, and the maximum value is one quarter of physical memory.

Because the default value of 512M could be larger than a quarter of physical memory on a virtual machine configured with 2G bytes, to support virtual machines (for prototyping, testing, and so on), the default value of this parameter for virtual machines is the minimum of 512M or a quarter of physical memory. For production databases, the minimum physical memory that is supported is 2G bytes.

Free physical memory is calculated at regular intervals, the length of which is specified by the value of the DiskCacheMemorySampleInterval parameter.

Parameter is read when …

Every 30 seconds.