Requirements for a database server
Comarch ERP Standard system runs in Client/Server architecture. In case of the simplest installation on a single workstation, both the layer of the database server and the application may be running on one workstation. In practice, the functions of the database server are available on a separate hardware platform.
Below, additional facets, which must be taken into account when creating an infrastructure for the system.
When installing a database server, it is important to pay attention to MS SQL server collation as well as its default language. The required collation is Latin1_General_CI_AS or Polish_CI_AS, and the required language is English. In case of using a different collation or a case-sensitive feature or a different language, errors may occur when creating a database or during work with the system.
While working with several Comarch ERP systems (Optima, Standard, XL), it is recommended that each created database for those systems be on different MS SQL Server instance.
- In a situation when Comarch ERP Standard and Comarch ERP Optima are installed on the same server and due to collation required for Comarch ERP Optima (Polish), two cases must be distinguished:
- Comarch ERP Standard database has a collation Polish – both databases can be installed on the same server
- Comarch ERP Standard database has a collation Latin – databases must be installed on different SQL instances, compatible with their collation
- In case of BI server, it is recommended that server collation is the same as collation of Comarch ERP Standard collation and collation of SQL server on which the production environment is located
Recommended server requirements
The supported server processors should be of Xeon class or comparable. It is also recommended that the processors support Hyper-Threading Technology, which is used for increasing performance of calculations made simultaneously by microprocessors That means that for each physical core of a processor, the operating system assigns two virtual processors (vCPU).
Hardware requirements for database server presented below are specified for Comarch ERP Standard system.
The set of minimum requirements for database server per user/users is presented in the below table
Resources/Number of Users | 5 | 10 | 20 | 30 | 40 | 50 | 80 | 100 |
---|---|---|---|---|---|---|---|---|
Physical Processor* | 2-core | 2-core | 4-core | 4-core | 6-core | 6-core | 8-core | 8-core |
Virtual Processor** | 3-vCPU | 4-vCPU | 5-vCPU | 6-vCPU | 8-vCPU | 10-vCPU | 14-vCPU | 16-vCPU |
RAM | 6 GB | 12 GB | 16 GB | 24 GB | 32 GB | 36 GB | 48 GB | 64 GB |
HDD | SDD or SAS 15000 rpm.disks | |||||||
RAID | RAID 10 | |||||||
NIC | 100 Mb/s | |||||||
Operating System | Microsoft Windows Server 2012 R2 Standard Edition |
|||||||
Microsoft Windows Server 2016 Standard Edition | ||||||||
Microsoft Windows Server 2017 Standard Edition |
||||||||
SQL | Microsoft SQL Server 2012 Standard Edition or higher | |||||||
Microsoft SQL Server 2014 Standard Edition or higher | ||||||||
Microsoft SQL Server 2016 Standard Edition or higher | ||||||||
Microsoft SQL Server 2017 Standard Edition |
* Due to the fact that physical cores are paired, potential power of a processor on physical hardware may be higher than it is required for given number of users
** Refers to virtualized environments based on Hyper-V
In case of synchronization services, which ensure exchange of data between applications, number of subsidiaries in which the application is installed is recalculated into number of Comarch ERP Standard users imposing load on a database:
- Service of data exchange between Comarch ERP Standard and POS – 4 POS workstations = 1 Comarch ERP Standard user
it is required to respectively increase the environment’s parameters or estimate the hardware configuration individually.