SQL Express 2019 and ARM

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

• 10 GB maximum data base size -> only a limited number of scans can be stored
• 1 GB maximum RAM use -> poor performance in large environments
• 1 physical processor 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.