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
<PhysicalFacetAttribute> _
<LocalizedPropertyResourcesAttribute("Microsoft.SqlServer.Management.Utility.FacetSR",  _
    True)> _
<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)> _
<TypeConverterAttribute(GetType(LocalizableTypeConverter))> _
Public NotInheritable Class Utility _
    Inherits SfcInstance _
    Implements ISfcDomain2, ISfcDomain, ISfcDomainLite, ISfcHasConnection,  _
    ISfcAlterable, IAlterable
'Uso
Dim instance As Utility

[PhysicalFacetAttribute]
[LocalizedPropertyResourcesAttribute("Microsoft.SqlServer.Management.Utility.FacetSR", 
    true)]
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)]
[TypeConverterAttribute(typeof(LocalizableTypeConverter))]
public sealed class Utility : SfcInstance, 
    ISfcDomain2, ISfcDomain, ISfcDomainLite, ISfcHasConnection, ISfcAlterable, 
    IAlterable

[PhysicalFacetAttribute]
[LocalizedPropertyResourcesAttribute(L"Microsoft.SqlServer.Management.Utility.FacetSR", 
    true)]
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode::CheckOnSchedule)]
[TypeConverterAttribute(typeof(LocalizableTypeConverter))]
public ref class Utility sealed : public SfcInstance, 
    ISfcDomain2, ISfcDomain, ISfcDomainLite, ISfcHasConnection, ISfcAlterable, 
    IAlterable

[<SealedAttribute>]
[<PhysicalFacetAttribute>]
[<LocalizedPropertyResourcesAttribute("Microsoft.SqlServer.Management.Utility.FacetSR", 
    true)>]
