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 |
|
galland1928
Starting Member
3 Posts |
 Posted - 2006-08-30 : 13:57:47
|
| We have a Quad CPU (dual core 3.16Ghz Xeons) SQL server running SQL 2000 Enterprise version.Initially we had it set up as per CPU licensing, (temp license using only 2 CPU's). We were nearing our go live date, and wanted to use all the CPU's so we purchased CAL's instead and went that route. We didn't change anything on the server, and it still says it is licensed per CPU.Since we couldn't change the licensing mode and didn't have enough time to rebuild the server (before go live date) we just went to the SQL licensing and upped the number of CPU licences to 8.The server never seems to use all the CPU's at once, which makes it seems slow at times. Is there a way to confirm that it is set up correctly and that all CPU's can work simultanously? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-30 : 14:12:43
|
| Are your customers accessing your application via a web site? Are they external customers?Tara Kizer |
 |
|
|
galland1928
Starting Member
3 Posts |
Posted - 2006-08-30 : 16:40:09
|
| They are accessing it via Navision and it's all internal at this point. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-30 : 18:26:38
|
| If it'll ever be external, then you have to purchase CPU licenses for all of the CPUs that you want to use. CALs can't be used for external web access.To check your CPU configuration, right click on the server in Enterprise Manager, go to Properties. Click on the Processor tab.Tara Kizer |
|
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2006-08-30 : 21:30:55
|
| As for the license, if you got a Quad CPU, you will only need 4 processor licenses, as its counting physical CPU, not how many "core" it has, so you should only need 4 rather then 8. Correct me if I'm wrong :) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-31 : 12:40:48
|
| Yes 4 for his server since he has 4 physical CPUs. Hyper-threading and dual-core don't matter for licensing.Tara Kizer |
|
|
|
galland1928
Starting Member
3 Posts |
Posted - 2006-09-01 : 09:25:56
|
| Alright, I will have to change that down to 4 CPU's in the configuration.That brings me back to my original question, does it matter for speed or symmetry if you go from per CPU (with only 1 license installed) and then bump it up without installing any licenses?Does the licensing interfere with CPU's or speed at all when you compare per CPU or CAL's licensing? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-09-01 : 11:51:09
|
| You don't need to bring it down to 4. SQL Server and the OS will see the 8 if you are using hyper threading. You keep it at 8 in the config and only purchase 4 licenses.The licensing does not interfere with anything when you compare per CPU or CALs.I don't have the answer to your other question. You may want to check with the person you purchased the licenses from. He/she should be able to get you in contact with someone who can answer this.Tara Kizer |
|
|
|
|
|
|
|
|
SQL Server 2000 Ent config