Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Filestore Properties

Analysis Services supports the filestore server properties listed in the following tables. These are all advanced properties that you should not change, except under the guidance of Microsoft support. For more information about additional server properties and how to set them, see Configure Server Properties in Analysis Services.

Applies to: Multidimensional and Tabular server mode

BackgroundTrimAmount

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

BackgroundTrimCost

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

MemoryLimit

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

MemoryLimitMin

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

PercentScanPerPrice

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

PerformanceTrace

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

RandomFileAccessMode

A Boolean property that indicates whether database files and cached files are accessed in random file access mode. This property is off by default. By default, Analysis Services does not set the random file access flag when opening partition data files for read access. 

On high-end systems, particularly those with large memory resources and multiple NUMA nodes, it can be advantageous to use random file access. In random access mode, Windows bypasses page mapping operations that read data from disk into the system file cache, thereby lowering contention on the cache.

You will need to run comparison tests to determine whether query performance is improved as the result of changing this property. For best practices on running comparison tests, including clearing the cache and avoiding common mistakes, see the SQL Server 2008 R2 Analysis Services Operations Guide. For additional information on the tradeoffs of using this property, see http://support.microsoft.com/kb/2549369.

To view or modify this property in Management Studio, enable the advanced properties list in the server properties page. You can also change the property in the msmdsrv.ini file. Restarting the server is recommended after setting this property; otherwise files that are already open will continue to be accessed in the previous mode.

UnbufferedThreshold

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

MemoryModel\Tax

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

MemoryModel\Income

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

MemoryModel\MaximumBalance

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

MemoryModel\MinimumBalance

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

MemoryModel\InitialBonus

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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.