yes... good post however;

say you have the usual multi-threaded cpu's in an 8 - 12 cpu environment...

would it be worth adjusting?

i too have the automatic setting; and i'm not getting...

is no problem... turns out the Parallelism Operator innitiates

the Distribute Streams Operator which in turns runs the threads

(steams) against the various CPU's available.

still checking this out... i'll post any results.

question is what exact operator would i be looking for...

ie; Distribute Streams or Parallelism

i was thinking out loud...

not really a duplicate question... and figure

i would mention why i was looking.

there must be a way...

i want to track Hyper Threaded queries and get see

those transactions so i know which ones to set the

MAXDOP hint on.

so no chance to query this information from

system tables or other wise?

nuts!

i'm not saying it's no good; just that i encountered some bugs with it.

can you post your workable version?? that would be great!

thanks!

i gotcha... thanks.

checking this out now actually... thanks

Sweet! If that works I'll be golden!

Thanks!

excellent feed back! thanks to all for this

lisa,

you are totally correct. unfortunately it is my inexperience

which through you off.

from what you just described things are more clear to me now.

thanks for all your help. this has...

Right. I got this before and both work properly.

The problem is how does one script the if/then into it?

yeah... i did create a master job for jobs 1 - 20, and

for various reasons it just wasn't feasable.

so i decided to go with a (Safety Job) which checked...

thats it exactly!

thoughts?