Database Reference
In-Depth Information
The main server properties that control the Analysis Services Memory Manager are
shown in the following screenshot:
All Analysis Services server property values are held in a
configuration file called
msmdsrv.ini
. Whenever we edit server
property values in SQL Server Management Studio, the changes are
written back to this file. Some Analysis Services server properties
can only be seen by clicking on the
Show Advanced (All) Properties
checkbox, but even then there are still some properties in
msmdsrv.
ini
that aren't visible at all in SQL Server Management Studio. The
only way to access these properties is to edit the
msmdsrv.ini
ile manually. However, all the settings we discuss in this topic are
visible in SQL Server Management Studio.
Search WWH ::
Custom Search