Thanks for the reply..and sorry about the cross post...

Could you tell me a littel bit more in detail how I can set up thsi parallell execution (for example through SQL Agent jobs)...can I really simulate many "users" accessing/executing the query at exactelly the same time..will this setup not give a sequential execution..could you explain a little bit more ?

Also, if I do not want to involve any stored procedures...let's say I only have an extremelly simple query as an example, how could I implement these jobs without sp for this purpose.....

..and also, how can I monitor the execution more exactelly..let's say i manage to understand how to start 10 parallell executions of this same simple query..how can I practically verify how long the execution time of all queries to finsish is related to the number of simultaneous queries running.....

I have some thoughts that the execution time for - let's say 10 simultaneous executions will not take even close to 10 second, even though one execution in query analyzer takes 1 second...just want to verify in some way that my thought are correct and that 10 executions take like 20 seconds, and 20 executions perhaps a minute or so

Very greatful for some more guidence on this one....

Thanks

Helmut