Specifications and Best Practice for On-Premise SAP Business One MS SQL Landscapes

Server(s) Specification and Configuration

Refer to the attached Hardware Requirements Guide for SAP Business One.pdf[1]

ProjectLine can provide consultation to your third-party IT provider, or be involved directly with the configuration of your SAP Business One Server (B1 Server) or Terminal Application Server. Please contact your account manager if you would like to know more about these services. 

Did you know ProjectLine also provides private cloud hosting for SAP Business One? For more information visit https://www.projectline.ca/cloud or Contact ProjectLine Support.

SAP Business One Server running on Microsoft SQL

• SAP B1 Server – Microsoft Windows Server[1]
• It is recommended that SAP B1 server be virtualized, hypervisor is your choice. We have had good success with Windows Hyper-V. One copy of Windows Server does permit 2 VM licenses.
• Microsoft SQL Server[1] with SQL CAL’s matching the number of SAP B1 users.
  • SQL maintenance plan should be in place, including backups and database optimization.
  • SQL Server Collation settings for SAP Business One are quite specific, please consult the documentation before installing Microsoft SQL Server.
  • Contact ProjectLine Support if you would like assistance installing Microsoft SQL, or setting up your SQL maintenance plan.
• Database VM should exist on a RAID 10 volume with minimum SAS 10k drives (SAS 15k drives are preferred).
  • SSD drives may also be used, which match or exceed the performance of 15k SAS. 
  • 2 disk volumes  - one for OS and one for SQL data which are appropriately sized for your environment.
• RAM is dependent on database size and user counts but generally 16GB as a recommended minimum.
  • Performance should be periodically assessed, and resources allocated as needed.
  • SQL memory usage should be monitored and capped if required, as it will often use as much as it is allocated.
• vCPU – minimum of 2-4 vCPU’s dependent on number of SAP B1 users
  • Performance should be periodically assessed, and resources allocated as needed.
• To best provide support and consulting services, ProjectLine may require remote access to your SAP B1 Server for consulting and support services. The means of remote access to your SAP B1 Server VM is your choice. However, windows remote desktop access with enhanced security measures, and no VPN login requirement, is preferred.
  • For enhanced security, in the absence of VPN, ProjectLine recommends tailoring access for our team using IP ‘white-listing’ strategies. ProjectLine consulting and support will connect to your RDP services through 1 centralized IP address which will be shared upon request.

Terminal Application Server for SAP Business One

• It is recommended that the Terminal Application Server be virtualized on a second, separate VM from your SAP B1 Server. This will depend on your preferred delivery method of the SAP B1 client to end-users.
  • As general rule we allocate 1.5  to 2 GB of RAM per SAP B1 user

Performance Tuning

• Physical Hardware BIOS setting
  • On Dell and HP servers running SQL Server virtualized workload power settings must be set to Performance

  • For more information please refer to the following VM Knowledge Base Article

[1] See attachments below