We are getting following error while dumping data from Databricks into SQL MI.
"Error : Could not allocate space for object 'dbo.SORT temporary run storage: 140799153471488' in database 'tempdb' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup."
Please bear in mind, we cannot set how many files or maximum size for TempDB in Azure SQL Managed Instance, it just isn't supported.
We did run the truncate command, but we got this error afterward:
"The transaction log for database 'tempdb' is full due to 'ACTIVE_TRANSACTION'."
So, how might we fix the problem, given the peculiarities of Azure SQL Managed Instance?