Giving Active Queries Priority

Is there a way to give a particular query greater system resources,
such as share of the processor?

I have two queries that were started from Query Analyzer. One is very
long, the other rather short. However the long one is taking almost
all the processor resources and not allowing the short one to complete.
I'd like to allocate more of the processor to the short one until it
is done.

I am the admin on this system and have access to Enterprise Mgr.

Thanks.Hi

If you had multiple processors then you may want to look at the maxdop query
hint, or you may want to break your longer running query up so that other
activity can occur. You may also want to look at the query plan to see if
you can optimise the long running query or possibly re-architect the
database/system to remove the need for such intensive processing.

John

<sfarkas@.visa.com> wrote in message
news:1117592953.657773.238730@.o13g2000cwo.googlegr oups.com...
> Is there a way to give a particular query greater system resources,
> such as share of the processor?
> I have two queries that were started from Query Analyzer. One is very
> long, the other rather short. However the long one is taking almost
> all the processor resources and not allowing the short one to complete.
> I'd like to allocate more of the processor to the short one until it
> is done.
> I am the admin on this system and have access to Enterprise Mgr.
> Thanks.