Feature Properties

 

Applies To: SQL Server 2016

Feature properties pertain to product features, most of them advanced, including properties that control links between server instances.

Analysis Services supports the server properties listed in the following table. For more information about additional server properties and how to set them, see Server Properties in Analysis Services.

Applies to: Multidimensional server mode only

PropertyDefaultDescription
ManagedCodeEnabled1A Boolean property that indicates whether CLR storage procedures are enabled.
LinkInsideInstanceEnabled1A Boolean property that indicates whether a linked object can be created inside the same server instance.
LinkToOtherInstanceEnabled0A Boolean property that indicates whether objects on remote servers can be linked to.
LinkFromOtherInstanceEnabled0A Boolean property that indicates whether objects can be linked to from other server instances.
ConnStringEncryptionEnabled1A Boolean property that indicates whether the connection string is encrypted in the server configuration file.
UseCachedPageAllocators0A Boolean property that indicates whether cached page allocators are enabled.
ComUdfEnabled0A Boolean property that indicates whether user-defined functions defined as COM objects are enabled.
SQMSupportEnabled1A Boolean property that indicates whether error and feature usage reports are sent to Microsoft automatically.
ResourceMonitoringEnabled1A Boolean property that indicates whether internal resource monitoring counters are enabled. This property is on by default. When enabled, this property allows counters to collect usage data about CPU, memory, and I/O activity.

Internal resource monitoring counters are used by Dynamic Management Views (DMV) that report on resource utilization. If you disable this property, the DMV queries will still run, but the result set will be invalid. DMVs that depend on this property include the following:

 DISCOVER_OBJECT_ACTIVITY

 DISCOVER_COMMAND_OBJECTS

 DISCOVER_SESSIONS (for SESSION_READS, SESSION_WRITES, SESSION_CPU_TIME_MS)

 

Note: On a multi-core system that uses NUMA architecture, disabling this property can improve query performance, particularly for high multi-user workloads. 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.

Server Properties in Analysis Services
Determine the Server Mode of an Analysis Services Instance
Use Dynamic Management Views (DMVs) to Monitor Analysis Services

Community Additions

ADD
Show: