IServerConfigurationFacet IServerConfigurationFacet IServerConfigurationFacet Interface

Definition

Important

This API is not CLS-compliant.

Contains configuration information for interfaces based on the Configuration object.

public interface class IServerConfigurationFacet : Microsoft::SqlServer::Management::Sdk::Sfc::IDmfFacet
[Microsoft.SqlServer.Management.Facets.EvaluationMode(Microsoft.SqlServer.Management.Dmf.AutomatedPolicyEvaluationMode.CheckOnChanges | Microsoft.SqlServer.Management.Dmf.AutomatedPolicyEvaluationMode.CheckOnSchedule)]
[Microsoft.SqlServer.Management.Facets.StateChangeEvent("AUDIT_SERVER_OPERATION_EVENT", "SERVER")]
[System.CLSCompliant(false)]
[System.ComponentModel.TypeConverter(typeof(Microsoft.SqlServer.Management.Sdk.Sfc.LocalizableTypeConverter))]
public interface IServerConfigurationFacet : Microsoft.SqlServer.Management.Sdk.Sfc.IDmfFacet
Public Interface IServerConfigurationFacet
Implements IDmfFacet
Derived
Attributes
Microsoft.SqlServer.Management.Facets.EvaluationModeAttribute Microsoft.SqlServer.Management.Facets.StateChangeEventAttribute CLSCompliantAttribute TypeConverterAttribute
Implements

Properties

AdHocRemoteQueriesEnabled AdHocRemoteQueriesEnabled AdHocRemoteQueriesEnabled

Gets or sets a Boolean value that specifies whether ad hoc remote queries are enabled.

Affinity64IOMask Affinity64IOMask Affinity64IOMask

Gets the affinity64 IO mask for a server.

Affinity64Mask Affinity64Mask Affinity64Mask

Gets or sets the affinity 64 mask for a server.

AffinityIOMask AffinityIOMask AffinityIOMask

Gets the affinity IO mask for a server.

AffinityMask AffinityMask AffinityMask

Gets the affinity mask for a server.

AgentXPsEnabled AgentXPsEnabled AgentXPsEnabled

Gets or sets a Boolean value that specifies whether the SQL Server Agent extended stored procedures are enabled.

AllowUpdates AllowUpdates AllowUpdates

Gets or sets a Boolean value that specifies whether the allow updates option is set.

AweEnabled AweEnabled AweEnabled

Gets a Boolean value that specifies if the awe enabled value is set.

BlockedProcessThreshold BlockedProcessThreshold BlockedProcessThreshold

Gets or sets the blocked process threshold.

C2AuditTracingEnabled C2AuditTracingEnabled C2AuditTracingEnabled

Gets a Boolean value that specifies if the C2 audit tracing is set.

ClrIntegrationEnabled ClrIntegrationEnabled ClrIntegrationEnabled

Gets or sets a Boolean value that specifies if the CLR integration value is set.

CommonCriteriaComplianceEnabled CommonCriteriaComplianceEnabled CommonCriteriaComplianceEnabled

Gets a Boolean value that specifies if the common criteria compliance value is set.

ContainmentEnabled ContainmentEnabled ContainmentEnabled

Gets the value that indicates whether the containment is enabled.

CostThresholdForParallelism CostThresholdForParallelism CostThresholdForParallelism

Gets or sets the value contained in the cost threshold for parallelism property.

CrossDBOwnershipChainingEnabled CrossDBOwnershipChainingEnabled CrossDBOwnershipChainingEnabled

Gets or sets a Boolean value that specifies if the cross DBOwnership chaining value is set.

CursorThreshold CursorThreshold CursorThreshold

Gets or sets the cursor threshold value.

DatabaseMailEnabled DatabaseMailEnabled DatabaseMailEnabled

Gets a Boolean value that specifies if the DatabaseMailEnabled property is set.

DefaultBackupCompressionEnabled DefaultBackupCompressionEnabled DefaultBackupCompressionEnabled

Gets or sets a Boolean value that specifies if the BackupCompressionEnabled option is set.

