ServerSurfaceAreaAdapter 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 facet is entirely a subset of configuration options, so it is just an interface on the ServerConfigurationAdapter
public class ServerSurfaceAreaAdapter : Microsoft.SqlServer.Management.Smo.ServerAdapterBase, Microsoft.SqlServer.Management.Facets.IDmfAdapter, Microsoft.SqlServer.Management.Sdk.Sfc.IDmfFacet, Microsoft.SqlServer.Management.Smo.ISurfaceAreaFacettype ServerSurfaceAreaAdapter = class
inherit ServerAdapterBase
interface IDmfAdapter
interface ISurfaceAreaFacet
interface IDmfFacetPublic Class ServerSurfaceAreaAdapter
Inherits ServerAdapterBase
Implements IDmfAdapter, IDmfFacet, ISurfaceAreaFacet- Inheritance
- Implements
Constructors
| ServerSurfaceAreaAdapter(Server) |
Properties
| AdHocRemoteQueriesEnabled | (Inherited from ServerAdapterBase) |
| Affinity64IOMask | (Inherited from ServerAdapterBase) |
| 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. (Inherited from ServerAdapterBase) |
| AffinityIOMask |
Binds SQL Server threads to a specified subset of CPUs. (Inherited from ServerAdapterBase) |
| AffinityMask |
Binds SQL Server disk I/O to a specified subset of CPUs. (Inherited from ServerAdapterBase) |
| AgentXPsEnabled | (Inherited from ServerAdapterBase) |
| AllowUpdates | (Inherited from ServerAdapterBase) |
| AweEnabled | (Inherited from ServerAdapterBase) |
| BackupDirectory | (Inherited from ServerAdapterBase) |
| BlockedProcessThreshold | (Inherited from ServerAdapterBase) |
| BrowserServiceAccount | (Inherited from ServerAdapterBase) |
| BrowserStartMode | (Inherited from ServerAdapterBase) |
| C2AuditTracingEnabled |
Audits all attempts to access statements and objects. Writes attempts to a file in the SQL Server Data folder. (Inherited from ServerAdapterBase) |
| ClrIntegrationEnabled | (Inherited from ServerAdapterBase) |
| Collation | (Inherited from ServerAdapterBase) |
| CommonCriteriaComplianceEnabled | (Inherited from ServerAdapterBase) |
| ContainmentEnabled |
Enables or disables contained databases and authentication using Facets, across a server instance. (Inherited from ServerAdapterBase) |
| CostThresholdForParallelism |
Specifies the threshold at which SQL Server creates and runs parallel plans for queries. (Inherited from ServerAdapterBase) |
| CrossDBOwnershipChainingEnabled | (Inherited from ServerAdapterBase) |
| CursorThreshold | (Inherited from ServerAdapterBase) |
| DatabaseMailEnabled | (Inherited from ServerAdapterBase) |
| DefaultBackupCompressionEnabled | (Inherited from ServerAdapterBase) |
| DefaultFile | (Inherited from ServerAdapterBase) |
| DefaultFullTextLanguage | (Inherited from ServerAdapterBase) |
| DefaultLanguage | (Inherited from ServerAdapterBase) |
| DefaultLog | (Inherited from ServerAdapterBase) |
| DefaultTraceEnabled | (Inherited from ServerAdapterBase) |
| DisallowResultsFromTriggers | (Inherited from ServerAdapterBase) |
| DynamicLocks |
Sets the maximum number of available locks. This option limits the amount of memory the Database Engine uses for locks. (Inherited from ServerAdapterBase) |
| ExtensibleKeyManagementEnabled | (Inherited from ServerAdapterBase) |
| FilestreamAccessLevel | (Inherited from ServerAdapterBase) |
| FilestreamLevel | (Inherited from ServerAdapterBase) |
| FilestreamShareName | (Inherited from ServerAdapterBase) |
| FillFactor | (Inherited from ServerAdapterBase) |
| FullTextCrawlBandwidthMax | (Inherited from ServerAdapterBase) |
| FullTextCrawlBandwidthMin | (Inherited from ServerAdapterBase) |
| FullTextCrawlRangeMax | (Inherited from ServerAdapterBase) |
| FullTextNotifyBandwidthMax | (Inherited from ServerAdapterBase) |
| FullTextNotifyBandwidthMin | (Inherited from ServerAdapterBase) |
| IndexCreateMemory | (Inherited from ServerAdapterBase) |
| InDoubtTransactionResolution | (Inherited from ServerAdapterBase) |
| InstallDataDirectory | (Inherited from ServerAdapterBase) |
| InstallSharedDirectory | (Inherited from ServerAdapterBase) |
| InstanceName |
The instance name of this Server (Inherited from ServerAdapterBase) |
| 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. (Inherited from ServerAdapterBase) |
| LoginAuditLevel |
Sets auditing mode for tracking Logins that have logged with success/failure. (Inherited from ServerAdapterBase) |
| LoginMode |
SQL Server Authentication Mode (Inherited from ServerAdapterBase) |
| MaxDegreeOfParallelism |
Limits the number of processors that are used to run a single statement for each parallel plan execution. (Inherited from ServerAdapterBase) |
| MaxServerMemory | (Inherited from ServerAdapterBase) |
| MaxWorkerThreads |
Configures the number of worker threads that are available to SQL Server processes. (Inherited from ServerAdapterBase) |
| MediaRetention | (Inherited from ServerAdapterBase) |
| MinMemoryPerQuery | (Inherited from ServerAdapterBase) |
| MinServerMemory | (Inherited from ServerAdapterBase) |
| NamedPipesEnabled | (Inherited from ServerAdapterBase) |
| NestedTriggersEnabled | (Inherited from ServerAdapterBase) |
| NetworkPacketSize |
Sets the packet size (in bytes) that is used across the whole network. (Inherited from ServerAdapterBase) |
| OleAutomationEnabled | (Inherited from ServerAdapterBase) |
| 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 (Inherited from ServerAdapterBase) |
| OptimizeAdhocWorkloads | (Inherited from ServerAdapterBase) |
| PrecomputeRank | (Inherited from ServerAdapterBase) |
| PriorityBoost | (Inherited from ServerAdapterBase) |
| ProtocolHandlerTimeout | (Inherited from ServerAdapterBase) |
| QueryGovernorCostLimit | (Inherited from ServerAdapterBase) |
| QueryWait | (Inherited from ServerAdapterBase) |
| RecoveryInterval | (Inherited from ServerAdapterBase) |
| RemoteAccessEnabled | (Inherited from ServerAdapterBase) |
| RemoteDacEnabled | (Inherited from ServerAdapterBase) |
| RemoteDataArchiveEnabled |
Flag indicating whether Stretch feature is enabled for the Server (Inherited from ServerAdapterBase) |
| RemoteLoginTimeout | (Inherited from ServerAdapterBase) |
| RemoteProcTransEnabled | (Inherited from ServerAdapterBase) |
| RemoteQueryTimeout | (Inherited from ServerAdapterBase) |
| ReplicationMaxTextSize | (Inherited from ServerAdapterBase) |
| ReplicationXPsEnabled | (Inherited from ServerAdapterBase) |
| ScanForStartupProcedures | (Inherited from ServerAdapterBase) |
| Server | (Inherited from ServerAdapterBase) |
| ServerTriggerRecursionEnabled | (Inherited from ServerAdapterBase) |
| ServiceBrokerEndpointActive |
Returns TRUE when a Service Broker endpoint exists and is in the STARTED state. Returns FALSE when Service Broker does not exist on the computer or it exists but is not started. Configure the endpoint to TRUE to start a stopped or disabled endpoint. The operation will fail if the endpoint does not exist on the server. Configure the endpoint to FALSE to disable the Service Broker endpoint. |
| ServiceName |
Gets service name that the server instance runs under (Inherited from ServerAdapterBase) |
| ServiceStartMode |
Gets the startup mode for the service (Inherited from ServerAdapterBase) |
| SetWorkingSetSize | (Inherited from ServerAdapterBase) |
| ShowAdvancedOptions | (Inherited from ServerAdapterBase) |
| SmoAndDmoXPsEnabled | (Inherited from ServerAdapterBase) |
| SoapEndpointsEnabled |
Returns TRUE if at least one SOAP endpoint is responding to SOAP requests. This means that the endpoint is either in the Started or Stopped state as the endpoint responds to requests in both states. Returns FALSE if all SOAP endpoints are disabled or if there are no SOAP endpoints. Configuring it to FALSE will disable all the soap endpoints. |
| SqlDomainGroup | (Inherited from ServerAdapterBase) |
| SqlMailEnabled | (Inherited from ServerAdapterBase) |
| TcpEnabled | (Inherited from ServerAdapterBase) |
| TransformNoiseWords | (Inherited from ServerAdapterBase) |
| TwoDigitYearCutoff | (Inherited from ServerAdapterBase) |
| UserConnections | (Inherited from ServerAdapterBase) |
| UserInstancesEnabled | (Inherited from ServerAdapterBase) |
| UserInstanceTimeout | (Inherited from ServerAdapterBase) |
| UserOptions | (Inherited from ServerAdapterBase) |
| WebAssistantEnabled | (Inherited from ServerAdapterBase) |
| XPCmdShellEnabled | (Inherited from ServerAdapterBase) |
Methods
| Alter() | |
| AlterEndpoints() |
This function implements the delayed setters for the endpoints properties. |
| Refresh() | |
| RefreshEndpoints() | |