SQL server questions

Hi guys & girls,

I need to build/buy new server and i wonder if someone could guide me with sql server (2012 or 2014) licence.

The server will be 1X xeon quad core with 12 gig ram. The server will be DC but for sql, only 6 users will be connected (3 local and 3 from other location) and there is no plan to add some.

Express version is not an option cause the 1gig mem only.

If you have advice, i willtake them. I'm pretty lost with Microsoft choice of licencing, i cant find clear info about what we realy need.

thanks
RichDuAsked:
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.

Mohammed KhawajaManager - Infrastructure:  Information TechnologyCommented:
My recommendation is as per following:

1.  Purchase Windows Server 2012 R2 and SQL Server 2012 Standard Edition with 6 user CALs
2.  Install server with Hyper-V role only
3.  Create two VMs:  DC and SQL (I would assign each 2 core, DC will have 4 GB and SQL should be configured for 7 GB)
0
Scott PletcherSenior DBACommented:
Typically you wouldn't need 7GB for SQL Server for only 6 users.  I'd start with a fixed 4GB and check for memory pressure.

I can't speak to the RAM/requirements for DC as that's not my area of expertise.  But my inclination would be to give 3 cores to SQL and one to DC based on expected relative workload, but I'm a SQL DBA to I'm sure I'm biased on this :-).
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
You shouldn't install a SQL Server in a DC server.
For licensing you'll need to pay for all 4 cores.
SQL Server Express doesn't have limitation on memory but on database size. Maximum of 10GB for a DB.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Mohammed KhawajaManager - Infrastructure:  Information TechnologyCommented:
Clarification about SQL server:
1.  Purchase Standard Edition server and then associated CALs
2.  Purchase SQL Standard Edition with core licensing where you license the cores and no user CALs are required

If you low number of users then license your SQL based on server and user CALs.  If you large number of users then it would be advantageous to purchase core licensing (i.e. list price for SQL 2012 Standard Edition is $900 + $209 per CALs which is approximately $2,200 where core licensing is approximately $1,800 per core and minimum 4 cores are required for a total of $7,600).

The same model exists for SQL 2014.   As long as you do not need Business Intelligence then the above pricing model is correct.

Also look at following links:

http://sqlmag.com/sql-server-2012/microsoft-sql-server-2012-licensing-options
http://www.microsoft.com/en-ca/server-cloud/products/sql-server/purchasing.aspx
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
RichDuAuthor Commented:
Thanks guys !
0
Scott PletcherSenior DBACommented:
To correct any misunderstanding, SQL Express limits both RAM usage and db size.
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
You're right Scott. Limited to 1GB.
Thanks for the correction.
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 SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.