Export (0) Print
Expand All

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.

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.

Community Additions

ADD
Show:
© 2014 Microsoft