Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
FragmentationOption Enumeration
Collapse the table of content
Expand the table of content

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
DetailedValue = 3. Calculates statistics based on 100% of the data. This option is available starting with SQL Server 2005.
FastValue = 1. Calculates statistics based on parent level pages only.
SampledValue = 2. Calculates statistics based on samples of 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:
© 2015 Microsoft