Summary

• Page properties (2 modified, 0 added, 0 removed)

Details

Page properties

Parent

...	...	@@ -1,1 +1,1 @@
1		-technical-documentation.analysis.sql.WebHome
	1	+Technical Documentation.analysis.WebHome

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,20 @@
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	21
22		-* 20 minutes to start up when stopped
23	23
	25	+backups
24	24
25		-== backups ==
26		-
27	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	28
29	29
30		-[[GitHub - JocaPC/qpi: Query Performance Insight - analyze performance of your SQL Server Database Engine>>url:https://github.com/JocaPC/qpi]]
31	31
32	32
33	33
	33	+storage acccount with storage container
34	34
35		-storage acccount with storage container [TDE must be turned off - encrypting key must be dropped!]
36		-
37	37