問題描述
我在 Windows 7 64 位機器上運行 sql server 2008.
I am running sql server 2008 on a windows 7 64 bit machine.
我正在與另一個會話 ID 同時運行查詢，我想降低另一個會話 ID 的優先級，因為我的進程更關鍵.
I am running a query at the same time as another session ID, and I would like to lower the priority of the other session ID because my process is more critical.
另一個進程是一個正在運行的 SSIS 包.
The other process is an SSIS package that is running.
是否有可能在作業運行時更改進程的優先級?
Is it at all possible to change the priority of the processes while the jobs are running?
是否可以更改特定用戶 ID 的優先級?
Is it possible to change the priority of a specific USER ID?
推薦答案
如果您使用的是具有企業版引擎(企業版、企業評估版或開發者版)的 SQL Server 版本，則可以使用 資源調控器，基于用戶定義的函數，可以包括服務器登錄.請查看鏈接以了解這是否是合適的解決方案.
If you're using an edition of SQL Server that has the Enterprise Edition engine (Enterprise Edition, Enterprise Evaluation Edition, or Developer Edition), you can use Resource Governor to manage resources based on a user-defined function that can include the server login. Please see the link to find out if this is an appropriate solution.
但是，無法更改正在運行的進程的優先級——必須在連接進入之前配置資源調控器.
It is not possible, however, to change a running process' priority -- Resource Governor has to be configured before the connection comes in.
這篇關于如何更改連接到我的服務器的會話 ID 的優先級?的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！