Server properties in Assay Services

  • Article
  • 3 minutes to read

Applies to: SQL Server Analysis Services Azure Analysis Services Power BI Premium

Administrators tin modify default server configuration backdrop of an Azure Analysis Services (Azure Every bit) or SQL Server Analysis Services (SSAS) case. To configure server properties, use SQL Server Direction Studio.

Backdrop pages in SQL Server Direction Studio show a subset of the properties most likely to be modified. For SSAS, all properties are in the msmdsrv.ini file. In a default installation, msmdsrv.ini can be found in the \Program Files\Microsoft SQL Server\MSAS13.MSSQLSERVER\OLAP\Config folder.

Configure properties by using SQL Server Management Studio

  1. In SQL Server Management Studio, connect to an Azure AS or SSAS instance.

  2. In Object Explorer, correct-click the case, and then click Backdrop. The General folio appears, displaying the more than commonly used backdrop.

  3. To view additional properties, click the Show Advanced (All) Backdrop checkbox at the bottom of the page.

    Modifying server backdrop is supported merely for tabular fashion and multidimensional style servers. If y'all installed Power Pivot for SharePoint, ever use the default values unless otherwise directed otherwise by Microsoft Support.

Configure properties in msmdsrv.ini

Some properties can merely exist set in the msmdrsrv.ini file. These properties practice not utilise to Azure Analysis Services. If the property you desire to fix is non visible even after y'all bear witness avant-garde properties, you might need to edit the msmdsrv.ini file straight.

  1. Cheque the DataDir belongings in the Full general property page in Management Studio to verify the location of the Analysis Services program files, including the msmdsrv.ini file.

    On a server that has multiple instances, checking the program file location ensures y'all're modifying the correct file.

  2. Navigate to the config binder of the plan files folder location.

  3. Create a backup of the file in case you lot need to revert to the original file.

  4. Use a text editor to view or edit the msmdsrv.ini file.

  5. Save the file and restart the service.

Configure properties past using XMLA

Backdrop that cannot be set past using Properties in SSMS or in msmdrsrv.ini file can exist ready by using the XMLA Alter Element in an XMLA script in SSMS.

Server belongings categories

The following topics describe the various SQL Server Analysis Services configuration properties:

Topic Description
General Properties The general properties are both basic and advanced properties, and include properties that define the data directory, backup directory, and other server behaviors.
Data Mining Properties The data mining properties control which data mining algorithms are enabled and which are disabled. By default, all of the algorithms are enabled.
DAX Backdrop Defines properties related to DAX queries.
DSO DSO is no longer supported. DSO backdrop are ignored.
Feature Properties The characteristic properties pertain to product features, almost of them advanced, including properties that command links between server instances.
Filestore Properties The file store properties are for advanced use just. They include advanced memory management settings.
Lock Managing director Backdrop The lock manager properties define server behaviors pertaining to locking and timeouts. Well-nigh of these backdrop are for advanced use only.
Log Properties The log properties controls if, where, and how events are logged on the server. This includes fault logging, exception logging, flying recorder, query logging, and traces.
Retentivity Properties The retention properties control how the server uses memory. They are primarily for advanced utilise.
Network Backdrop The network backdrop control server beliefs pertaining to networking, including properties that control compression and binary XML. Nearly of these properties are for advanced apply only.
OLAP Properties The OLAP properties control cube and dimension processing, lazy processing, data caching, and query behavior. These include both basic and advanced properties.
Security Backdrop The security section contains both basic and advanced properties that ascertain access permissions. This includes settings pertaining to administrators and users.
Thread Pool Backdrop The thread pool backdrop control how many threads the server creates. These are primarily avant-garde properties.

See likewise

Analysis Services instance direction
Deploy by using the Deployment Wizard