Changes for page sql-managed-instance

Last modified by Rudi Marais on 2023/05/22 23:50
<
From version < 1.3 >
edited by Rudi Marais
on 2023/02/15 08:09
To version < 1.10 >
edited by Rudi Marais
on 2023/05/18 05:53
>
Change comment: Update document after refactoring.

Summary

Details

Page properties
Parent
... ... @@ -1,1 +1,1 @@
1 -Technical Documentation.analysis.WebHome
1 +Technical Documentation.analysis.sql.WebHome
Content
... ... @@ -4,7 +4,6 @@
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 -
8 8  [[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]]
9 9  
10 10  |Max number of databases per instance|100 user databases, unless the instance storage size limit has been reached.
... ... @@ -16,7 +16,23 @@
16 16  |Max concurrent workers|105 * number of vCores + 800
17 17  | |
18 18  
19 -
20 20  |=**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**
21 21  |IOPS per file|500|2300|5000|7500|7500|12,500
22 22  |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 +

Applications

Navigation

Need help?

If you need help with XWiki you can contact: