| Table of Contents |
|---|
SQL Server editions
...
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 Requirements and Limitations
| 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 |