Changes for page sql-managed-instance
Last modified by Rudi Marais on 2023/05/22 23:50
Change comment:
There is no comment for this version
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -4,6 +4,7 @@ 4 4 * [[HammerDB>>url:https://www.hammerdb.com/download.html]] 5 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 6 7 + 7 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 8 9 9 |Max number of databases per instance|100 user databases, unless the instance storage size limit has been reached. ... ... @@ -15,23 +15,7 @@ 15 15 |Max concurrent workers|105 * number of vCores + 800 16 16 | | 17 17 19 + 18 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 19 |IOPS per file|500|2300|5000|7500|7500|12,500 20 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 -