Programmatically set the priority of connecting to the database

Question

We have a C # application that opens several ODBC connections to various databases (mainly Oracle and SQL Server).

Is there a way to programmatically tell the database which connection gives the highest priority?

For example, if I have Con1, Con2, and Con3 all connected to the ODBC database, I want to be able to tell the database to consider Con2 as the highest priority compared to any other connections, so it will prioritize this working load.

Although I could set the priority of the C # thread, this will not work, because when the C # thread can work at the highest level, it will only work as fast as the basic database connection (if I make a mistake, and Priority C # stream passed through?).

Answer 1

I have not used it, but it looks like you can use Oracle Database Resource Manager to assign different priorities for different sessions.

, , . , .

SQL Server Resource Governor.

, Oracle SQL-, , . , , . , , - , , , , .