Share via


General Properties

Microsoft SQL Server Analysis Services supports the server properties listed in the following tables. 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.

Non-Specific Category

  • AdminTimeout
    A signed 32-bit integer property that defines the administrator timeout in seconds. This is an advanced property that you should not change, except under the guidance of Microsoft support.

    The default value for this property is zero (0), which indicates there is no timeout.

  • AllowedBrowsingFolders
    A string property that defines the names of the folders where logs, backups, and other objects are allowed to be created on the server, in the form of a comma-separated list.

  • BackupDir
    A string property that identifies the name of the directory where backup files are created by default, in the event a path is not specified as part of the the Backup command.

  • CollationName
    A string property that identifies the server collation. For more information, see Languages and Collations (Analysis Services - Multidimensional Data).

  • CommitTimeout
    A signed 32-bit integer property that defines the number of milliseconds before pending commit operations time out.

    The default value for this property is zero (0), which indicates that the server will not time out commit operations.

  • CoordinatorBuildMaxThreads
    A signed 32-bit integer property that defines the maximum number of threads allocated to building partition indexes. Increase this value in order to speed-up partition indexing, at the cost of memory usage.

  • CoordinatorCancelCount
    A signed 32-bit integer property that defines how frequently the server should check whether a Cancel event occurred (based on internal iteration count). Decrease this number in order to check for Cancel more frequently, at the expense of general performance.

  • CoordinatorExecutionMode
    A signed 32-bit integer property that defines the maximum number of parallel operations the server will attempt, including processing and querying operations. Zero (0) indicates that the server will decide, based on an internal algorithm. A positive number indicates the maximum number of operations in total. A negative number, with the sign reversed, indicates the maximum number of operations per processor.

    The default value for this property is -4, which indicates the server is limited to 4 parallel operations per processor.

  • CoordinatorQueryMaxThreads
    A signed 32-bit integer property that defines the maximum number of threads per partition segment during query resolution. The fewer the number of concurrent users, the higher this value can be, at the cost of memory. Conversely, it may need to be lowered if there are a large number of concurrent users.

  • CoordinatorShutdownMode
    A Boolean property that defines coordinator shutdown mode. This is an advanced property that you should not change, except under the guidance of Microsoft support.

  • DataDir
    A string property that identifies the name of the directory where data is stored.

  • Durability
    A Boolean property that indicates whether the data is to be saved on each commit event. By default, this value is set to false; this specifies that the data is to be saved only upon an explicit request from the user. A value of 1 indicates 'true'. Any other value represents 'false'.

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

  • ExternalCommandTimeout
    A signed 32-bit integer property that defines the timeout, in seconds, for commands issued to external servers, including relational data sources and external Analysis Services servers.

    The default value for this property is 3600 (seconds).

  • ExternalConnectionTimeout
    A signed 32-bit integer property that defines the timeout, in seconds, for creating connections to external servers, including relational data sources and external Analysis Services servers.

    The default value for this property is 60 (seconds).

  • ForceCommitTimeout
    A signed 32-bit integer property that defines the timeout, in milliseconds, before a commit should cancel other commands that preceded the current command, including queries in process.

    The default value for this property is 30 seconds (30000 milliseconds), which indicates that other commands will not be forced to timeout when the current command times out.

    Note

    Queries and processes cancelled by this event will report the following error message: "Server: The operation has been cancelled"

  • IdleConnectionTimeout
    A signed 32-bit integer property that defines the idle connection timeout, in seconds.

    The default value for this property is zero (0), which indicates that idle connections will not be timed out.

  • IdleOrphanSessionTimeout
    A signed 32-bit integer property that defines how long orphaned sessions will be retained in server memory in seconds.

  • ImbiMode
    A Boolean property that indicates whether the server instance is to be started in VertiPaq (IMBI) mode. A value of 1 indicates 'true'. Any other value represents 'false'.

  • InstanceVisible
    A Boolean property that indicates whether the server instance is visible to discover instance requests.

  • Language
    A string property that defines the language, including error messages and number formatting. This property overrides the CollationName property.

    The default value for this property is blank, which indicates that the CollationName property defines the language.

  • LogDir
    A string property that identifies the name of the directory that contains server logs. This property only applies when disk files are used for logging, as opposed to database tables (the default behavior).

  • MaxIdleSessionTimeout
    A signed 32-bit integer property that defines the maximum idle session timeout, in seconds.

  • MinIdleSessionTimeout
    A signed 32-bit integer property that defines the minimum time, in seconds, that idle sessions will timeout. After this time expires, the server is permitted to end the idle session, but will only do so as memory is needed.

  • Port
    A signed 32-bit integer property that defines the port number on which server will listen for client connections. If not set, server dynamically finds first unused port.

    The default value for this property is zero (0), which in turn defaults to port 2383.

  • ServerTimeout
    A signed 32-bit integer property that defines the timeout in seconds for queries.

  • TempDir
    A string property that identifies the name of the directory for defining temporary files used for processing, restoring, and other operations.

    The default value for this property is determined by setup. If not specified, the default is the Data directory.

RequestPrioritization Category

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

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