October 4, 2005 at 9:31 am
I just had a question from a friend and I couldn't provide all the information he needed. He has been tasked in creating a new application for a compagny. This compagny currently has 6 employees growing on 10. I recommended MSDE / Sql server Express since they are free and should handle the load quite easily. But he tells me that the compagny is ready to pay for a license of sql server. What would be the best/cheapest version to buy and what licensing options should he use (single server, per user)???
October 4, 2005 at 9:41 am
http://www.microsoft.com/sql/howtobuy/default.mspx
Well it depends on the application they are building, and the feature/functions they want to use in sql server. Like replication and log shipping are not available in sql server standard.
Developers should purchase a developer edition of sql server. (Cheap) .
Otherwise Processor licenses seem to be cheaper if you have over 10 users connecting.
But the company should contact a microsoft rep. I'm sure these prices are "Soft"
October 4, 2005 at 9:44 am
Already sent him this link... I wanted to have a more experienced person make a correct recommendation. I never actually had to make such a choice in my [short] career.
Seems to me that replication is not gonna be required in that project (simple billing and inventory application).
October 5, 2005 at 12:39 am
What is he using to develop the app? If he has visual studio from microsoft, it comes with MSDE, etc which he can always use to develop against (does Vis Studio come with developer edition - I'm a delphi developer but do have the MS subscription - never bothered to check for Vis studio??).
If, once it is live, MSDE is too slow because of its workload governor, then by all means, upgrade then. No point in throwing away money. You can run
DBCC ConcurrencyViolation
to let you know if you have had the workload governor kick in and slow down your queries due to >5 concurrent users.
October 5, 2005 at 6:24 am
Pretty much what I originally thaught (thanx for the dbcc command).
Let's say they still chose per user licensing, how are the 10 licenses managed (limited) on the server?
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply