• Article

Memory Properties

Microsoft SQL Server Analysis Services supports the server memory properties listed in the following table. To view or change these properties for an instance of Analysis Services, in SQL Server Management Studio, right-click the Analysis Services instance, and then click Properties.

Properties

  • DefaultPagesCountToReuse
    An advanced property that you should not change, except under the guidance of Microsoft support.

  • HeapTypeForObjects
    An advanced property that you should not change, except under the guidance of Microsoft support.

  • HighMemoryPrice
    An advanced property that you should not change, except under the guidance of Microsoft support.

  • LowMemoryLimit
    A signed 64-bit double-precision floating-point number property that defines the point at which the server is low on memory, expressed as percentage of total physical memory. When this threshold is reached, the server aggressively looks for opportunities to free up memory.

    The default value for this property is 75, which indicates the low memory limit is 75% of physical memory.

  • MemoryHeapType
    An advanced property that you should not change, except under the guidance of Microsoft support.

  • MidMemoryPrice
    An advanced property that you should not change, except under the guidance of Microsoft support.

  • MinimumAllocatedMemory
    An advanced property that you should not change, except under the guidance of Microsoft support.

  • SessionMemoryLimit
    An advanced property that you should not change, except under the guidance of Microsoft support.

  • TotalMemoryLimit
    A property that defines the maximum physical memory the server will use, expressed as percentage of total physical memory.

    The default value for this property is 80, which indicates that no more than 80% of physical memory will be used.

  • VirtualMemoryLimit
    An advanced property that you should not change, except under the guidance of Microsoft support.

  • WaitCountIfHighMemory
    An advanced property that you should not change, except under the guidance of Microsoft support.