NT4 SQL7 Dell PowerEdge 4400 2 gig of ram

I have allowed SQL to use all resources needed. When executing a query however only one CPU is used at 100% with virtually no memory use and the other CPU carries no load. I installed SP3 for SQL Server and now (I think) both processors are used at 50% each. How can I get SQL to use more of the CPU’s available to speed up querys? It should be noted that both BAAN and SQL are on the same box.

Thanks for any and all help!

Jason

Unfortunately SQL Server does not parallelize query processing. Since each query is executed as a single thread, you will not see higher loads unless you can execute more queries through the Baan multiple bshell performance booster.

Are you running the combo driver? This will reduce context switching and will allow the processes to run faster without switching between the driver and the bshell.

-- Jim

I have never heard of a Baan multiple bshell performance booster or a combo driver. My issue seems to be quite serious do to performance of SQL. Could you point me in the right direction or do you have any information on these two items you mentioned? I am very interested in getting more information about them. Thank you very much for answering my post.
Jason

All information on combo mode can be found in solution 115988.

Perf. boosters can be found in sessions tcmcs059[78]m000.

Han

In SQL enterprise manger select properties on the server then on the processor tab there are options to select which processors sql can use, boost sql priorty on windows NT and specify how many processors should be used for parallel execution of queries.

Darren

Han: Thank you very much.