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.
| 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" |
|
|
|
|
|