Limitation of SQL Server 2008 R2 Express in terms of number of ACT! Premium users

[jotero]

Currently I have a database ACT! 2013 Premium

I have currently 25 users

But I'll have 15 more users.

I must do something with the version of SQL Server 2008 R2 Express?

I need to upgrade to the Standard version??

What is the limitation of SQL Server 2008 R2 Express in terms of number of users?

Thanks for the help

[ghollister · Accepted solution]

SQL Server Express can only use 1 GB of memory and 1 CPU. As Roy said, this could cause performance issues with that many users. There is no user limit (well there actually is, but it's around 32,000 or so). I would see how your performance is, and if there is a noticeable impact, then look at upgrading to Standard.

[Roy_Laudenslager]

I don't believe there's a limit on the number of users. There is a limit on the database size. The big issue with that many users is performace. The SQL Express  is limited on how much memory it will use and it will only use one processor regardless of what the server has available. I would definitely upgrade to SCL Standard.

[ghollister · Accepted solution]

SQL Server Express can only use 1 GB of memory and 1 CPU. As Roy said, this could cause performance issues with that many users. There is no user limit (well there actually is, but it's around 32,000 or so). I would see how your performance is, and if there is a noticeable impact, then look at upgrading to Standard.

[benhamilton]

Yup, there are only three limitations that SQL Server 2008 R2 Express has, 1CPU, 1GB of RAM for the instance, 10GB file size. Going to SQL STD removes those limits. There is no user limit.