Muokkaa

Jaa


Feature properties

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

Feature properties pertain to product features, most of them advanced, including properties that control links between server instances. In Power BI, all Feature properties are Read Only.

Properties

Property Default Description
ManagedCodeEnabled 1 A Boolean property that indicates whether CLR storage procedures are enabled. Applies to Multidimensional mode server instances only.
LinkInsideInstanceEnabled 1 A Boolean property that indicates whether a linked object can be created inside the same server instance. Applies to Multidimensional mode server instances only.
LinkToOtherInstanceEnabled 0 A Boolean property that indicates whether objects on remote servers can be linked to. Applies to Multidimensional mode server instances only.
LinkFromOtherInstanceEnabled 0 A Boolean property that indicates whether objects can be linked to from other server instances. Applies to Multidimensional mode server instances only.
ConnStringEncryptionEnabled 1 A Boolean property that indicates whether the connection string is encrypted in the server configuration file. Applies to Multidimensional mode server instances only.
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. Applies to Multidimensional mode server instances only.
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)



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.
ResourceTrackingEnabled -1 An Integer property that indicates whether resource memory tracking is enabled, which is used to support accurate memory tracking for queries. The following values are supported: -1: Automatic (Enabled); 0: Disabled; 1: Enabled. Applies to SQL Server 2022 and later Analysis Services Tabular server mode only.

See also

Server properties in Analysis Services
Determine the server mode of an Analysis Services instance
Use Dynamic Management Views (DMVs) to monitor Analysis Services