SQL Server 2008R2 Express: which is the users limit in a real case scenario?

Posted by PressPlayOnTape on Server Fault See other posts from Server Fault or by PressPlayOnTape
Published on 2011-01-04T14:09:50Z Indexed on 2011/01/04 14:55 UTC
Read the original article Hit count: 281

I know that sql server express has not a user limit, and every application has a different way to load/stress the server.

But let's take "a typical accounting software", where users input some record, retrieve some data and from time to time they make some custom big queries.

May someone share its own experience and tell me which is the limit of users that can realistically use a sql server express instance in this scenario?

I am looking for an indicative idea, like (as an example):

"I had a company with an average of 40 users logged in and the application was working ok on sql server express, but when the users become 60 the application started to seem non repsonsive"

(please note this sentence is pure imagination, I just wrote it as an example).

© Server Fault or respective owner

Related posts about sql-server

Related posts about sql-server-2008-express