Sharepoint 2010 Foundation , SQL 2012 licensing question

We currently have Sharepoint 2010 foundation with SQL 2012 Express. We are fast approaching the 10gb limit of this SQL version. My question is: If we upgrade to SQL 2012 Standard to get past this limit, what do we need to buy?  Even after searching the Internet about this I still can't figure it out.   If we get the SQL server standard(not sure where to start), do we also need CALs if it's only used for Sharepoint? It's a standalone virtual server, no farm. Processor is Xeon-e5-2660, 8 cores.
DougPennemanAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rainer JeschorCommented:
Hi,
SQL Server Standard can be licensed either core-wise or Server + CAL.
Core licensing requires a minimum of four cores license - even if you only use two (regardless of physical or virtual cores).
If you choose Server+CAL each user/device has to have a CAL. Therefore you would simply have to count the number of users who will access our SharePoint farm.
Licensing details:
http://download.microsoft.com/download/7/3/C/73CAD4E0-D0B5-4BE5-AB49-D5B886A5AE00/SQL_Server_2012_Licensing_Reference_Guide.pdf

Alternative (but that depends on you SharePoint Foundation structure): create additional content databases - e.g. after 5GB create the next one and/or separate your web app into multiple site collections to split content size.

HTH
Rainer
0
DougPennemanAuthor Commented:
So even if I only have 2 cores on the virtual machine, i have to purchase an 8 core because of the physical processor?
There will probably be 50 users so I am trying to weigh which licensing model to use.
0
Rainer JeschorCommented:
Hi,
no - you license the vCores / cores you use - but with a minimum of 4 cores. Please see page 11 of the licensing guide (link in my last comment).

Sorry that I have no clue about licensing costs but 50 user seems to be more the point to use server + CAL.
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

DougPennemanAuthor Commented:
Thanks for the link. I found this. This shows the per core option is way better for me. I see where you can get it in 2 core packs. Where did you get 4 minimum?
*********
"The workhorse SQL Server 2012 Standard Edition remains the staple of the product line for serious database applications. It can handle up to 16 cores with an unlimited amount of RAM. The major change in licensing from SQL Server 2008 to SQL Server 2012 is that a per core option is now available for the Standard Edition. This means that you have two choices: purchase per core licenses at $1,793 or purchase a server license at $898 and client access licenses at $209 per client."
0
Rainer JeschorCommented:
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DougPennemanAuthor Commented:
Ok. I see. Two pack option is for when you have 6 cores or something like that. I was hoping that maybe SharePoint would count as the one USER that accesses SQL, not all the sharepoint users.  I'll have to make a spreadsheet to see what option works best.
0
DougPennemanAuthor Commented:
Perfect link for figuring out this licensing
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.