[<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)>]
[<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
	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.

Início

Propriedades

	Nome	Descrição
	AbstractIdentityKey	Não referencie esse membro diretamente no código. Ele dá suporte à infraestrutura do SQL Server. (Herdado de 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. (Herdado de 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. (Herdado de SfcInstance.)
	PolicyStore	Gets the PolicyStore object that defines the policies of the SQL Store connection.
	Properties	Returns a collection instance properties. (Herdado de SfcInstance.)
	PropertyStorageProvider	Não referencie esse membro diretamente no código. Ele dá suporte à infraestrutura do SQL Server. (Herdado de SfcInstance.)
	SqlStoreConnection	Gets or sets the SQL Store connection
	State	Returns the state of the SfcInstance object. (Herdado de 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. (Herdado de SfcInstance.)
	UtilityName	Gets the name of the utility control point (UCP).

Início

Métodos

	Nome	Descrição
	Alter	Updates any Utility property changes on the instance of SQL Server.
	AlterImpl	Não referencie esse membro diretamente no código. Ele dá suporte à infraestrutura do SQL Server. (Herdado de SfcInstance.)
	CheckObjectCreated	Não referencie esse membro diretamente no código. Ele dá suporte à infraestrutura do SQL Server. (Herdado de SfcInstance.)
	CheckObjectState	Não referencie esse membro diretamente no código. Ele dá suporte à infraestrutura do SQL Server. (Herdado de SfcInstance.)
	Connect	Returns a SqlStoreConnection object specified by connection.
	CreateIdentityKey	Não referencie esse membro diretamente no código. Ele dá suporte à infraestrutura do SQL Server. (Herdado de SfcInstance.)
	CreateImpl	Não referencie esse membro diretamente no código. Ele dá suporte à infraestrutura do SQL Server. (Herdado de SfcInstance.)
	CreateUtility(String, SqlStoreConnection)	Creates a Utility object.
	CreateUtility(String, SqlStoreConnection, String, SqlSecureString)	Creates a Utility object.
	Discover	Não referencie esse membro diretamente no código. Ele dá suporte à infraestrutura do SQL Server. (Herdado de SfcInstance.)
	DropImpl	Não referencie esse membro diretamente no código. Ele dá suporte à infraestrutura do SQL Server. (Herdado de 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	(Herdado de Object.)
	Finalize	(Herdado de Object.)
	GetChildCollection	Não referencie esse membro diretamente no código. Ele dá suporte à infraestrutura do SQL Server. (Herdado de SfcInstance.)
	GetDomain	Não referencie esse membro diretamente no código. Ele dá suporte à infraestrutura do SQL Server. (Herdado de SfcInstance.)
	GetHashCode	(Herdado de Object.)
	GetPropertySet	Returns the set of properties for the SfcInstance object. (Herdado de SfcInstance.)
	GetType	(Herdado de Object.)
	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.)
	InitializeUIPropertyState	Não referencie esse membro diretamente no código. Ele dá suporte à infraestrutura do SQL Server. (Herdado de 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).
	MarkForDropImpl	Returns a value that indicates the existing objects to be dropped. Não referencie esse membro diretamente no código. Ele dá suporte à infraestrutura do SQL Server. (Herdado de SfcInstance.)
	MarkRootAsConnected	Não referencie esse membro diretamente no código. Ele dá suporte à infraestrutura do SQL Server. (Herdado de SfcInstance.)
	MemberwiseClone	(Herdado de Object.)
	MoveImpl	Indicates the new parent object to move in an instance. Não referencie esse membro diretamente no código. Ele dá suporte à infraestrutura do SQL Server. (Herdado de SfcInstance.)
	OnPropertyMetadataChanges	Invoked whenever the effective value of any SfcInstance metadata is updated. (Herdado de SfcInstance.)
	OnPropertyValueChanges	Invoked whenever the effective value of any SfcInstance property is updated. (Herdado de SfcInstance.)
	PostAlter	Não referencie esse membro diretamente no código. Ele dá suporte à infraestrutura do SQL Server. (Herdado de SfcInstance.)
	PostCreate	Indicates the default implementor that creates the execution result. Não referencie esse membro diretamente no código. Ele dá suporte à infraestrutura do SQL Server. (Herdado de SfcInstance.)
	PostDrop	Não referencie esse membro diretamente no código. Ele dá suporte à infraestrutura do SQL Server. (Herdado de SfcInstance.)
	PostMove	Não referencie esse membro diretamente no código. Ele dá suporte à infraestrutura do SQL Server. (Herdado de SfcInstance.)
	PostRename	Não referencie esse membro diretamente no código. Ele dá suporte à infraestrutura do SQL Server. (Herdado de SfcInstance.)
	Refresh	Refreshes the SQL Server Utility properties. (Substitui SfcInstance. . :: . .Refresh() () () ().)
	RenameImpl	Não referencie esse membro diretamente no código. Ele dá suporte à infraestrutura do SQL Server. (Herdado de SfcInstance.)
	ResetKey	Não referencie esse membro diretamente no código. Ele dá suporte à infraestrutura do SQL Server. (Herdado de SfcInstance.)
	ScriptAlter	Alters the properties of the base object if it has been changed.
	Serialize	Serializes the instance to XML. (Herdado de SfcInstance.)
	ToString	Returns a string representation of the instance Urn. (Herdado de SfcInstance.)
	UpdateUIPropertyState	Não referencie esse membro diretamente no código. Ele dá suporte à infraestrutura do SQL Server. (Herdado de SfcInstance.)
	Validate	Indicates the basic child object's validation. Não referencie esse membro diretamente no código. Ele dá suporte à infraestrutura do SQL Server. (Herdado de SfcInstance.)

Início

Eventos

	Nome	Descrição
	propertyChanged	Não referencie esse membro diretamente no código. Ele dá suporte à infraestrutura do SQL Server. (Herdado de SfcInstance.)
	PropertyChanged	CLS-compliant event for property changes. (Herdado de SfcInstance.)
	propertyMetadataChanged	Não referencie esse membro diretamente no código. Ele dá suporte à infraestrutura do SQL Server. (Herdado de SfcInstance.)
	PropertyMetadataChanged	CLS-compliant event for property metadata changes. (Herdado de SfcInstance.)

Início

Implementações de interfaces explícitas

	Nome	Descrição
	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.

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