SQL Server Express and ARM
SQL Server Express is no longer included in the ARM installation package. You can integrate SQL Server Express manually — including the appropriate pre-configuration — when you run the ARM installer and configure the setup procedure.
You can integrate SQL Server Express—including the appropriate pre-configuration—when you run the ARM installer and configure the setup procedure.
The following table lists the limitations with using SQL Server Express Edition for your ARM database.
| Limitation | Description |
|---|---|
| 10 GB maximum database size | Stores a limited number of scans |
| 1 GB maximum RAM | Provides poor performance in large environments |
| One CPU maximum | Provides poor performance in large environments |
When you set up your ARM database, use a full supported version of SQL Server running on an SQL database server.
See the system requirements for a list of supported SQL Server versions.
See the Microsoft Learn website for more information about SQL Server versions.
Optimizing your data storage
You can configure your ARM settings to optimize your data storage.
See Determine server thresholds for details about accessing Server Health Check. This utility allows you to review the current size of your ARM database.
See the following sections for details on how to reduce your ARM database size:
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).