Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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 VersionCPURAMDatabase Size
2008/2008 R2
20121 CPU1GB10GB
20141 CPU1GB10GB
2012
20161 CPU1GB10GB
2014
20171 CPU1GB10GB
2016
20191 CPU1GB10GB


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.

...

Page Properties
hiddentrue


Related issues