Performance tuning your Sage X3 system: Operating System

2 minute read time.

Updated: 03 August 2023

Back to Index

Please note this document and all other documents it links to are living documents so will evolve over time as new things are discovered, new functionality is provided, best practises adjusted and/or when I get time to add content; so please make sure you come back and visit this source document often.

Contents

Performance tuning your Sage X3 system: Operating System

Introduction

Virtualisation technologies

Hardware

General blogs, KB articles, etc.

Operating Systems

Introduction

Sage Support team are likely not going to be best placed to provide best and specific advice about hardware, operating systems nor virtualisation technologies, however these components cannot be ignored when looking at performance and will often be the first point of call when trying to identify where a performance bottleneck is.   You should employ your in-house expertise or specialist partner when looking at these areas, however having said that I can share some knowledge in this article.     If advice is needed regarding hardware sizing, or operating system tuning the Sage Center of Excellence and Expertise team are well placed to assist.

Virtualisation technologies

Tuning the operating systems these days often needs to start with looking at any Virtualisation technology that may be in use, as if being used this will add another layer of complexity that is invisible from the underlying operating system itself.  When looking at performance issues, make sure you have confirmed the physical hardware is performing well before looking at Virtual Servers.   One example previously identified for VMWare was excessive “ballooning”, discussed in http://www.vmwarearena.com/vmware-memory-management-part-3-memory-ballooning/

There have been reports with customers using VEEAM whereby Sage X3 sessions experience intermittent disconnects/crashes. VEEAM freezes a VM for a few seconds when taking snapshots, which was found to sometimes cause this situation, but can also happen when deleting snapshots which is described in https://www.veeam.com/kb1681

Hardware

It is useful to understand the hardware specification for each server being used for Sage X3 components (these comments are mostly from Sage Center of Excellence team):

  • CPU

Clock speed matters, but also L3 cache.   Can use 7-Zip benchmark test to get feel of raw power.
With VMware found 4-8 CPU per VM gives best performance.

  • Memory
  • Page File size
  • Physical Disk sizes and Disk types (if physical server) e.g. size, rpm, SATA

e.g. locally connected (internal) disks, SAN, NAS, etc.

  • Logical disk configuration i.e. drive assignments, RAID level, etc.

Use flash for database files.  RAID 5 or 6 for X3 application.  Split OS, Applications and SWAP especially for Syracuse/MongoDB servers.

  • Network cards/ speeds

General blogs, KB articles, etc.

Virtualization best practice documentation obtained (KB article)

Hey people! I discovered a new tool… and it’s called Perfinsights! (Part 1 of 2)  (Blog)

I’m Back! Reviewing the Perfinsights Report (Part 2 of 2)  (Blog)

The Sage Center of Excellence and Expertise team have put together the following bookmarks:

VMWare

ESXi 7.0 U3 performance best practice white paper: https://www.vmware.com/techpapers/2022/vsphere-esxi-vcenter-server-70U3-performance-best-practices.html

ESXi 7.0 U2 performance best practice white paper: https://www.vmware.com/techpapers/2021/vsphere-esxi-vcenter-server-70U2-performance-best-practices.html

ESXi 7.0 performance best practice white paper: https://www.vmware.com/techpapers/2020/vsphere-esxi-vcenter-server-70-performance-best-practices.html

ESXi 6.7 U2 performance best practice white paper: https://www.vmware.com/techpapers/2019/vsphere-esxi-vcenter-server-67U2-performance-best-practices.html

vCPU and vNUMA rightsizing guidelines: https://blogs.vmware.com/performance/2017/03/virtual-machine-vcpu-and-vnuma-rightsizing-rules-of-thumb.html

Azure

SQL Server on Azure performance best practices: https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/performance-guidelines-best-practices-checklist?view=azuresql

Operating Systems

Follow the links below for operating system specifics:

Component

Last Updated

6.1: Windows

13 December 2022

6.2: Linux

(Content to follow)

Back to Index