Microsoft SQL Server Express Editions

Acctivate utilizes the Microsoft SQL Server database engine.  Many companies are able to use the included, free Express Edition.  Companies with a higher transaction volume may be required to upgrade to the SQL Server Standard edition to increase performance and capacity.

SQL Server Express includes the following limitations on the database file size, plus memory and processor utilization limits.

SQL Server Version Database File Size Memory (RAM) Processor (CPU)
2000 Desktop Engine (MSDE) 2GB 2GB 1 cpu*
2005 Express 4GB 1GB 1 cpu
2008 Express 4GB 1GB 1 cpu
2008 R2 Express 10GB 1GB 1 cpu
2012 Express 10GB 1GB 1 socket, up to 4 cores
2014 Express 10GB 1GB 1 socket, up to 4 cores

*SQL Server 2000 Desktop Engine (MSDE) included a workload governor limiting the database engine to 8 concurrent operations.  This limitation was removed in SQL Server 2005 Express and later versions.

View the complete comparison chart of all SQL Server Editions from Microsoft.

Posted in Database, Installation - Last modified on June 4, 2019Quinn Winkler
Still need help?
Search all content on this site, contact support at 817-870-1311, or create a support ticket.