Problem
By default, GlobalSearch and GlobalCapture are shipping with Microsoft SQL Server Express Edition, Microsoft's free version of SQL Server. While SQL Express may be enough GlobalSearch versions 5.0.0.0 and GlobalCapture 2.2 and higher are shipped without Microsoft SQL Server and some users may opt to utilize Microsoft SQL Server Express. While this may be sufficient for most users, there are some limitations that you should be aware of. In addition to limiting the number of CPUs that can be used, SQL Express limits the amount of RAM that can be consumed by the SQL engine as well as limiting the individual database size to a maximum capacity. Please see the chart below for information regarding the limitations of SQL Express.
Please not that GlobalSearch versions lower than 5.0.0.0 and GlobalCapture versions lower than 2.2 were shipped with Microsoft SQL Server Express :by default.
SQL Version | CPU | RAM | Database Size |
---|
2008/2008 R22012 | 1 CPU | 1GB | 10GB |
2014 | 1 CPU | 1GB | 10GB |
201220142016
Once the database has reached the limit, SQL Server will no longer allow any data to be stored in that database which will prevent Square 9 software from working properly.
...