Wiki source code of sql-managed-instance
Version 1.9 by Rudi Marais on 2023/02/20 16:54
Show last authors
| author | version | line-number | content |
|---|---|---|---|
| 1 | |||
| 2 | |||
| 3 | |||
| 4 | * [[HammerDB>>url:https://www.hammerdb.com/download.html]] | ||
| 5 | * [[Download ODBC Driver for SQL Server - ODBC Driver for SQL Server ~| Microsoft Learn>>url:https://learn.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver16]] | ||
| 6 | |||
| 7 | [[Resource limits - Azure SQL Managed Instance ~| Microsoft Learn>>url:https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/resource-limits?view=azuresql-mi]] | ||
| 8 | |||
| 9 | |Max number of databases per instance|100 user databases, unless the instance storage size limit has been reached. | ||
| 10 | |Max number of database files per instance|Up to 280, unless the instance storage size or [[Azure Premium Disk storage allocation space>>url:https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/doc-changes-updates-known-issues?view=azuresql-mi#exceeding-storage-space-with-small-database-files]] limit has been reached. | ||
| 11 | |Max data file size|Maximum size of each data file is 8 TB. Use at least two data files for databases larger than 8 TB. | ||
| 12 | |Data/Log IOPS (approximate)|500 - 7500 per file | ||
| 13 | *[[Increase file size to get more IOPS>>url:https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/resource-limits?view=azuresql-mi#file-io-characteristics-in-general-purpose-tier]] | ||
| 14 | |Max sessions|30000 | ||
| 15 | |Max concurrent workers|105 * number of vCores + 800 | ||
| 16 | | | | ||
| 17 | |||
| 18 | |=**File size**|=**>=0 and <=129 GiB**|=**>129 and <=513 GiB**|=**>513 and <=1025 GiB**|=**>1025 and <=2049 GiB**|=**>2049 and <=4097 GiB**|=**>4097 GiB and <=8 TiB** | ||
| 19 | |IOPS per file|500|2300|5000|7500|7500|12,500 | ||
| 20 | |Throughput per file|100 MiB/s|150 MiB/s|200 MiB/s|250 MiB/s|250 MiB/s|250 MiB/s | ||
| 21 | |||
| 22 | * 20 minutes to start up when stopped | ||
| 23 | |||
| 24 | |||
| 25 | == backups == | ||
| 26 | |||
| 27 | [[Quickstart: Backup & restore to Azure Blob Storage - SQL Server ~| Microsoft Learn>>url:https://learn.microsoft.com/en-us/sql/relational-databases/tutorial-sql-server-backup-and-restore-to-azure-blob-storage-service?view=sql-server-ver16&tabs=SSMS&viewFallbackFrom=azuresqldb-mi-current]] | ||
| 28 | |||
| 29 | |||
| 30 | [[GitHub - JocaPC/qpi: Query Performance Insight - analyze performance of your SQL Server Database Engine>>url:https://github.com/JocaPC/qpi]] | ||
| 31 | |||
| 32 | |||
| 33 | |||
| 34 | |||
| 35 | storage acccount with storage container [TDE must be turned off - encrypting key must be dropped!] | ||
| 36 | |||
| 37 |