Query execution priority

When you execute several long duration queries simultaneous on the SQL
server, is it then possible to give the execution of one query a higher or
lower priority than another query?Hi,
As far as I know no. The only priority that could be set deals with how the
query behave in case of deadlocking. see DEADLOCK_PRIORITY in BOL.
Lionel
"pehuan" wrote:
> When you execute several long duration queries simultaneous on the SQL
> server, is it then possible to give the execution of one query a higher or
> lower priority than another query?|||You can set the maximum degree of parallelism (the number of processors to
use) for a query on a multi processor machine, using OPTION (MAXDOP n). This
doesn't really set priority directly, but it gives you influence over the
amount of resources each query can use.
--
Jacco Schalkwijk
SQL Server MVP
"pehuan" <pehuan@.discussions.microsoft.com> wrote in message
news:29D00740-2821-4995-9312-11E3E5AA8207@.microsoft.com...
> When you execute several long duration queries simultaneous on the SQL
> server, is it then possible to give the execution of one query a higher or
> lower priority than another query?|||There is no need for priority on SQL Server worker threads because SQL
Server does not use preemptive multi-tasking; it uses the cooperative
multi-tasking of the Win 3.0 days. UMS contexts yield as required, unless,
of corse, there is some sort of error.
Sincerely,
Anthony Thomas
"pehuan" <pehuan@.discussions.microsoft.com> wrote in message
news:29D00740-2821-4995-9312-11E3E5AA8207@.microsoft.com...
When you execute several long duration queries simultaneous on the SQL
server, is it then possible to give the execution of one query a higher or
lower priority than another query?