ServerAdapterBase Class
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
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.IRefreshabletype ServerAdapterBase = class
interface IAlterable
interface IRefreshablePublic 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() |