Utility 类

The Utility class represents a utility control point (UCP) that defines methods and properties to manage one or more remote instances of SQL Server.

继承层次结构

System.Object
  Microsoft.SqlServer.Management.Sdk.Sfc.SfcInstance
    Microsoft.SqlServer.Management.Utility.Utility

命名空间:  Microsoft.SqlServer.Management.Utility
程序集:  Microsoft.SqlServer.Management.Utility(在 Microsoft.SqlServer.Management.Utility.dll 中)

语法

声明
<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)> _
<LocalizedPropertyResourcesAttribute("Microsoft.SqlServer.Management.Utility.FacetSR",  _
    True)> _
<PhysicalFacetAttribute> _
<TypeConverterAttribute(GetType(LocalizableTypeConverter))> _
Public NotInheritable Class Utility _
    Inherits SfcInstance _
    Implements ISfcDomain2, ISfcDomain, ISfcDomainLite, ISfcHasConnection,  _
    ISfcAlterable, IAlterable
用法
Dim instance As Utility
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)]
[LocalizedPropertyResourcesAttribute("Microsoft.SqlServer.Management.Utility.FacetSR", 
    true)]
[PhysicalFacetAttribute]
[TypeConverterAttribute(typeof(LocalizableTypeConverter))]
public sealed class Utility : SfcInstance, 
    ISfcDomain2, ISfcDomain, ISfcDomainLite, ISfcHasConnection, ISfcAlterable, 
    IAlterable
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode::CheckOnSchedule)]
[LocalizedPropertyResourcesAttribute(L"Microsoft.SqlServer.Management.Utility.FacetSR", 
    true)]
[PhysicalFacetAttribute]
[TypeConverterAttribute(typeof(LocalizableTypeConverter))]
public ref class Utility sealed : public SfcInstance, 
    ISfcDomain2, ISfcDomain, ISfcDomainLite, ISfcHasConnection, ISfcAlterable, 
    IAlterable
[<SealedAttribute>]
[<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)>]
[<LocalizedPropertyResourcesAttribute("Microsoft.SqlServer.Management.Utility.FacetSR", 
    true)>]
[<PhysicalFacetAttribute>]
[<TypeConverterAttribute(typeof(LocalizableTypeConverter))>]
type Utility =  
    class 
        inherit SfcInstance 
        interface ISfcDomain2 
        interface ISfcDomain 
        interface ISfcDomainLite 
        interface ISfcHasConnection 
        interface ISfcAlterable 
        interface IAlterable 
    end
public final class Utility extends SfcInstance implements ISfcDomain2, ISfcDomain, ISfcDomainLite, ISfcHasConnection, ISfcAlterable, IAlterable

Utility 类型公开以下成员。

构造函数

  名称 说明
公共方法 Utility() Initializes a new, default instance of the Utility class.
公共方法 Utility(SqlStoreConnection) Initializes a new instance of the Utility class with the specified connection to SqlStore.

页首

属性

  名称 说明
