FragmentationOption Enumeration
The FragmentationOption enumeration is a list of constant values that specify the levels of detail of collected fragmentation information.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
Syntax
'Bildirim
Public Enumeration FragmentationOption
public enum FragmentationOption
public enum class FragmentationOption
public enum FragmentationOption
public enum FragmentationOption
Members
Member name | Description |
---|---|
Detailed | Value = 3. Calculates statistics based on 100% of the data. This option is available starting with SQL Server 2005. |
Fast | Value = 1. Calculates statistics based on parent level pages only. This option is available starting with SQL Server 2000. |
Sampled | Value = 2. Calculates statistics based on samples of data. This option is available starting with SQL Server 2005. |
Remarks
The FragmentationOption class are served by the EnumFragmentation method and the GetFragOptionString method.
Platforms
Development Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.
Target Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.