Setting query priority options assigns query processing priorities by user.
Queries waiting in queue for processing are queued to run in order of the priority of the user who submitted the query, followed by the order in which the query was submitted. No queries are run from a lower priority queue until higher priority queries have all been executed.
IQGOVERN_PRIORITY – Assigns a numeric priority (1, 2, or 3, with 1 being the highest) to queries waiting in the processing queue.
IQGOVERN_MAX_PRIORITY – Allows users with the SET ANY SYSTEM OPTION system privilege to set an upper boundary on IQGOVERN_PRIORITY for a user or a role.
IQ_GOVERN_PRIORITY_TIME – Allows high priority users to start if a high priority (priority 1) query has been waiting in the -iqgovern queue for more than a designated amount of time.
To check the priority of a query, check the IQGovernPriority attribute returned by the sp_iqcontext stored procedure.