Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2012
»
SQL 2012 - General
»
Provisioning a new server and keeping SQL...
Provisioning a new server and keeping SQL Server 2012 pricing in mind.
Rate Topic
Display Mode
Topic Options
Author
Message
Rod at work
Rod at work
Posted Wednesday, February 06, 2013 2:08 PM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Today @ 8:25 AM
Points: 573,
Visits: 1,010
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
Post #1416727
SQLArcher
SQLArcher
Posted Tuesday, February 12, 2013 10:31 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, May 07, 2013 3:33 AM
Points: 150,
Visits: 3,149
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.
Post #1419292
anthony.green
anthony.green
Posted Wednesday, February 13, 2013 1:57 AM
SSCertifiable
Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075,
Visits: 4,831
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
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
Post #1419343
Rod at work
Rod at work
Posted Wednesday, February 13, 2013 8:29 AM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Today @ 8:25 AM
Points: 573,
Visits: 1,010
Thank you, SQLArcher, for the link.
Kindest Regards,
Rod
Post #1419564
Rod at work
Rod at work
Posted Wednesday, February 13, 2013 8:30 AM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Today @ 8:25 AM
Points: 573,
Visits: 1,010
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
Post #1419567
anthony.green
anthony.green
Posted Wednesday, February 13, 2013 8:38 AM
SSCertifiable
Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075,
Visits: 4,831
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
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
Post #1419573
Rod at work
Rod at work
Posted Wednesday, February 13, 2013 9:09 AM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Today @ 8:25 AM
Points: 573,
Visits: 1,010
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
Post #1419598
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.