asked on

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

SOLUTION

Mohammed Khawaja

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Scott Pletcher

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 :-).

Vitor Montalvão

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.

ASKER CERTIFIED SOLUTION

Mohammed Khawaja

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

RichDu

ASKER

Thanks guys !

Scott Pletcher

To correct any misunderstanding, SQL Express limits both RAM usage and db size.

Vitor Montalvão

You're right Scott. Limited to 1GB.
Thanks for the correction.