Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Parallel Processing Problem

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-09-22 : 08:57:27
Daniel writes "
Config:
W2K Server (Service Pack 1 applied)
SQL Server 7.0 (Service Pack 2 applied)

I have several Dell Servers that came preconfigured with 733Mhz dual processors and I have databases with exactly the same structure and data on each of them. When I run my stored procedure on the first one I know that I am using the two processors in parallel by looking at the Performance Monitor. But on the other three servers I notice that the servers are not using the processors in parallel, but they are actually fighting for processor time (they appear symmetric in the monitor).

I've checked to make sure that SQL Server is configured to use all available processors, but I'm unable to find any differences between the configuration of the server that works and the three that don't.

Any suggestions...

Thanks so much for your help...

Daniel"
   

- Advertisement -