This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 61%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHE%3C/text%3E%3C/svg%3E)
Wanted to know if the limit of 100 databases on a SQL MI includes that system tables or if it is just databases you added.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 79%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Hi Homan, Eric,
As per Microsoft document Resource limits - Azure SQL Managed Instance | Microsoft Learn
The maximum number of databases per instance is 100 user databases (specifically mentioned), which seems to be excluding system databases.
Thank you!
That is what I thought but wanted to make sure I was reading it the same way. Thank you
Hi Homan, Eric,
Well to prove that I have created 100 user databases in on my managed instance.
So total number of database is 104. Which means 100 user database and 4 system database. I am getting error for 101 user database.
I hope this helps 😊
The limit of 100 databases on a SQL Managed Instance (MI) includes the system tables. The system tables are the tables that are used by SQL Server to manage the database itself, such as the sys.databases table and the sys.tables table. These tables are required for the SQL MI to function properly, so they cannot be deleted or removed.
If you create more than 100 databases on a SQL MI, you will receive an error message. You can either delete some of the databases or create an elastic pool to manage the resources of multiple databases.