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 - 2002-11-13 : 08:57:25
|
| Bobo writes "I installed the Sql Server 2000 enterprise edition (SP2) on the windows 2000 advanced server, and my pc server has 8 cpus then start to build the database. After i built the db, it works well. But if i changed the cpu numbers in the sql server db property from 8 cpus to 7, the sql server database works abnomal. This happened the same for me to change the drivers of some network adapter card, i can't understand why the sql server do this for the hardware change. Can anyone give me some advice?Thanks in advance." |
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2002-11-13 : 11:41:16
|
| What do you mean by "works abnormal"? Are your queries running slower? Are you getting incorrect results? What's going on? There could be issues with parallism when reducing the number of processors. Not sure about the affects of a NIC adapter. Hardware chances do have a direct impact on the performance of a SQL Server.Jeff BanschbachConsultant, MCDBA |
 |
|
|
boboe
Starting Member
1 Post |
Posted - 2002-11-14 : 03:30:46
|
| Works abnomal means that before i changed the CPU numbers the DB can hold 100% pressure,after i changed it can only hold 20% pressure. So i think the DB works on the bad state.Why the hardware chances have a direct impact on the performance of a SQL Server? Can it not be happend? |
|
|
|
|
|
|
Sql Server 2000 has some relationship with the drivers?