Blog Post

Azure SQL Blog
5 MIN READ

Configure your TempDB max size in Azure SQL Managed Instance

NevenaNikolic's avatar
NevenaNikolic
Icon for Microsoft rankMicrosoft
Jan 13, 2023
In September 2022, we announced the option to configure the number of TempDB files and their growth increments. For more details, read Improve your SQL Managed Instance performance with new TempDB co...
Updated Jan 13, 2023
Version 4.0
azure sql
azure sql managed instance
sql server
IoanaDev's avatar
IoanaDev
Copper Contributor
Jan 24, 2024

Hi, I am trying to increase the data files for our Azure Managed Instance database and I am getting error 
41946 SQL Database Managed Instance does not support modifying default size of TempDb files.

What could it be? Why is it not working?