Skip to Content
0
Former Member
Apr 21, 2010 at 03:15 PM

Parallel query processing. (Max Processors)

102 Views

Hi Guys,

We have a System running on SQL 2000, and it configured to use all available processors.

(Server properties>Processor)

I am about to change it to use 1 processor as per microsoft recommendation, but there another option when you select fixed number of processor instead of all available processors, which is

"Minimum query plan threshold for considering queries for parallel execution(cost estimate)"

http://picasaweb.google.com/lh/photo/8N0-WQt3m23vEiupxdjtwQ?feat=directlink

can anybody suggest me, how do you estimate this number. or you guys can post what is current threshold value in your SQL 2000 server environment. (I dont see this option in SQL 2005,probably its handled automatically).

Thanks Guys