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 - 2005-02-03 : 08:21:37
|
| Pete writes "Hi Sqlteam,We have a windows 2000 server,sql server 2000 sp3,just installed on multiple cpu server.But when we check the performance of the server,it just use one of 4 cpus to 100%, the other 3 cpus are idle.Is there any configuration we need to do to make all 4 CPUs to work?It will help us a lot to reduce the complains from our customers.ThanksPete" |
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2005-02-03 : 08:55:27
|
| You need to use affinity mask.To configure the affinity mask:Right-click the server and go for properties.Click the Processor tab and under Processor control, select one or more processors to create your affinity mask.Kind regards.Franco |
 |
|
|
|
|
|
How to use multipule cpu?