ServerAdapterBase Class

Definition

This class acts as the flattener for Server properties hidden in Server.Settings and Server.Configuration Facets will inherit from this class to add new logical properties, use this class's Alter and Refresh methods, or they override the Alter and Refresh methods.

This class should not implement IDmfAdapter or any facet directly. Facets must be on leaf-level classes and this class is not intended to be a leaf-level class.

public abstract class ServerAdapterBase : Microsoft.SqlServer.Management.Common.IAlterable, Microsoft.SqlServer.Management.Common.IRefreshable
type ServerAdapterBase = class
    interface IAlterable
    interface IRefreshable
Public MustInherit Class ServerAdapterBase
Implements IAlterable, IRefreshable
Inheritance
ServerAdapterBase
Derived
Implements

Constructors

ServerAdapterBase(Server)

Properties

AdHocRemoteQueriesEnabled
Affinity64IOMask
Affinity64Mask

Binds SQL Server disk I/O to a specified subset of CPUs. This option is available only on the 64-bit version of Microsoft SQL Server.

AffinityIOMask

Binds SQL Server threads to a specified subset of CPUs.

AffinityMask

Binds SQL Server disk I/O to a specified subset of CPUs.

AgentXPsEnabled
AllowUpdates
AweEnabled
BackupDirectory
BlockedProcessThreshold
BrowserServiceAccount
BrowserStartMode
C2AuditTracingEnabled

Audits all attempts to access statements and objects. Writes attempts to a file in the SQL Server Data folder.

ClrIntegrationEnabled
Collation
CommonCriteriaComplianceEnabled
ContainmentEnabled

Enables or disables contained databases and authentication using Facets, across a server instance.

CostThresholdForParallelism

Specifies the threshold at which SQL Server creates and runs parallel plans for queries.

CrossDBOwnershipChainingEnabled
CursorThreshold
DatabaseMailEnabled
DefaultBackupCompressionEnabled
DefaultFile
DefaultFullTextLanguage
DefaultLanguage
DefaultLog
DefaultTraceEnabled
DisallowResultsFromTriggers
DynamicLocks

Sets the maximum number of available locks. This option limits the amount of memory the Database Engine uses for locks.

ExtensibleKeyManagementEnabled
FilestreamAccessLevel
FilestreamLevel
FilestreamShareName
FillFactor
FullTextCrawlBandwidthMax
FullTextCrawlBandwidthMin
FullTextCrawlRangeMax
FullTextNotifyBandwidthMax
FullTextNotifyBandwidthMin
IndexCreateMemory
InDoubtTransactionResolution
InstallDataDirectory
InstallSharedDirectory
InstanceName

The instance name of this Server

LightweightPoolingEnabled

Provides a means of reducing the system overhead that is associated with the excessive context switching that occurs sometimes in symmetric multiprocessing (SMP) environments.

LoginAuditLevel

Sets auditing mode for tracking Logins that have logged with success/failure.

LoginMode

SQL Server Authentication Mode

MaxDegreeOfParallelism

Limits the number of processors that are used to run a single statement for each parallel plan execution.

MaxServerMemory
MaxWorkerThreads

Configures the number of worker threads that are available to SQL Server processes.

MediaRetention
MinMemoryPerQuery
MinServerMemory
NamedPipesEnabled
NestedTriggersEnabled
NetworkPacketSize

Sets the packet size (in bytes) that is used across the whole network.

OleAutomationEnabled
OpenObjects

Sets the maximum number of database objects that can be open at one time on an instance of SQL Server 2000 Database objects are those objects that are defined in the sysobjects table: tables, views, rules, stored procedures, defaults, and triggers

OptimizeAdhocWorkloads
PrecomputeRank
PriorityBoost
ProtocolHandlerTimeout
QueryGovernorCostLimit
QueryWait
RecoveryInterval
RemoteAccessEnabled
RemoteDacEnabled
RemoteDataArchiveEnabled

Flag indicating whether Stretch feature is enabled for the Server

RemoteLoginTimeout
RemoteProcTransEnabled
RemoteQueryTimeout
ReplicationMaxTextSize
ReplicationXPsEnabled
ScanForStartupProcedures
Server
ServerTriggerRecursionEnabled
ServiceName

Gets service name that the server instance runs under

ServiceStartMode

Gets the startup mode for the service

SetWorkingSetSize
ShowAdvancedOptions
SmoAndDmoXPsEnabled
SqlDomainGroup
SqlMailEnabled
TcpEnabled
TransformNoiseWords
TwoDigitYearCutoff
UserConnections
UserInstancesEnabled
UserInstanceTimeout
UserOptions
WebAssistantEnabled
XPCmdShellEnabled

Methods

Alter()
Refresh()

Applies to