SQL 2005 Express loads question

[Jim Bassett]

Does anyone know if there are test shoing the load SQL 2005 Express can handle if installed ona server? I am referring to loads such as number of users it will support, number of same time transactions, etc.

Thank you!

[hspc]

I found no information about the number of users and transactions..
But SQL server express edtion is based on the same engine used by the other edtions. However It has some limitations:


Supports only 1 processor
1 (GB) addressable RAM
Maximum DB size is 4GB

[Jim Bassett]

Thank you. Yes I couldn't find anything about its multi user performance either and we are creating some scripts to test it.

[DanielaTm]

Maybe this link could help:

http://www.orcsweb.com/support/sqlserver2005_faq.aspx