受保护属性 AbstractIdentityKey 不要在您的代码中直接引用此成员。它支持 SQL Server 基础结构。 (从 SfcInstance 继承。)
公共属性 Computers Gets the collection of computers running managed instances.
公共属性 CreatedBy Gets the authentication credentials for the user who created the Utility.
公共属性 DateCreated Gets the date and time when the SQL Server Utility was created.
公共属性 DeployedDacCount Gets the number of deployed DACs on the instances of SQL Server managed by the SQL Server Utility.
公共属性 DeployedDacHealthyCount Gets the number of healthy deployed DACs on the instances of SQL Server managed by the SQL Server Utility.
公共属性 DeployedDacManagementPendingCount Gets the number of deployed DAC instances that have a pending management status.
公共属性 DeployedDacOnOverutilizedComputerCount Gets the number of DACs that are deployed on managed instances run on overutilized computers.
公共属性 DeployedDacOnUnderutilizedComputerCount Gets the number of DACs that are deployed on managed instances run on underutilized computers.
公共属性 DeployedDacOverutilizedCount Gets the number of overutilized deployed DACs.
公共属性 DeployedDacs Gets the number of DACs that are deployed on managed instances.
公共属性 DeployedDacUnderutilizedCount Gets the number of deployed, underutilized DACs on all the managed instances.
公共属性 DeployedDacUnhealthyCount Gets the number of deployed unhealthy DACs on all the managed instances.
公共属性 DeployedDacWithFilesOnOverutilizedVolumeCount Gets the number of deployed DACs that have files on overutilized volumes.
公共属性 DeployedDacWithFilesOnUnderutilizedVolumeCount Gets the number of deployed DACs that have files on underutilized volumes.
公共属性 DeployedDacWithOverutilizedFileCount Gets the number of deployed DACs that have overutilized files.
公共属性 DeployedDacWithOverutilizedProcessorCount Gets the number of deployed DACs that operate over overutilized processors.
公共属性 DeployedDacWithUnderutilizedFileCount Gets the number of deployed DACs that have underutilized files.
公共属性 DeployedDacWithUnderutilizedProcessorCount Gets the number of deployed DACs that operate on underutilized processors.
公共属性 Description Gets or sets a String describing the UCP.
公共属性 ManagedInstanceCount Gets the number of instances of SQL Server managed by the UCP.
公共属性 ManagedInstanceHealthyCount Gets the number of healthy instances of SQL Server managed by the UCP.
公共属性 ManagedInstanceManagementPendingCount Gets the number of instances of SQL Server that have a pending management status.
公共属性 ManagedInstanceOnOverutilizedComputerCount Gets the number of managed instances of SQL Server that are running on overutilized computers.
公共属性 ManagedInstanceOnUnderutilizedComputerCount Gets the number of managed instances of SQL Server that are running on underutilized computers.
公共属性 ManagedInstanceOverutilizedCount Gets the number of overutilized managed instances of SQL Server.
公共属性 ManagedInstances Gets a collection containing each instance of SQL Server managed by this Utility.
公共属性 ManagedInstanceUnderutilizedCount Gets the number of managed instances of SQL Server that are underutilized.
公共属性 ManagedInstanceUnhealthyCount Gets the number of unhealthy managed instances of SQL Server.
公共属性 ManagedInstanceWithFilesOnOverutilizedVolumeCount Gets the number of managed instances of SQL Server that have files on overutilized volumes.
公共属性 ManagedInstanceWithFilesOnUnderutilizedVolumeCount Gets the number of managed instances of SQL Server that have files on underutilized volumes.
公共属性 ManagedInstanceWithOverutilizedFileCount Gets the number of managed instances of SQL Server that have overutilized files.
公共属性 ManagedInstanceWithOverutilizedProcessorCount Gets the number of managed instances of SQL Server that are executed on overutilized processors.
公共属性 ManagedInstanceWithUnderutilizedFileCount Gets the number of managed instances of SQL Server with underutilized files.
公共属性 ManagedInstanceWithUnderutilizedProcessorCount Gets the number of managed instances of SQL Server that are executed on underutilized processors.
公共属性 MdwDatabaseName Gets or sets the name of the utility management data warehouse (UMDW) database.
公共属性 MdwRetentionLengthInDaysForDaysHistory Gets or sets the length, in days, that data will be retained in the Management Data Warehouse (MDW) history table for per-day entries.
公共属性 MdwRetentionLengthInDaysForHoursHistory Gets or sets the length in days that data will be retained in the utility management data warehouse (UMDW) history table for per-hour entries.
公共属性 MdwRetentionLengthInDaysForMinutesHistory Gets or sets the length in days that data will be retained in the utility management data warehouse (UMDW) history table for per-minute entries.
公共属性 Metadata Returns metadata about the instance and its domain. (从 SfcInstance 继承。)
公共属性 Name Gets the name of the connected SQL Store server.
公共属性 OverUtilizationOccurenceFrequency Gets or sets the occurrence frequency that is used to computer over-utilization health states over the specified trailing window.
公共属性 OverUtilizationTrailingWindow Gets or sets the trailing window, in hours, used to compute health states.
公共属性 Parent Gets or sets the instance parent via the keychain. (从 SfcInstance 继承。)
公共属性 PolicyStore Gets the PolicyStore object that defines the policies of the SQL Store connection.
公共属性 Properties Returns a collection instance properties. (从 SfcInstance 继承。)
公共属性 SqlStoreConnection Gets or sets the SQL Store connection
受保护属性 State Returns the state of the SfcInstance object. (从 SfcInstance 继承。)
公共属性 TotalStorageCapacity Gets the storage capacity of the Utility.
公共属性 TotalStorageUtilization Gets the amount of SQL Server Utility storage that is currently used.
公共属性 UnderUtilizationOccurenceFrequency Gets or sets the occurrence frequency that is used to computer underutilization health states over the specified trailing window.
公共属性 UnderUtilizationTrailingWindow Gets or sets the trailing window, in hours, used to compute health states.
公共属性 Urn Returns the uniform resource name of the SfcInstance object. (从 SfcInstance 继承。)
公共属性 UtilityName Gets the name of the utility control point (UCP).

页首

方法

  名称 说明
