Summary

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

Details

Page properties

Content

...	...	@@ -2,3 +2,26 @@
2	2
3	3
4	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	+
	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	+
	10	+|Max number of databases per instance|100 user databases, unless the instance storage size limit has been reached.
	11	+|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.
	12	+|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.
	13	+|Data/Log IOPS (approximate)|500 - 7500 per file
	14	+*[[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]]
	15	+|Max sessions|30000
	16	+|Max concurrent workers|105 * number of vCores + 800
	17	+| |
	18	+
	19	+
	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	+|IOPS per file|500|2300|5000|7500|7500|12,500
	22	+|Throughput per file|100 MiB/s|150 MiB/s|200 MiB/s|250 MiB/s|250 MiB/s|250 MiB/s
	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]]