November 6, 2002 at 3:22 pm
Is there a way to limit the number of worker-processes/CPUs used in a stored proc, but only within that proc? I know that Sybase allows you to do this at the beginning of the proc like this: SET PARALLEL_DEGREE 1
Thanks.
-Dan
-Dan
November 6, 2002 at 3:58 pm
At the end of your query, you can add:
OPTION (MAXDOP number)
Where number is the number of parallel "threads" you want the query to use, i.e. the degrees of parallelism you want the query to use, but I don't know off-hand of anyway to set this for an entire procedure. Obviously, there is also the server-wide configuration setting that allows you to specify the maximum degree of parallelism.
Matthew Burr
Edited by - mdburr on 11/06/2002 4:01:14 PM
November 7, 2002 at 9:40 am
Thanks, that's exactly what I needed!
-Dan
-Dan
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply