sql server (alternate): Giving Active Queries Priority -- sql server (alternate)

Giving Active Queries Priority

sfarkas NO[at]SPAM visa.com
5/31/2005 7:29:13 PM

sql server (alternate):

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.

Re: Giving Active Queries Priority

John Bell
6/1/2005 12:00:00 AM

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

[quoted text, click to view]