Is there information available to help determine at what point a need customer would need to purchase the Standard or Workgroup Version instead of using the Express version?
I am in the process of changing the DBMS and would like to offer SQL Server. We are a small company and many of our clients are also small. SQL Server Express would be ideal for them, and not cost anything.
I realize the limitations of the Express version (1 cpu, 4 gb data, 1 gb ram), with the 1 cpu support being my biggest concern, but because it can run locally and on the server, a few concurrent users shouldn't have any problem using it.
But at some point, or for some "small-larger" customers with tight budgets, a need will be there to go a step higher.
Considering a certain amount a data input and reporting (ignoring record edits, however the has data a lot of validation prior to saving it) and a certain amount of concurrent users, what would be a good relation using just these two factors in determining when Express is not suitible anymore, prior to the client purchasing our produkt.
Could I safetly say that 10-15 concurrent users and 500 MB of data per year (however, at peak times there may be 300 record validations and inserts within an hour or two along with reporting) is the limit, or is it much higher, or lower? (I realise that the way the application is designed, network, server cpu/HD and workstation speed makes a big impact, but that does not need to be considered here).
What are your experiences with the Express version in a multi-user environment?
I am in the process of changing the DBMS and would like to offer SQL Server. We are a small company and many of our clients are also small. SQL Server Express would be ideal for them, and not cost anything.
I realize the limitations of the Express version (1 cpu, 4 gb data, 1 gb ram), with the 1 cpu support being my biggest concern, but because it can run locally and on the server, a few concurrent users shouldn't have any problem using it.
But at some point, or for some "small-larger" customers with tight budgets, a need will be there to go a step higher.
Considering a certain amount a data input and reporting (ignoring record edits, however the has data a lot of validation prior to saving it) and a certain amount of concurrent users, what would be a good relation using just these two factors in determining when Express is not suitible anymore, prior to the client purchasing our produkt.
Could I safetly say that 10-15 concurrent users and 500 MB of data per year (however, at peak times there may be 300 record validations and inserts within an hour or two along with reporting) is the limit, or is it much higher, or lower? (I realise that the way the application is designed, network, server cpu/HD and workstation speed makes a big impact, but that does not need to be considered here).
What are your experiences with the Express version in a multi-user environment?