Archive server recommendations
- Last UpdatedFeb 10, 2025
- 1 minute read
It is recommended the Archive database reside on its own server.
The Archive database holds a copy of the production MES database.
Data is copied on a regular basis from the MES database to the Archive database on a time and Work Order basis. This data then can be used in reports or to restore most of the production data if the production server is lost.
A typical setup would be:
-
Year 1: online data in the Production database or MES database
-
Years 2 to 5: online data in the Archive database
-
Years > 5: offline in files
Key parameters
The following table describes the recommended key parameters to use for the Archive Server in a medium-size system.
|
Parameter |
Comments |
|---|---|
|
Standard Configuration |
16 GB RAM 1-TB disk, RAID 10 – For Data 1-TB disk, no RAID – For Backups |
|
Microsoft Components |
Microsoft Distributed Transaction Coordinator |
|
MES Components |
MES Archive database |
|
System Platform Components |
None. |
|
Scalability |
Typically only one server is needed. If additional servers are needed, they would be configured to hold different "years" of data. |
|
High Availability/Fault Tolerance |
This server does NOT require High Availability (for more details, see Archive server availability and fault tolerance considerations. |
|
Key Measures |
CPU usage < 30% Memory stable with 1 GB free |