DefaultFullTextLanguage DefaultFullTextLanguage DefaultFullTextLanguage

Gets or sets the DefaultFullTextLanguage property.

DefaultLanguage DefaultLanguage DefaultLanguage

Gets or sets the DefaultLanguage property.

DefaultTraceEnabled DefaultTraceEnabled DefaultTraceEnabled

Gets or sets a Boolean value that specifies if the DefaultTraceEnabled property is set.

DisallowResultsFromTriggers DisallowResultsFromTriggers DisallowResultsFromTriggers

Gets or sets a Boolean value that specifies if the DisallowResultsFromTriggers property is set.

DynamicLocks DynamicLocks DynamicLocks

Gets the value of the DynamicLocks property.

ExtensibleKeyManagementEnabled ExtensibleKeyManagementEnabled ExtensibleKeyManagementEnabled

Gets a Boolean value that specifies if the ExtensibleKeyManagementEnabled property is set.

FilestreamAccessLevel FilestreamAccessLevel FilestreamAccessLevel

Gets or sets the level of access permitted on the servers FILESTREAM operations.

FillFactor FillFactor FillFactor

Gets the value of the FillFactor property.

FullTextCrawlBandwidthMax FullTextCrawlBandwidthMax FullTextCrawlBandwidthMax

Gets or sets the maximum value of the full text crawl bandwidth.

FullTextCrawlBandwidthMin FullTextCrawlBandwidthMin FullTextCrawlBandwidthMin

Gets or sets the minimum value of the full text crawl bandwidth.

FullTextCrawlRangeMax FullTextCrawlRangeMax FullTextCrawlRangeMax

Gets or sets the maximum value of the full text crawl range.

FullTextNotifyBandwidthMax FullTextNotifyBandwidthMax FullTextNotifyBandwidthMax

Gets or sets the maximum value of the full text notify bandwidth.

FullTextNotifyBandwidthMin FullTextNotifyBandwidthMin FullTextNotifyBandwidthMin

Gets or sets the FullTextNotifyBandwidthMin property value.

IndexCreateMemory IndexCreateMemory IndexCreateMemory

Gets or sets the IndexCreateMemory property value.

InDoubtTransactionResolution InDoubtTransactionResolution InDoubtTransactionResolution

Gets or sets the InDoubtTransactionResolutionType property value.

LightweightPoolingEnabled LightweightPoolingEnabled LightweightPoolingEnabled

Gets a Boolean value that specifies if the LightweightPoolingEnabled property value is set.

MaxDegreeOfParallelism MaxDegreeOfParallelism MaxDegreeOfParallelism

Gets or sets the MaxDegreeOfParallelism property value.

MaxServerMemory MaxServerMemory MaxServerMemory

Gets or sets the MaxServerMemory property value.

MaxWorkerThreads MaxWorkerThreads MaxWorkerThreads

Gets the MaxWorkerThreads property value.

MediaRetention MediaRetention MediaRetention

Gets or sets the media retention.

MinMemoryPerQuery MinMemoryPerQuery MinMemoryPerQuery

Gets or set the MinMemoryPerQuery property value.

MinServerMemory MinServerMemory MinServerMemory

Gets or sets the MinServerMemory property value.

NestedTriggersEnabled NestedTriggersEnabled NestedTriggersEnabled

Gets or sets a Boolean value that specifies if the NestedTriggersEnabled property value is set.

NetworkPacketSize NetworkPacketSize NetworkPacketSize

Gets or sets the NetworkPacketSize property value.

OleAutomationEnabled OleAutomationEnabled OleAutomationEnabled

Gets or sets a Boolean value that specifies if the OleAutomationEnabled property value is set.

OpenObjects OpenObjects OpenObjects

Gets the OpenObjects property value.

OptimizeAdhocWorkloads OptimizeAdhocWorkloads OptimizeAdhocWorkloads

Gets or sets a value that determines whether ad hoc workloads will be optimized.

PrecomputeRank PrecomputeRank PrecomputeRank

Gets or sets a Boolean value that specifies if the PrecomputeRank property value is set.

PriorityBoost PriorityBoost PriorityBoost