公共方法 Alter Updates any Utility property changes on the instance of SQL Server.
公共方法静态成员 Connect Returns a SqlStoreConnection object specified by connection.
受保护方法 CreateIdentityKey 不要在您的代码中直接引用此成员。它支持 SQL Server 基础结构。 (从 SfcInstance 继承。)
公共方法静态成员 CreateUtility(String, SqlStoreConnection) Creates a Utility object.
公共方法静态成员 CreateUtility(String, SqlStoreConnection, String, SqlSecureString) Creates a Utility object.
公共方法 Discover 不要在您的代码中直接引用此成员。它支持 SQL Server 基础结构。 (从 SfcInstance 继承。)
公共方法 EnrollInstance(SqlStoreConnection) Enrolls a Utility object with the connection supplied by sqlStoreConnection parameter.
公共方法 EnrollInstance(SqlStoreConnection, String, SqlSecureString) Enrolls a Utility object with the connection supplied by sqlStoreConnection parameter.
公共方法 Equals (从 Object 继承。)
受保护方法 GetChildCollection 不要在您的代码中直接引用此成员。它支持 SQL Server 基础结构。 (从 SfcInstance 继承。)
公共方法 GetDomain 不要在您的代码中直接引用此成员。它支持 SQL Server 基础结构。 (从 SfcInstance 继承。)
公共方法 GetHashCode (从 Object 继承。)
公共方法 GetPropertySet Returns the set of properties for the SfcInstance object. (从 SfcInstance 继承。)
公共方法 GetType (从 Object 继承。)
受保护方法 GetTypeMetadataImpl Indicates the domains that override by returning the right TypeMetadata class directly. 不要在您的代码中直接引用此成员。它支持 SQL Server 基础结构。 (从 SfcInstance 继承。)
受保护方法 InitializeUIPropertyState 不要在您的代码中直接引用此成员。它支持 SQL Server 基础结构。 (从 SfcInstance 继承。)
公共方法静态成员 IsLoginUtilityReader Validates whether the login used in the connection has the utility reader role.
公共方法静态成员 IsUtilityControlPoint Determines whether the specified server is a utility control point (UCP).
受保护方法 OnPropertyMetadataChanges Invoked whenever the effective value of any SfcInstance metadata is updated. (从 SfcInstance 继承。)
受保护方法 OnPropertyValueChanges Invoked whenever the effective value of any SfcInstance property is updated. (从 SfcInstance 继承。)
公共方法 Refresh Refreshes the SQL Server Utility properties. (覆盖 SfcInstance.Refresh()。)
受保护方法 ResetKey 不要在您的代码中直接引用此成员。它支持 SQL Server 基础结构。 (从 SfcInstance 继承。)
公共方法 ScriptAlter Alters the properties of the base object if it has been changed.
公共方法 Serialize Serializes the instance to XML. (从 SfcInstance 继承。)
公共方法 ToString Returns a string representation of the instance Urn. (从 SfcInstance 继承。)

页首

事件

  名称 说明
公共事件 PropertyChanged CLS-compliant event for property changes. (从 SfcInstance 继承。)
公共事件 PropertyMetadataChanged CLS-compliant event for property metadata changes. (从 SfcInstance 继承。)

页首

显式接口实现

  名称 说明
显式接口实现私有方法 ISfcDomain.GetExecutionEngine Gets a new execution engine interface.
显式接口实现私有方法 ISfcDomain.GetKey Gets a new SfcKey object.
显式接口实现私有方法 ISfcDomain.GetType Gets the Type of the utility.
显式接口实现私有方法 ISfcDomain.GetTypeMetadata Gets the SfcTypeMetadata.
显式接口实现私有方法 ISfcDomain.UseSfcStateManagement Returns True.
显式接口实现私有方法 ISfcDomain2.GetUrnSkeletonsFromType Gets a list of string values that contain the URN skeletons.
显式接口实现私有属性 ISfcDomainLite.DomainInstanceName Gets the domain instance name.
显式接口实现私有属性 ISfcDomainLite.DomainName Gets the domain name.
显式接口实现私有方法 ISfcDomainLite.GetLogicalVersion Gets an integer value that specifies the logical version.
显式接口实现私有属性 ISfcHasConnection.ConnectionContext Gets the SfcConnectionContext.
显式接口实现私有方法 ISfcHasConnection.GetConnection() Gets the ISfcConnection.
显式接口实现私有方法 ISfcHasConnection.GetConnection(SfcObjectQueryMode) Gets the ISfcConnection.
显式接口实现私有方法 ISfcHasConnection.SetConnection Sets the ISfcConnection.

页首

注释

Remote instances of SQL Server, represented by ManagedInstance class instances, can be added to the SQL Server Utility's collection using the methods defined by the ManagedInstanceFactory class. After enrollment in the Utility, these instances are not fully managed until their utilization data and health states have been determined.

线程安全

此类型的任何公共 static(在 Visual Basic 中为 Shared) 成员都是线程安全的。不保证所有实例成员都是线程安全的。

请参阅

参考

Microsoft.SqlServer.Management.Utility 命名空间