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.