FragmentationOption FragmentationOption FragmentationOption Enum

Definition

The FragmentationOption enumeration is a list of constant values that specify the levels of detail of collected fragmentation information.

public enum class FragmentationOption
public enum FragmentationOption
Public Enum FragmentationOption
Inheritance
FragmentationOptionFragmentationOptionFragmentationOption

Fields

Detailed Detailed Detailed 3

Value = 3. Calculates statistics based on 100% of the data. This option is available starting with SQL Server 2005.

Fast Fast Fast 1

Value = 1. Calculates statistics based on parent level pages only.

Sampled Sampled Sampled 2

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.

Applies to