Database Component#
Critical Manufacturing MES uses SQL Server databases for persistency. This section describes the requirements for the database component, including software and hardware requirements, as well as notes about SQL Server high availability, storage and licensing.
Software Requirements#
The table below describes the software requirements for database servers:
| Operating System | Database Engine | Additional Required Software |
|---|---|---|
| • Windows Server 2022 | • SQL Server 2019 Standard Edition • SQL Server 2019 Enterprise Edition • SQL Server 2022 Standard Edition • SQL Server 2022 Enterprise Edition | • SQL Server Reporting Services • SQL Server Analysis Services (multidimensional model) • Microsoft Distributed Transaction Coordinator (MSDTC) |
Table: Software requirements for database servers
Hardware Requirements#
Depending on the expected system load, the recommended hardware configuration for the database servers may vary. This section outlines reference configurations for different use cases.
| Configuration | Intended Use | Response time | Scalability | High availability |
|---|---|---|---|---|
| Minimum | Demonstration / Development | Medium/Slow acceptable | Not required | Not required |
| Training / Staging | System tests, validations and training | Medium | Not required | Not required |
| Production A | Low to medium volume production | Fast | Required | Very High |
| Production B | High volume production | Fast | Required | Very High |
Table: Hardware configuration for database servers
The exact hardware requirements will depend ultimately on the specific customer environment. Consult with Critical Manufacturing in order to get a tailored recommendation based on known requirements for your specific installation. These are the minimum requirements:
| Configuration | Number of Servers | Processors | Memory | Storage |
|---|---|---|---|---|
| Minimum | 1 * | 1 x Quad Core, 2 GHz | 8 GB | 200+ GB |
| Training / Staging | 1 | 2 x Quad Core, 2 GHz+ | 16 GB | Online DB: 200+ GB ODS+DWH: 1TB |
| Production A | 2 | 2 x Six Core, 2 GHz+ | 32 GB+ | Internal storage: 150+ GB Storage hard-disk: 2.5TB |
| Production B | 2 | 2 x Eight Core, 2 GHz+ | 64 GB (Active/Active) 128 GB (Active/Passive) | Operating System: 150 GB SAS 15K rpms TempDB: 200 GB+ in SSD Storage: 10 TB+ |
Table: Minimum hardware requirements for database servers
Note
The Minimum configuration assumes that the database server may also run other application components in addition to the database.
SQL Server Configuration#
The sections below offer additional details on SQL Server configurations that are relevant to a Critical Manufacturing installation.