SQL AS Parameters

Previous SQL DB Parameters	SQL RS Parameters Next

The parameters that are useful for a SQL Analysis Services Install are given below. The parameters cover both the basic install and the provisioning that can be performed by SQL FineBuild.

If you are happy that the default value for a given parameter is right for your organisation then you do not need to provide that parameter.

When you run SQL FineBuild you should always provide a /AdminPassword: parameter giving your own password in order to log on automatically after a reboot.

Index

The parameters are divided into the following sections:

• SQL AS Basic Install
• Account Provisioning
• Cluster Provisioning
• Configuration Provisioning
• Disk Volume and Folder Provisioning
• SSAS Farm Provisioning
• Special Situations

---

SQL AS Basic Install

The table below shows the parameters that are most commonly used with an Analysis Services Install

Parameter	Default	Comment
/SetupSQLAS:	(none)	Set to YES to install Analysis Services
/AsServerMode:	Tabular	Install mode for SSAS (Tabular or Multidimensional)
/AsSvcAccount:	(none)	Name of Analysis Services Service Account
/AsSvcPassword:	(none)	Password for Analysis Services Service Account

You should also consider the Vol Parameters

The following parameters can normally be left at their default values:

Parameter	Default	Comment
/SetupOLAP:	Yes	Configure SSAS Instance
/SetupOLAPAPI:	Yes	Configure SSAS WMI API
/ASAlias:	(blank)	DNS Alias for Analysis Services
/ASAutoStart:	0	(SQL2005 only) Analysis Services service startup type
/ASCollation:	"Latin1_General_CI_AS"	Collation setting for Analysis Services
/ASProviderMSOlap:	1	Enable MS OLAP provider to run in-process
/ASServerMode:	MultiDimensional	(SQL2012 and above) Storage mode for Analysis Services
/ASSvcStartupType:	Manual	(SQL2008 and above) Analysis Services service startup type
/TCPPortAS:	2383	Port for Analysis Services

Index

---

Account Provisioning

Parameter	Default	Comment
/AsSvcAccount:	(none)	Name of Analysis Services Service Account
/AsSvcPassword:	(none)	Password for Analysis Services Service Account
/ASSysadminAccounts:	(none)	Additional SSAS sysadmin Accounts

Index

---

Cluster Provisioning

This section shows the parameters you can add to the Basic Install in order to install an Analysis Services Cluster. These parameters are only valid if you are installing on to a Windows Cluster.

Parameter	Default	Comment
/SetupSQLASCluster:	No	Set to YES to install a SQL Server Analysis Services Cluster

The following parameters can normally be left at their default values:

Parameter	Default	Comment
/ClusterTCP:	IPv4	Default type of IP address to use for SQL AS Cluster
/ClusASSuffix:	AS	Suffix added to Windows Cluster Name to form the AS Cluster Name
/ClusASIPSuffix:	(calculated)	TCP final octet for AS Cluster address
/ClusStorage:	Available Storage	Name of cluster Available Storage group

Index

---

Configuration Provisioning

This section shows the parameters you can add to the Basic Install in order to configure an Analysis Services Cluster. For memory limits, values below 100 relate to the percentage of memory available on the server, values above 100 relate to an absolute value in KB.

The following parameters can normally be left at their default values:

Parameter	Default	Comment
/SetLowMemLimit:	65	SQL AS memory usage for starting Low Memory processing
/SetHardMemLimit:	0	SQL AS memory usage for starting Hard Limit processing
/SetTotalMemLimit:	(calculated)	SQL AS maximum memory (Byte value)
/SetVirtMemLimit:	60	SQL AS memory usage for Vertipaq processing

/SetTotalMemLimit: If no value is given then this is calculated as the lower of 8GiB or 10% of server memory

Index

---

Disk Volume and Folder Provisioning

Parameter	Default	Comment
/DirSQL:	MSSQL	Folder name to hold Analysis Server database files, etc
/VolBackupAS:	(VolBackup)	Volume to hold AS Backups
/VolDataAS:	(VolData)	Volume to hold AS databases
/VolLogAS:	(VolLog)	Volume to hold AS Logs
/VolTempAS:	(VolTemp)	Volume to hold AS temporary files

The following parameters can normally be left at their default values:

Parameter	Default	Comment
/LabBackupAS:	"AS Backup"	Volume Label to be applied to AS Backup Volume
/LabDataAS:	"AS Data"	Volume Label to be applied to AS Data Volume
/LabLogAS:	"AS Log"	Volume Label to be applied to AS Log Volume
/LabPrefix:	(none)	Prefix to be added to all Volume labels
/LabTempAS:	"AS Temp"	Volume Label to be applied to AS Temporary Files Volume

Index

---

SSAS Farm Provisioning

An SSAS Farm allows the partitions for a given Cube or Table to be located across a farm of servers to distribute the CPU and IO workload

Note The features needed to implement a SSAS Farm have been deprecated as from SQL 2014 and this feature should not be used for new installations

Parameter	Default	Comment
/FarmAccount:	(none)	Account to join SSAS Farm
/FarmPassword:	(none)	Password for account to join SSAS Farm
/FarmAdminIPort:	(none)	Administration Port for SSAS Farm

Index

---

Special Situations

• Non-English Versions Of SQL Server - please refer to the link for details of the parameters you need

Copyright FineBuild Team © 2018 - 2021. License and Acknowledgements

Previous SQL DB Parameters	Top	SQL RS Parameters Next