Home
Hardware
Configurator
Services
OEM Guides About us Warranty Contact
ESENDEFRITPT
Servers · ERP and databases

Server for ERP and databases: cores, memory and drives for SQL Server, Sage and SAP Business One

When the business software runs slowly, it is almost never the software’s fault. It is a server designed to store files being used as a database server. This guide explains what an ERP really needs and how to avoid paying for more licences than necessary.

ACD&CO technical team10 November 20266 min read

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.

Ask whoever supports your software for the requirements by number of users, and whether they certify only one manufacturer’s processors. Some do.

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

Servers for ERP and databases (excluding VAT, built and tested)
CaseServerWhyPrice
Up to about 15 ERP usersSMB server12 fast cores, ECC memory and mirrored drives€4,234
ERP and other services in virtual machinesVirtualisation server16 cores, 64 GB ECC and 4 TB of mirrored SSD€5,652
Software certified only on IntelXeon database server16-core Xeon, 64 GB registered ECC and 10 GbE€8,224
Many users and several databasesEPYC virtualisation server32 cores and six-channel memory€9,935

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.

Ask for a proposal

A proposal within 12 working hours

Tell us what you need

Tell us what it is for and we will reply with a configuration and its price. If you already have a quote from another brand, send it over and we will prepare the equivalent.

  • A written reply within 12 working hours
  • A single point of contact, from quote to warranty
  • No obligation: we only use your details to reply

+34 613 17 68 06info@acdcompany.es

This field is required.
Check the email: something is missing.

Or call us: +34 613 17 68 06