The Integrity Modeler installation program sets up a SQL Server 2014 Express instance named MODELER as part of Standalone and Server Only installations by default. SQL Server provides database storage and management services. In Model Explorer, databases are used to store, organize, and distribute models.
The following table outlines SQL Server system and Integrity Modeler databases following an installation:
Database
Description
System Databases – master, msdb, model, and tempdb
SQL Server System databases are hidden by default in Model Explorer. For more information, see the following SQL Server help topic:
Installed as part of Web Interface. Contains Web Interface user account information.
Examples
Optional component—Contains the Integrity Modeler Example Models.
Models
Optional component—An empty database that’s used to store Models.
Your SQL Server instance may contain additional databases that are used by programs and services other than Integrity Modeler.
The SQL Server Express Edition 2014 provided with Integrity Modeler has the following limitations:
• CPU support is limited to one socket and up to four cores
• 1GB of RAM for each SQL Server instance
• 10GB maximum database size
If you have multiple SQL Server instances installed on one server, databases names in each instance must unique for the server.
While Express edition is sufficient for Standalone Integrity Modeler installations, these limitations can have a direct impact on performance for larger server deployments.
For more information on supported features for each SQL Server edition, refer to the following help topic:
Features Supported by the Editions of SQL Server 2014
If your production requirements exceed the capabilities of Express Edition, you should consider installing SQL Server Standard or SQL Server Enterprise.
To install Integrity Modeler using a SQL Server instance other than the one provided with Integrity Modeler, do the following:
1. Install and configure a SQL Server instance. For more information on supported SQL Server versions, refer to the Integrity Modeler Release Notes document.
For more information on how to install and configure SQL Server, refer to the following SQL Server help topic: