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.