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