Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Will CS Workgroup with SQL Express allow for the same number of users as DB/Text WorkGroup?

April 26, 2017DB Express sql text Users workgroup

0

Posted

Will CS Workgroup with SQL Express allow for the same number of users as DB/Text WorkGroup?

1 Answer

0

Posted

A. CS WorkGroup based on SQL Express does not have a set number of nodes like the DB/Text products. There is also no workload governor as in the previous MSDE version. The only performance limitation that SQL Server 2005 Express possesses is that it can access only a single CPU and 1 GB of RAM. This is less than the 2-CPU and 2-GB limitation of MSDE. However, SQL Server 2005 Express provides a much more predictable environment than does the MSDE workload governor. The new SQL Server 2005 Express ceiling of 1 GB of RAM coupled with today’s high performance processors provides more than adequate capacity for a large number of concurrent users.