Re: MS SQL 7.0 HANGS

From: Roy Harvey <roy_harvey_at_snet.net>
Date: Tue, 29 Jun 1999 16:34:39 GMT
Message-ID: <3778f542.83468891@msnews.microsoft.com>

roy_harvey_at_snet.net (Roy Harvey) wrote:

>So, if boost priority was off all along what else can you do? You
>actually have the ability to limit the maximum degree of parallelism
>of any single SQL query. If you have a quad processor machine, and
>can't live with a single query using four processors, you should get
>relief by setting the maximum parallelism to three. See the Processor
>tab of Properties again.

I missed that the max degree of parallelism can even be set for the individual query. See the SELECT documentation under "OPTION (MAXDOP)". Roy Received on Tue Jun 29 1999 - 11:34:39 CDT