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
sql-server
|sql-server-2008-express
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