Export (0) Print
Expand All
Expand Minimize

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)

public enum FragmentationOption

Member nameDescription
FastValue = 1. Calculates statistics based on parent level pages only. This option is available starting with SQL Server 2000.
SampledValue = 2. Calculates statistics based on samples of data. This option is available starting with SQL Server 2005.
DetailedValue = 3. Calculates statistics based on 100% of the data. This option is available starting with SQL Server 2005.

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

Community Additions

ADD
Show:
© 2014 Microsoft