General discussion
Thread display: Collapse - |
All Comments
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
SQL Server Standard and multiple CPUs
Correct if wrong:
1. SQL Server Standard can use up to 2 CPUs ONLY on a 2 way CPU server.
2. If true, does that mean that SQL Server Standard can only see/use 1 CPU on a server with more than 2 CPUs.
3. Does SQL Server setup include options to select which CPUs you wish to use?
4. If the Standard version will run on a 4 way CPU server and I can select which CPUs I use, can I run 2 separate instances / installations of SQL Server and have instance 1 use the first 2 CPUs and have the other instance use the other 2 CPUs?
5. Are any of these answers different if we have an OEM version ofSQL Server?
Notes:
The server in question is a DELL Power Edge 6650 (4 CPUs). I think it has 4G RAM.
We will run our SMS database and our user databases on the same server.
Our user databases are small (full data backup under 700MB) and the number of user connections is also very small.
We capture quite a bit with SMS (maybe 400 workstations), but mostly on off hours.
Unfortunately the server was purchased before any of these questions were asked.
Because we are so small, perhaps none of this matters, but I thought I would ask and see what you guys say.
Thanks in advance!
Marc