Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Defines methods and properties that can be used to measure and influence database performance.
This API is not CLS-compliant.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)> _
<LocalizedPropertyResourcesAttribute("Microsoft.SqlServer.Management.Smo.LocalizableResources")> _
<DisplayDescriptionKeyAttribute("IDatabasePerformanceFacet_Desc")> _
<CLSCompliantAttribute(False)> _
<TypeConverterAttribute(GetType(LocalizableTypeConverter))> _
<DisplayNameKeyAttribute("IDatabasePerformanceFacet_Name")> _
Public Interface IDatabasePerformanceFacet _
Inherits IDmfFacet
'Usage
Dim instance As IDatabasePerformanceFacet
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)]
[LocalizedPropertyResourcesAttribute("Microsoft.SqlServer.Management.Smo.LocalizableResources")]
[DisplayDescriptionKeyAttribute("IDatabasePerformanceFacet_Desc")]
[CLSCompliantAttribute(false)]
[TypeConverterAttribute(typeof(LocalizableTypeConverter))]
[DisplayNameKeyAttribute("IDatabasePerformanceFacet_Name")]
public interface IDatabasePerformanceFacet : IDmfFacet
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode::CheckOnSchedule)]
[LocalizedPropertyResourcesAttribute(L"Microsoft.SqlServer.Management.Smo.LocalizableResources")]
[DisplayDescriptionKeyAttribute(L"IDatabasePerformanceFacet_Desc")]
[CLSCompliantAttribute(false)]
[TypeConverterAttribute(typeof(LocalizableTypeConverter))]
[DisplayNameKeyAttribute(L"IDatabasePerformanceFacet_Name")]
public interface class IDatabasePerformanceFacet : IDmfFacet
[<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)>]
[<LocalizedPropertyResourcesAttribute("Microsoft.SqlServer.Management.Smo.LocalizableResources")>]
[<DisplayDescriptionKeyAttribute("IDatabasePerformanceFacet_Desc")>]
[<CLSCompliantAttribute(false)>]
[<TypeConverterAttribute(typeof(LocalizableTypeConverter))>]
[<DisplayNameKeyAttribute("IDatabasePerformanceFacet_Name")>]
type IDatabasePerformanceFacet =
interface
interface IDmfFacet
end
public interface IDatabasePerformanceFacet extends IDmfFacet
The IDatabasePerformanceFacet type exposes the following members.
Properties
Name | Description | |
---|---|---|
![]() |
AutoClose | Gets or sets a value that indicates whether the database will be closed automatically after the last user exits. |
![]() |
AutoShrink | Indicates whether the database files are candidates for periodic shrinking. |
![]() |
CollationMatchesModelOrMaster | Gets a value that indicates whether the collation of the database matches the master or model database. |
![]() |
DataAndLogFilesOnSeparateLogicalVolumes | Indicates whether the database has its data and log files on different logical volumes. |
![]() |
IsSystemObject | Indicates whether the database performance facet is a system object. |
![]() |
Size | Gets the size of the database in megabytes (MB). |
![]() |
Status | Gets the database status. |
Top