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