Export (0) Print
Expand All

FragmentationOption Enumeration

 

Applies To: SQL Server 2016 Preview

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 Enumeration FragmentationOption

Member nameDescription
Detailed

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

Fast

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

Sampled

Value = 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.

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

Community Additions

Show:
© 2015 Microsoft