What are the limitations of using SQL Express as the BigFix database?
SQL Express is a version of Microsoft SQL Server that is included with default installations of BigFix. It is not recommended for production deployments.
Resolving the problem
SQL Express is the default SQL database that is installed with the BigFix Server if the machine does not have the full version of Microsoft SQL Server installed.
There are a few limitations that SQL Express imposes including: a limit on the size of the database (2 GB), a limit on the number of processors utilized (2), and a limit on the number of concurrent connections. For more information on SQL Express limitations, please refer to Microsoft's web site.
These limitations will not usually affect BigFix unless there is more than one BigFix Console operator connected to the database at the same time. If more than one BigFix Console operator is connected to the database at the same time, the performance of the database will be degraded. If a organization intends to have more than one BigFix Console concurrently accessing the same database, then they will need a full version of Microsoft SQL Server.
IBM recommends using the full version of SQL Server for all production deployments because of the limitations listed above and because of the ease of administration of SQL Server using the Management Studio.