Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL 2000 Multi Processors
- Thread starter rr27
- Start date
By default the server automatically will use all available procs on the server. TO check or modify this you can in EM:
1)Right Click on the server name and select Properties
2)Go to the processor tab
If all processors listed are checked then they are all being used.
If for some reason others items run on the server and your gettig performance issues or the server is locking up you can unselct processors to be used. If you need to do this you should typically do it to proc 0 as this is the proc many windows processes have affinity for.
Shoot Me! Shoot Me NOW!!!
- Daffy Duck
1)Right Click on the server name and select Properties
2)Go to the processor tab
If all processors listed are checked then they are all being used.
If for some reason others items run on the server and your gettig performance issues or the server is locking up you can unselct processors to be used. If you need to do this you should typically do it to proc 0 as this is the proc many windows processes have affinity for.
Shoot Me! Shoot Me NOW!!!
- Daffy Duck
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
