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 |
|
leimrod
Starting Member
4 Posts |
 Posted - 2008-07-17 : 07:23:51
|
| Ok, the company I work for are fairly small but they are looking into setting up a local SQL Server to handle reporting. They want to go with Microsoft for the Database server. Our database is currently around 10GB in size. I'm fairly new to this so I'm learning on my feet, but in regards to the OS and SQL DB, which version should I get? For a production environment which version of SQL 2005 do I need? I'm pretty certain I need the Standard Edition as we don't require support for large-scale databases or clustering. But which standard edition should I get? For a production environment to I get the 1 CPU license? Also for the OS I was going to go with MS Windows 2003 Server (standard), again there are versions that say "5 CAL" or "5 Clients"... which do I need for a live server?http://www.amazon.co.uk/microsoft-server-2003-standard-Software/s/qid=1216291976/ref=sr_nr_n_0?ie=UTF8&rs=600014&keywords=microsoft%20server%202003%20standard&bbn=599948&rnid=600014&rh=n%3A300435%2Ck%3Amicrosoft%20server%202003%20standard%2Cn%3A600014%2Cn%3A599948All help is greatly appreciated. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-07-17 : 16:28:42
|
| You need to tell us more about your environmnet. Will the customer be internal through an Intranet or external over the Internet? It makes a huge difference as far as license price.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
leimrod
Starting Member
4 Posts |
Posted - 2008-07-18 : 04:23:47
|
| It's going to be a live production (external) database server, serving a booking engine for a few websites. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-07-18 : 12:32:16
|
| You'll need to purchase CPU licenses then, one CPU license per physical CPU on the server. You do not need to purchase CALs or anything else when you use CPU licenses. They are the most expensive but required in external-facing sites where you can't count your users.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
leimrod
Starting Member
4 Posts |
Posted - 2008-07-18 : 18:44:05
|
| how does it work for the likes of a quad core? Do I need to buy 4 CPU licenses or just one? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-07-18 : 23:55:19
|
| You need to purchase 1 CPU license per socket, not per core. So if it's a dual CPU quad-core (8 virtual CPUs), then you need to purchase 2 CPUs.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
leimrod
Starting Member
4 Posts |
Posted - 2008-08-05 : 08:45:57
|
| Hi again, sorry for the bump. I need to nail down exactly what package I need. This server is basically going to handle database storage and reporting facilities for our live websites. I understand I need a CPU license but is there a version of Windows Server 2003 that comes bundled with SQL Server 2005 Standard Edition that can be used in a live production environment? So far I can see 3 possible versions: Windows Server 2003 Web EditionWindows Server 2003 R2 Datacenter EditionWindows Server 2003 R2 Which version should I go for? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
What OS and SQL edition should I buy?