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)

type 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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft