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 |
|
DeepSeed
Yak Posting Veteran
52 Posts |
 Posted - 2010-01-08 : 11:12:12
|
| Hello,I have 5 logins with 5 databases on a SQL server. I also have 5 CPUs. I need to make sure each user can only make calculations on one of the CPUs as they commonly max out the cycles and if they max out all 5 CPUS the other users will attempt to log in and be denied.I understand soft numa is the way to do this, however I can't seem to find a good article, they all seem to be refering to memory and not CPUs. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
|
|
DeepSeed
Yak Posting Veteran
52 Posts |
Posted - 2010-01-08 : 13:01:29
|
| I looked into Resource Governor, it doesn't come with any SQL Server licenses except Enterprise Edition, which should be called bend over edition. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
soft numa configuration