Software & Hardware requirements

Desktop Client

• Operating system: Windows 10 or higher (64-bit)

• Memory (RAM): at least 8GB

• Storage: at least 20GB of free space (SSD)

• Processor (CPU): at least Intel Core i5 or similar (4 cores)

• Screen resolution: at least 1280x1024

• Required software:

  • Microsoft .NET Framework 4.8

  • Microsoft Access Database Engine 2010 Redistributable

Application Server

• Operating system: Windows® Server 2016 or higher (64-bit)

• Memory (RAM): at least 32GB

• Storage: at least 6GB of free space (SSD)

• Processor (CPU): at least Intel Xeon or similar (6 cores)

• Required software:

  • Microsoft .NET Framework 4.8

  • .NET Core 3.1 Hosting Bundle

  • Microsoft WSE 3.0

  • Microsoft Internet Information Services 8 (IIS8) or higher

Database Server

• Operating system: Windows® Server 2016 or higher (64-bit)

• Memory (RAM): at least 32GB

• Storage: at least 1TB of free space (SSD)

• Processor (CPU): at least Intel Xeon or similar (4 cores)

• Required software:

  • SQL Server 2016 SP2 or higher (Standard Edition), with minimum compatibility level of 110 (Compatibility level - SQL Server)

High availability & performance

To ensure high availability and better performance we recommend the usage of a load balancer that distributes traffic between at least two application servers (each one following Requirements - Application Server recommendations) and at least two database servers (each one following Requirements - Database Server recommendations) with SQL Server instances connected by AlwaysOn availability groups (AAGs).

We recommend at least 10Gbps of network bandwidth between application and database servers.

SQL Server recommendations

Limit available memory

It is recommended to limit the available memory for SQL Server according to the following table (Suggested Max Memory Settings for SQL Server 2005/2008 – SQLServerCentral):

Data audit logging

The activation of the data audit logging system is subject to the activation of the CLR integration system (https://learn.microsoft.com/en-us/sql/relational-databases/clr-integration/clr-integration-enabling?view=sql-server-2016).

The logs data can be on a separate database or share the same database as our application, in which case it will be necessary to provide more space. The increased space is directly related to the number of tables in which the system is activated.

Currently the system has no retention period, but it is possible to create one according to the customer’s indication. It is also possible to configure SQL Server to work with the use of partitioning functions, so that it is easier to remove old data.

Firewall permissions

If the customer organization has a firewall to restrict traffic to or from the Internet, some additional configuration is required to allow M1 solution to connect to certain hostnames for some features to work unhindered.

Application servers

Desktop clients

FAQ

Do we still support SQL Server 2012 SP4 (Standard edition)?

Yes, we still support SQL Server 2012 SP4 (Standard edition), with compatibility level of 110, but we are recommending our customers to upgrade to SQL Server 2016 SP2 or higher (Standard Edition) since it has reached end-of-life (https://learn.microsoft.com/en-us/lifecycle/products/microsoft-sql-server-2012).

Is there a backup policy recommendation?

It is important that backup policies are created so that data is not lost. The backup strategy is at the customer’s discretion since it requires additional investment and there may already be backup systems in operation.