Can anyone advise if there are any major drawbacks in performance from using sql express instead of the full version of sql? Licensing the full version of sql would be 5k for 20 users so if I can run express with no drawbacks in performance it would be preferred. I'm willing to purchase the full version if it will increase the speed and performance of the program however. The major difference I see between the full version and express is the database size but the 10gb database of express is plenty for my needs.

This post was edited on 7/19/15 at 9:40 pm

4 ...

Report Post

Posted by SG_Geaux

Beautiful St George

Member since Aug 2004

77976 posts

Posted on 7/19/15 at 11:33 pm to LSU5508

SQL Express allows the database to use only 1GB of RAM, which could make a huge difference in performance.

This post was edited on 7/19/15 at 11:34 pm

0 ...

Report Post

Posted by antiventura

Member since Aug 2007

69 posts

Posted on 7/19/15 at 11:37 pm to LSU5508

Try Express and see what you think performance wise. If you're just starting with it, you'll likely be fine.

Worst case, you can pick up standard later and migrate your data from express there.

0 ...

Report Post

Posted by tigersnipen

Member since Dec 2006

2085 posts

Posted on 7/20/15 at 7:51 am to LSU5508

LINK

1gb ram and core limits and dB size.

1 ...

Report Post

Posted by LSU5508

New Orleans

Member since Nov 2007

3616 posts

Posted on 7/20/15 at 11:49 am to tigersnipen

Thanks. The DB size does not concern me but the max ram does because i'll have 15 users interacting with the db.

This post was edited on 7/20/15 at 12:20 pm

1 ...

Report Post

Posted by DarthRebel

Tier Five is Alive

Member since Feb 2013

21243 posts

Posted on 7/20/15 at 11:01 pm to LSU5508

It does look like you can go to 4 cores, which would be fine for <10gb database and 15 users. The 1GB of ram will hurt some, but once again it is a small DB. Place the DB(s) on some SSD and it will help.

A decade ago companies were were running 100s of users on 100GB+ databases on 4gb ram (32 bit) and 8 cores. You will be fine.

You could also look at Azure

Azure Pricing

0 ...

Report Post

Posted by Stuckinthe90s

Dallas, TX

Member since Apr 2013

2576 posts

Posted on 7/21/15 at 8:47 am to LSU5508

If you are that small don't run 15 users. Run one admin user with SQL express and an application front end so that no one is directly touching the database except your DBA. Unless you have 15 DBA's, which I highly doubt, I would suggest this method. Then you can run a a community user for reporting for the other 14.

Moral of the story, microsoft licenses are expensive on the enterprise level.

Page 1