SQL Express 2017 and ARM

Microsoft SQL-Server Express Edition 2017 has the following limitations:

• 10 GB maximum data base size -> only a limited number of scans can be stored
• ca. 1.4 GB maximum RAM use -> poor performance in large environments
• 4 cores maximum -> poor performance in large environments

 

ARM allows you to configure your settings in order to optimize data storage:

Information on actual data base size can be found in the Server health check.

Details on reducing data base size can be found in the following topics: storage of scans and SQL-Server data base maintenance.

 

You can find additional information in the article Available SQL Server 2017 editions. (© 2020 Microsoft, https://www.microsoft.com/en-us/sql-server/sql-server-2017-editions, obtained on January 29, 2020).