Viewing 4 posts - 1 through 4 (of 4 total)
Hi,
If it is possible in your production environment to dynamically change number of processors, then it is OK. In our environment it is more conservative, therefore I am looking for...
February 8, 2008 at 11:14 am
Replay for Jeff,
Server was setup to use 2 CPU for parallelism and query execution plan showed parallel execution was used in sorting index. See attached pictures.
Sincerely,
Radovan Jablonovsky
February 7, 2008 at 1:39 pm
Andy is right. We have setup MSSQL2000 (4 CPU) with parallel query execution and your example/code does not work. I tried it 3 times but always with messy results.
Example...
February 6, 2008 at 1:55 pm
Andy is right. We have setup MSSQL2000 (4 CPU) with parallel query execution and your example/code does not work. I tried it 3 times but always with messy results.
Example...
February 6, 2008 at 1:55 pm
Viewing 4 posts - 1 through 4 (of 4 total)