Azure SQL MI Question (tempdb issue)

  • imani_technology

    SSCertifiable

    Points: 7983

    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?

  • Site Owners

    SSC Guru

    Points: 80385

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply