Compartilhar via


Classe 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.

Hierarquia de herança

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

Namespace:  Microsoft.SqlServer.Management.Utility
Assembly:  Microsoft.SqlServer.Management.Utility (em Microsoft.SqlServer.Management.Utility.dll)

Sintaxe

'Declaração
<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
'Uso
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

O tipo Utility expõe os membros a seguir.

Construtores

  Nome Descrição
Método público Utility() Initializes a new, default instance of the Utility class.
Método público Utility(SqlStoreConnection) Initializes a new instance of the Utility class with the specified connection to SqlStore.

Início

Propriedades

  Nome Descrição
Propriedade protegida AbstractIdentityKey Não referencie esse membro diretamente no código. Ele dá suporte à infraestrutura do SQL Server. (Herdado de SfcInstance.)
Propriedade pública Computers Gets the collection of computers running managed instances.
Propriedade pública CreatedBy Gets the authentication credentials for the user who created the Utility.
Propriedade pública DateCreated Gets the date and time when the SQL Server Utility was created.
Propriedade pública DeployedDacCount Gets the number of deployed DACs on the instances of SQL Server managed by the SQL Server Utility.
Propriedade pública DeployedDacHealthyCount Gets the number of healthy deployed DACs on the instances of SQL Server managed by the SQL Server Utility.
Propriedade pública DeployedDacManagementPendingCount Gets the number of deployed DAC instances that have a pending management status.
Propriedade pública DeployedDacOnOverutilizedComputerCount Gets the number of DACs that are deployed on managed instances run on overutilized computers.
Propriedade pública DeployedDacOnUnderutilizedComputerCount Gets the number of DACs that are deployed on managed instances run on underutilized computers.
Propriedade pública DeployedDacOverutilizedCount Gets the number of overutilized deployed DACs.
Propriedade pública DeployedDacs Gets the number of DACs that are deployed on managed instances.
Propriedade pública DeployedDacUnderutilizedCount Gets the number of deployed, underutilized DACs on all the managed instances.
Propriedade pública DeployedDacUnhealthyCount Gets the number of deployed unhealthy DACs on all the managed instances.
Propriedade pública DeployedDacWithFilesOnOverutilizedVolumeCount Gets the number of deployed DACs that have files on overutilized volumes.
Propriedade pública DeployedDacWithFilesOnUnderutilizedVolumeCount Gets the number of deployed DACs that have files on underutilized volumes.
Propriedade pública DeployedDacWithOverutilizedFileCount Gets the number of deployed DACs that have overutilized files.
Propriedade pública DeployedDacWithOverutilizedProcessorCount Gets the number of deployed DACs that operate over overutilized processors.
Propriedade pública DeployedDacWithUnderutilizedFileCount Gets the number of deployed DACs that have underutilized files.
Propriedade pública DeployedDacWithUnderutilizedProcessorCount Gets the number of deployed DACs that operate on underutilized processors.
Propriedade pública Description Gets or sets a String describing the UCP.
Propriedade pública ManagedInstanceCount Gets the number of instances of SQL Server managed by the UCP.
Propriedade pública ManagedInstanceHealthyCount Gets the number of healthy instances of SQL Server managed by the UCP.
Propriedade pública ManagedInstanceManagementPendingCount Gets the number of instances of SQL Server that have a pending management status.
Propriedade pública ManagedInstanceOnOverutilizedComputerCount Gets the number of managed instances of SQL Server that are running on overutilized computers.
Propriedade pública ManagedInstanceOnUnderutilizedComputerCount Gets the number of managed instances of SQL Server that are running on underutilized computers.
Propriedade pública ManagedInstanceOverutilizedCount Gets the number of overutilized managed instances of SQL Server.
Propriedade pública ManagedInstances Gets a collection containing each instance of SQL Server managed by this Utility.
Propriedade pública ManagedInstanceUnderutilizedCount Gets the number of managed instances of SQL Server that are underutilized.
Propriedade pública ManagedInstanceUnhealthyCount Gets the number of unhealthy managed instances of SQL Server.
Propriedade pública ManagedInstanceWithFilesOnOverutilizedVolumeCount Gets the number of managed instances of SQL Server that have files on overutilized volumes.
Propriedade pública ManagedInstanceWithFilesOnUnderutilizedVolumeCount Gets the number of managed instances of SQL Server that have files on underutilized volumes.
Propriedade pública ManagedInstanceWithOverutilizedFileCount Gets the number of managed instances of SQL Server that have overutilized files.
Propriedade pública ManagedInstanceWithOverutilizedProcessorCount Gets the number of managed instances of SQL Server that are executed on overutilized processors.
Propriedade pública ManagedInstanceWithUnderutilizedFileCount Gets the number of managed instances of SQL Server with underutilized files.
Propriedade pública ManagedInstanceWithUnderutilizedProcessorCount Gets the number of managed instances of SQL Server that are executed on underutilized processors.
Propriedade pública MdwDatabaseName Gets or sets the name of the utility management data warehouse (UMDW) database.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública Metadata Returns metadata about the instance and its domain. (Herdado de SfcInstance.)
Propriedade pública Name Gets the name of the connected SQL Store server.
Propriedade pública OverUtilizationOccurenceFrequency Gets or sets the occurrence frequency that is used to computer over-utilization health states over the specified trailing window.
Propriedade pública OverUtilizationTrailingWindow Gets or sets the trailing window, in hours, used to compute health states.
Propriedade pública Parent Gets or sets the instance parent via the keychain. (Herdado de SfcInstance.)
Propriedade pública PolicyStore Gets the PolicyStore object that defines the policies of the SQL Store connection.
Propriedade pública Properties Returns a collection instance properties. (Herdado de SfcInstance.)
Propriedade pública SqlStoreConnection Gets or sets the SQL Store connection
Propriedade protegida State Returns the state of the SfcInstance object. (Herdado de SfcInstance.)
Propriedade pública TotalStorageCapacity Gets the storage capacity of the Utility.
Propriedade pública TotalStorageUtilization Gets the amount of SQL Server Utility storage that is currently used.
Propriedade pública UnderUtilizationOccurenceFrequency Gets or sets the occurrence frequency that is used to computer underutilization health states over the specified trailing window.
Propriedade pública UnderUtilizationTrailingWindow Gets or sets the trailing window, in hours, used to compute health states.
Propriedade pública Urn Returns the uniform resource name of the SfcInstance object. (Herdado de SfcInstance.)
Propriedade pública UtilityName Gets the name of the utility control point (UCP).

Início

Métodos

  Nome Descrição
Método público Alter Updates any Utility property changes on the instance of SQL Server.
Método públicoMembro estático Connect Returns a SqlStoreConnection object specified by connection.
Método protegido CreateIdentityKey Não referencie esse membro diretamente no código. Ele dá suporte à infraestrutura do SQL Server. (Herdado de SfcInstance.)
Método públicoMembro estático CreateUtility(String, SqlStoreConnection) Creates a Utility object.
Método públicoMembro estático CreateUtility(String, SqlStoreConnection, String, SqlSecureString) Creates a Utility object.
Método público Discover Não referencie esse membro diretamente no código. Ele dá suporte à infraestrutura do SQL Server. (Herdado de SfcInstance.)
Método público EnrollInstance(SqlStoreConnection) Enrolls a Utility object with the connection supplied by sqlStoreConnection parameter.
Método público EnrollInstance(SqlStoreConnection, String, SqlSecureString) Enrolls a Utility object with the connection supplied by sqlStoreConnection parameter.
Método público Equals (Herdado de Object.)
Método protegido GetChildCollection Não referencie esse membro diretamente no código. Ele dá suporte à infraestrutura do SQL Server. (Herdado de SfcInstance.)
Método público GetDomain Não referencie esse membro diretamente no código. Ele dá suporte à infraestrutura do SQL Server. (Herdado de SfcInstance.)
Método público GetHashCode (Herdado de Object.)
Método público GetPropertySet Returns the set of properties for the SfcInstance object. (Herdado de SfcInstance.)
Método público GetType (Herdado de Object.)
Método protegido GetTypeMetadataImpl Indicates the domains that override by returning the right TypeMetadata class directly. Não referencie esse membro diretamente no código. Ele dá suporte à infraestrutura do SQL Server. (Herdado de SfcInstance.)
Método protegido InitializeUIPropertyState Não referencie esse membro diretamente no código. Ele dá suporte à infraestrutura do SQL Server. (Herdado de SfcInstance.)
Método públicoMembro estático IsLoginUtilityReader Validates whether the login used in the connection has the utility reader role.
Método públicoMembro estático IsUtilityControlPoint Determines whether the specified server is a utility control point (UCP).
Método protegido OnPropertyMetadataChanges Invoked whenever the effective value of any SfcInstance metadata is updated. (Herdado de SfcInstance.)
Método protegido OnPropertyValueChanges Invoked whenever the effective value of any SfcInstance property is updated. (Herdado de SfcInstance.)
Método público Refresh Refreshes the SQL Server Utility properties. (Substitui SfcInstance.Refresh().)
Método protegido ResetKey Não referencie esse membro diretamente no código. Ele dá suporte à infraestrutura do SQL Server. (Herdado de SfcInstance.)
Método público ScriptAlter Alters the properties of the base object if it has been changed.
Método público Serialize Serializes the instance to XML. (Herdado de SfcInstance.)
Método público ToString Returns a string representation of the instance Urn. (Herdado de SfcInstance.)

Início

Eventos

  Nome Descrição
Evento público PropertyChanged CLS-compliant event for property changes. (Herdado de SfcInstance.)
Evento público PropertyMetadataChanged CLS-compliant event for property metadata changes. (Herdado de SfcInstance.)

Início

Implementações de interfaces explícitas

  Nome Descrição
Implementações de interfaces explícitasMétodo privado ISfcDomain.GetExecutionEngine Gets a new execution engine interface.
Implementações de interfaces explícitasMétodo privado ISfcDomain.GetKey Gets a new SfcKey object.
Implementações de interfaces explícitasMétodo privado ISfcDomain.GetType Gets the Type of the utility.
Implementações de interfaces explícitasMétodo privado ISfcDomain.GetTypeMetadata Gets the SfcTypeMetadata.
Implementações de interfaces explícitasMétodo privado ISfcDomain.UseSfcStateManagement Returns True.
Implementações de interfaces explícitasMétodo privado ISfcDomain2.GetUrnSkeletonsFromType Gets a list of string values that contain the URN skeletons.
Implementações de interfaces explícitasPropriedade privada ISfcDomainLite.DomainInstanceName Gets the domain instance name.
Implementações de interfaces explícitasPropriedade privada ISfcDomainLite.DomainName Gets the domain name.
Implementações de interfaces explícitasMétodo privado ISfcDomainLite.GetLogicalVersion Gets an integer value that specifies the logical version.
Implementações de interfaces explícitasPropriedade privada ISfcHasConnection.ConnectionContext Gets the SfcConnectionContext.
Implementações de interfaces explícitasMétodo privado ISfcHasConnection.GetConnection() Gets the ISfcConnection.
Implementações de interfaces explícitasMétodo privado ISfcHasConnection.GetConnection(SfcObjectQueryMode) Gets the ISfcConnection.
Implementações de interfaces explícitasMétodo privado ISfcHasConnection.SetConnection Sets the ISfcConnection.

Início

Comentários

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.

Segurança de thread

Qualquer membro público static (Shared no Visual Basic) desse tipo é seguro para threads. Não há garantia de que qualquer membro de instância seja seguro para threads.

Consulte também

Referência

Namespace Microsoft.SqlServer.Management.Utility