Compartir a través de

  • Artículo

Enumeración DTSPriorityClass

Describes the priority of a thread in a class.

Espacio de nombres:  Microsoft.SqlServer.Dts.Runtime
Ensamblado:  Microsoft.SqlServer.ManagedDTS (en Microsoft.SqlServer.ManagedDTS.dll)

Sintaxis

'Declaración
Public Enumeration DTSPriorityClass
'Uso
Dim instance As DTSPriorityClass

public enum DTSPriorityClass

public enum class DTSPriorityClass

type DTSPriorityClass

public enum DTSPriorityClass

Miembros

Nombre del miembro Descripción
Default The thread is scheduled before threads with any other priority. This is the highest thread priority.
AboveNormal The thread is scheduled after threads with Default priority and before those with Normal priority.
Normal The thread is scheduled after threads with Default and AboveNormal priority, and before those with BelowNormal and Lowest priority.
BelowNormal The thread is scheduled after threads with Default, AboveNormal, and Normal priority and before those with Lowest priority.
Idle This thread is scheduled after threads with any other priority.

Comentarios

The DTSPriorityClass defines the set of all possible values for a thread priority. Thread priorities specify the relative priority of one thread versus another.

Every thread has an assigned priority. Threads created within the runtime are initially assigned the Default priority, while threads created outside the runtime retain their previous priority when they enter the runtime. You can get and set the priority of a thread by accessing its Priority property, such as the PackagePriorityClass.

Threads are scheduled for execution based on their priority. The scheduling algorithm used to determine the order of thread execution varies with each operating system.

The priority of threads for this enumeration, in order of highest priority to lowest, is as follows:

  • Default

  • AboveNormal

  • Normal

  • BelowNormal

  • Idle

Ejemplos

The following example shows the syntax to use when setting the PackagePriorityClass for a package using the DTSPriorityClass enumeration.

Package p = new Package();
p.PackagePriorityClass = DTSPriorityClass.BelowNormal;

Dim p As Package =  New Package() 
p.PackagePriorityClass = DTSPriorityClass.BelowNormal