What an ERP needs inside
Behind almost every business program there is a database, very often SQL Server. Three things make it fast: fast cores, rather than many cores; enough memory to keep frequently used data loaded; and drives that write quickly and lose nothing if the power goes.
A standard file server fails on exactly those three.
Cores and licences: fewer is cheaper
SQL Server can be licensed per core or per server with access licences per user. In the per-core model you pay for every core in the processor, so a 32-core processor costs twice as much in licences as a 16-core one, even if the ERP uses no more.
That is why databases are given processors with few cores and high speed per core. Editions also have a cap on the cores and memory they use: check the one for your version before buying more than the software can use.
Memory: the database lives in it
The database tries to keep in memory everything that is queried often. If it does not fit, it goes to disk and everything slows down. The practical rule: memory for the active part of the database, plus the system and the other services. And always ECC: a memory error in a database becomes a corrupt record.
Drives: fast, mirrored and with backups elsewhere
Data and transaction logs go on mirrored NVMe SSDs. Enterprise-class models have power-loss protection, which is what prevents losing the last operation. Backups go on another machine, not on another drive in the same server.
If you are going to SAP HANA
SAP Business One runs on SQL Server or on SAP HANA. HANA works entirely in memory and SAP only supports it on validated hardware. If that is your route, the list of accepted machines is set by your SAP partner before anyone else.
Starting points
| Case | Server | Why | Price |
|---|---|---|---|
| Up to about 15 ERP users | SMB server | 12 fast cores, ECC memory and mirrored drives | €4,234 |
| ERP and other services in virtual machines | Virtualisation server | 16 cores, 64 GB ECC and 4 TB of mirrored SSD | €5,652 |
| Software certified only on Intel | Xeon database server | 16-core Xeon, 64 GB registered ECC and 10 GbE | €8,224 |
| Many users and several databases | EPYC virtualisation server | 32 cores and six-channel memory | €9,935 |
Related hardware and guides
Frequently asked questions
Physical server or virtual machine for the ERP?
Both options work. In a virtual machine, reserve cores and memory for the database and put its disks on SSD. That way the ERP does not compete with the other services.
Why is my ERP slow if the server is new?
Almost always because of the drives or the memory: mechanical drives for the database, or too little memory for the size of the data. A processor with many slow cores does not help either.
Intel or AMD for a database?
Both perform well. Choose Intel if the software vendor only certifies Intel or if your database benefits from AVX-512. Otherwise, look at speed per core and price.
How much memory do I need?
Enough for the part of the database used every day, plus the system. As a starting point, 32 GB for a small company and 64 GB or more when there are several services or many users.
Shall we size your server?
Tell us how many people you are, which software you use and how much data you hold. We will propose the server in writing, with a price, within 12 working hours.