Export (0) Print
Expand All

Feature Properties

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 Configure Server Properties in Analysis Services.

Applies to: Multidimensional server mode only

Property

Default

Description

ManagedCodeEnabled

1

A Boolean property that indicates whether CLR storage procedures are enabled.

LinkInsideInstanceEnabled

1

A Boolean property that indicates whether a linked object can be created inside the same server instance.

LinkToOtherInstanceEnabled

0

A Boolean property that indicates whether objects on remote servers can be linked to.

LinkFromOtherInstanceEnabled

0

A Boolean property that indicates whether objects can be linked to from other server instances.

ConnStringEncryptionEnabled

1

A Boolean property that indicates whether the connection string is encrypted in the server configuration file.

UseCachedPageAllocators

0

A Boolean property that indicates whether cached page allocators are enabled.

ComUdfEnabled

0

A Boolean property that indicates whether user-defined functions defined as COM objects are enabled.

SQMSupportEnabled

1

A Boolean property that indicates whether error and feature usage reports are sent to Microsoft automatically.

ResourceMonitoringEnabled

1

A 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)

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft