| Table of Contents |
|---|
...
- SQL Server 2014
- SQL Server 2016
- SQL Server 2017
- SQL Server 2019
- SQL Server 2022
- Azure SQL Database
- Azure SQL Managed Instance
...
First of all, in order to check if the SQL Server Agent service is running on the SQL server and for storing historical index usage for optimal maintenance, the user needs the View Server State permission for the SQL server.
...
| Azure SQL Database | Azure SQL Managed Instance | |
|---|---|---|
| Authentication | Only SQL Server authentication is supported | Only SQL Server authentication is supported |
| SQL Agent Job | Not supported, jobs will be executed by the web application | Supported |
| Linked Server | Not supported | Supported |
| Max database size | https://learn.microsoft.com/en-us/azure/azure-sql/database/resource-limits-vcore-single-databases?view=azuresql | Up to currently available instance storage size (depending on the number of vCores). https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/resource-limits?view=azuresql |
| Max tempdb size | https://learn.microsoft.com/en-us/azure/azure-sql/database/resource-limits-vcore-single-databases?view=azuresql | General Purpose: Limited to 24 GB/vCore Business Critical: Up to currently available instance storage size https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/resource-limits?view=azuresql |
...