Exact Globe

Server hardware and software recommendations for Exact Globe Next

In this document, you will find additional hardware and software requirements for a SQL Server used with Exact Globe Next. This document can help you selecting the appropriate hardware and software for optimal performance.

System recommendations based on database size

Description	Database size in GB	Memory	Processor	Minimal disks	Recommended disks	RAID configuration
Standalone	< 5 GB	4 GB RAM	2 cores	1 disk (7,2k RPM)	2 disks (7,2k RPM)	Single disk / RAID 1
Small database	5 GB - 25 GB	8 GB RAM	4 cores (Xeon / Opteron)	2 disks (7,2k RPM)	2 disks (SSD*)	RAID 1
Medium database	25 GB - 50 GB	16 GB RAM	6 cores (Xeon / Opteron)	4 disks (10k RPM)	2 disks (SSD*)	RAID 1/5/10
Medium database	50 GB - 100 GB	32 GB RAM	8 cores (Xeon / Opteron)	6 disks (10k RPM)	4 disks (SSD*)	RAID 5/10
Large database	100 GB - 250 GB	64 GB RAM	12 cores (Xeon / Opteron)	10 disks (15k RPM)	4 disks (SSD*)	RAID 5/10
Large database	250 GB+	Analysis needed

* Tests in the Exact test lab shows a average performance gain of more than 50% when using Solid State Disks instead of conventional disks.

Important notes

Exact recommends using a hardware RAID system.
Disks which contain SQL Server databases, should be formatted in 64k block size.
All recommendations are based on a dedicated disk set for the SQL Server databases.
When virtualizing Microsoft SQL Server on a Storage Area Network, see document 21.603.931.
Take expected database growth into consideration.
Make sure the server hardware is scalable.
Always keep the Operating System hardware limits in mind. The limits for the different editions from Windows Server 2012 R2 can be found here.
When using Solid State Disks (SSD), use fill factor 90 for the indexes. This can be done using the Exact System Information Tool. This will make the disks last longer.
Exact advises a dedicated database server (SQL Server) for larger databases to guarantee optimal performance.

Disk system information

Exact advises the use of a hardware RAID system (Redundant Array of Independent Disks). In a RAID system, multiple hard disks are used for sharing and replicating data over all disks. Depending on the selected RAID system, the data integrity and the performance will increase compared to using one disk. The purpose of fault tolerance is the most important. With this, data can be rebuild if one of the disks crashes.

Exact Globe Next in general will perform better in combination with RAID 5 or RAID 10, since most actions in Exact Globe Next relate to reading data. For the best disk performance, Exact recommends to use Solid State Disks (SSD) instead of conventional disks.

Feature	Single Disk	RAID 0	RAID 1	RAID 5	RAID 10
Minimum number of disks	1	2	2	3	4
Fault Tolerance	No	No	Yes	Yes	Yes
Advantages	Cheap	Fast Read & Write	Fast Read & Write	Faster Read	Faster Read & Write
Disadvantages	Slow in a disk intensive environment	No Fault Tolerance	Only 50% disk space available	Consumes 1 free disk	Most expensive, only 50% disk space available
Recommendation	Single user	Not recommended	Single user or SME	SME	SME or large enterprises

SQL Server recommendations and features supported by the editions

	Requirements	Features
SQL Server 2017	More information	More information
SQL Server 2016	More information	More information
SQL Server 2014	More information	More information

Main Category:	Support Product Know How	Document Type:	Support - On-line help
Category:	On-line help files	Security level:	All - 0
Sub category:	Details	Document ID:	30.049.514
Assortment:	Exact Globe	Date:	01-04-2021
Release:		Attachment:
Disclaimer