OSRunPriority Property
Microsoft SQL Server의 이후 버전에서는 이 기능이 제거됩니다. 새 개발 작업에서는 이 기능을 사용하지 않도록 하고, 현재 이 기능을 사용하는 응용 프로그램은 수정하십시오.
The OSRunPriority property controls execution thread scheduling for job steps executing operating system tasks.
구문
object.OSRunPriority [=value]
Parts
object
An expression that evaluates to an object in the Applies To list.value
A long integer that specifies an operating system task execution priority level as described in Settings.
Data Type
Long, enumerated
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetOSRunPriority(
SQLDMO_RUNPRIORITY_TYPE* pRetVal);
HRESULT SetOSRunPriority(
SQLDMO_RUNPRIORITY_TYPE NewValue);
Settings
Constant |
Value |
Description |
|---|---|---|
SQLDMORunPri_AboveNormal |
1 |
Slightly elevated priority. |
SQLDMORunPri_BelowNormal |
-1 |
Reduced priority. |
SQLDMORunPri_Highest |
2 |
Highest priority level allowed by the process priority. |
SQLDMORunPri_Idle |
-15 |
No CPU time is spent on this thread unless all other threads are blocked. |
SQLDMORunPri_Lowest |
-2 |
Lowest priority level allowed by the process priority. |
SQLDMORunPri_Normal |
0 |
Standard priority level. |
SQLDMORunPri_TimeCritical |
15 |
No CPU time is given to other processes while the job step executes. |
SQLDMORunPri_Unknown |
100 |
The value is not valid. |
주의
Set the OSRunPriority property to alter execution thread scheduling for job steps executing operating system commands. The property specifies a thread priority relative to that granted to an instance of Microsoft SQL Server.
.gif "주의 사항") 주의 |
|---|
Setting operating system thread priority can have adverse effects on other processes running on the server. Care should be taken when specifying priorities above normal. |