Gets a Boolean value that specifies if the PriorityBoost property value is set.

ProtocolHandlerTimeout ProtocolHandlerTimeout ProtocolHandlerTimeout

Gets or sets the ProtocolHandlerTimeout property value.

QueryGovernorCostLimit QueryGovernorCostLimit QueryGovernorCostLimit

Gets or sets the maximum estimated cost allowed by query governor.

QueryWait QueryWait QueryWait

Gets or sets the query wait.

RecoveryInterval RecoveryInterval RecoveryInterval

Gets or sets the RecoveryInterval property value.

RemoteAccessEnabled RemoteAccessEnabled RemoteAccessEnabled

Gets a Boolean value that specifies if the RemoteAccessEnabled property has been set.

RemoteDacEnabled RemoteDacEnabled RemoteDacEnabled

Gets or sets a Boolean value that specifies if the RemoteDacEnabled property is set.

RemoteDataArchiveEnabled RemoteDataArchiveEnabled RemoteDataArchiveEnabled

Gets or sets a value that indicates whether the remote data archive is enabled.

RemoteLoginTimeout RemoteLoginTimeout RemoteLoginTimeout

Gets or sets the RemoteLoginTimeout property value.

RemoteProcTransEnabled RemoteProcTransEnabled RemoteProcTransEnabled

Gets or sets a Boolean value that specifies if the RemoteProcTransEnabled is set.

RemoteQueryTimeout RemoteQueryTimeout RemoteQueryTimeout

Gets or sets the RemoteQueryTimeout property value.

ReplicationMaxTextSize ReplicationMaxTextSize ReplicationMaxTextSize

Gets or sets the ReplicationMaxTextSize property value.

ReplicationXPsEnabled ReplicationXPsEnabled ReplicationXPsEnabled

Gets or sets a Boolean value that specifies if the ReplicationXPsEnabled property is set.

ScanForStartupProcedures ScanForStartupProcedures ScanForStartupProcedures

Gets or sets a Boolean value that specifies if the ScanForStartupProcedures property is set.

ServerTriggerRecursionEnabled ServerTriggerRecursionEnabled ServerTriggerRecursionEnabled

Gets or sets a Boolean value that specifies if the ServerTriggerRecursionEnabled property is set.

SetWorkingSetSize SetWorkingSetSize SetWorkingSetSize

Gets a Boolean value that specifies if the SetWorkingSetSize property value is set.

ShowAdvancedOptions ShowAdvancedOptions ShowAdvancedOptions

Gets or sets a Boolean value that specifies if the ShowAdvancedOptions property value is set.

SmoAndDmoXPsEnabled SmoAndDmoXPsEnabled SmoAndDmoXPsEnabled

Gets or sets a Boolean value that specifies if the SmoAndDmoSPsEnabled property value is set.

SqlMailEnabled SqlMailEnabled SqlMailEnabled

Gets or sets a Boolean value that specifies if the SqlMailEnabled property value is set.

TransformNoiseWords TransformNoiseWords TransformNoiseWords

Gets or sets a Boolean value that specifies if the TransformNoiseWords property value is set.

TwoDigitYearCutoff TwoDigitYearCutoff TwoDigitYearCutoff

Gets or sets the TwoDigitYearCutoff property value.

UserConnections UserConnections UserConnections

Gets or sets the connections of the user.

UserInstancesEnabled UserInstancesEnabled UserInstancesEnabled

Gets or sets a Boolean value that specifies if the UserInstancesEnabled property value is set.

UserInstanceTimeout UserInstanceTimeout UserInstanceTimeout

Gets or sets the UserInstanceTimeout property value.

UserOptions UserOptions UserOptions

Gets or sets the UserOptions property value.

WebAssistantEnabled WebAssistantEnabled WebAssistantEnabled

Gets or sets a Boolean value that specifies if the WebAssistantEnabled property value is set

XPCmdShellEnabled XPCmdShellEnabled XPCmdShellEnabled

Gets or sets a Boolean value that specifies if the XPCmdShellEnabled property is set.

Applies to