---
alias: system-requirements-database-layer-index
tags:
- database
description: "This documentation outlines database component requirements for Critical Manufacturing MES, including software, hardware, and SQL Server configurations"
---

# 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<br/>• SQL Server 2019 Enterprise Edition<br/>• SQL Server 2022 Standard Edition<br/>• SQL Server 2022 Enterprise Edition | • SQL Server Reporting Services<br/>• SQL Server Analysis Services (multidimensional model)<br/>• 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 <br/>ODS+DWH: 1TB                                                 |
| **Production A**       | 2                 | 2 x Six Core, 2 GHz+   | 32 GB+                                            | Internal storage: 150+ GB <br/>Storage hard-disk: 2.5TB                              |
| **Production B**       | 2                 | 2 x Eight Core, 2 GHz+ | 64 GB (Active/Active)<br/>128 GB (Active/Passive) | Operating System: 150 GB SAS 15K rpms<br/>TempDB: 200 GB+ in SSD<br/>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.

* [SQL Server Always On](sqlserveralwayson.md)
* [Storage Area Network Configuration](storagenetworkconfiguration.md)
* [SQL Server Licensing](sqlserverlicensing.md)
* [SQL Server Permissions](sqlserverpermissions.md)