SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Provisioning a new server and keeping SQL Server 2012 pricing in mind.


Provisioning a new server and keeping SQL Server 2012 pricing in mind.

Author
Message
Rod
Rod
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2808 Visits: 2068
I work for a small department at a university. I'm looking at provisioning a new server to move from SQL Server 2005, to SQL Server 2012. Then university has an agreement with Dell, so it will be a Dell server (we've had good luck with them, so that's not a problem from my point of view).

The question I'm having is that I'm wondering about how to configure the Windows server, in order to help keep the cost of SQL Server 2012 down? We'll probably go with SQL Server 2012 Standard Edition, as I don't think we'll need features of the Enterprise Edition (I wish we could, but oh well). I remember hearing a Run As Radio podcast in which Richard Campbell was talking about provisioning a server for SQL 2012, and I think there a way of keeping the cost down, either by how many processors you have in it, or something like that. I've heard that Microsoft has changed the cost structure with the introduction of SQL Server 2012, so I'd like some advise along these lines, please.

Kindest Regards,Rod
Connect with me on LinkedIn.
SQLArcher
SQLArcher
SSC-Enthusiastic
SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)

Group: General Forum Members
Points: 190 Visits: 3166
In terms of the licensing to get a better understanding I suggest that you look at the following:

http://download.microsoft.com/download/7/3/C/73CAD4E0-D0B5-4BE5-AB49-D5B886A5AE00/SQL_Server_2012_Licensing_Reference_Guide.pdf

However, it is always best to speak with your Microsoft representative as well as the reseller who provides your company with licenses.
anthony.green
anthony.green
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10180 Visits: 6378
SQLArcher (2/12/2013)
In terms of the licensing to get a better understanding I suggest that you look at the following:

http://download.microsoft.com/download/7/3/C/73CAD4E0-D0B5-4BE5-AB49-D5B886A5AE00/SQL_Server_2012_Licensing_Reference_Guide.pdf

However, it is always best to speak with your Microsoft representative as well as the reseller who provides your company with licenses.


+1 to that. Always speak to your reseller or MS directly as they make the rule, they can change the rules without telling anyone.

2012 changed to Core based instead of processor based licensing. So you need to take into account what CPU's you purchase and how many cores each one has. There is a minimum 4 core purchase per CPU, so if you have 2 Dual core chips, (4 cores in total) you need to purchase 8 core licenses.

Once you have purchased the minimum 4 cores per CPU, you can then purchase 2 core packs to top up. So a Hex core chip would be the minimum 4 + 2 additional, again its per chip.

Attached the licensing guide SQLArcher linked to and a white paper on upgrading to 2012.



Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
When a question, really isn't a question - Jeff Smith
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger


Rod
Rod
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2808 Visits: 2068
Thank you, SQLArcher, for the link.

Kindest Regards,Rod
Connect with me on LinkedIn.
Rod
Rod
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2808 Visits: 2068
Anthony, we've been haggling (?sp) over the server and pricing for a while. I wanted to get a server with duel cores, but it just wasn't in the budget, so we've gotten a single core server.

Kindest Regards,Rod
Connect with me on LinkedIn.
anthony.green
anthony.green
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10180 Visits: 6378
You mean 1 CPU not 1 Core?

So 1 CPU with how many cores?



Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
When a question, really isn't a question - Jeff Smith
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger


Rod
Rod
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2808 Visits: 2068
anthony.green (2/13/2013)
You mean 1 CPU not 1 Core?

So 1 CPU with how many cores?


Sorry, yes, I mean 1 CPU. I'll have to look at the specs before I can answer how many cores; I've no idea at this point.

Kindest Regards,Rod
Connect with me on LinkedIn.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search