Jaa


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

'Declaration
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 with Microsoft SQL Server 2005 only.
Fast Value = 1. Calculates statistics based on parent level pages only. This option is available with Microsoft SQL Server 2000 and SQL Server 2005.
Sampled Value = 2. Calculates statistics on samples of data. This option is available with Microsoft SQL Server 2005 only.

Remarks

The FragmentationOption class are served by the EnumFragmentation method and the GetFragOptionString method.

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

Microsoft.SqlServer.Management.Smo Namespace