Énumération FragmentationOption

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

Espace de noms :  Microsoft.SqlServer.Management.Smo
Assembly :  Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)

Syntaxe

'Déclaration
Public Enumeration FragmentationOption
'Utilisation
Dim instance As FragmentationOption
public enum FragmentationOption
public enum class FragmentationOption
type FragmentationOption
public enum FragmentationOption

Membres

Nom de membre Description
Fast Value = 1. Calculates statistics based on parent level pages only. This option is available starting with SQL Server 2000.
Sampled Value = 2. Calculates statistics based on samples of data. This option is available starting with SQL Server 2005.
Detailed Value = 3. Calculates statistics based on 100% of the data. This option is available starting with SQL Server 2005.

Notes

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