Memory-optimized tempdb

• cooldude001

  Mr or Mrs. 500

  Points: 528

  More actions

  May 21, 2021 at 11:06 am

  #3886262

  I'm getting an error trying to enable in-memory setting for tempdb in Azure Managed Instance.

  Exec sp_configure 'tempdb metadata memory-optimized', 1;

  reconfigure

  Error:

  "Tempdb metadata memory optimized option is not supported in SQL Managed Instance".

  I couldnt find any msdn link saying that this setting is not supported in Azure SQL Database/MI. Is there a work around to enable this setting in MI?

• e4d4

  SSCertifiable

  Points: 5777

  More actions

  May 21, 2021 at 8:16 pm

  #3886524

  Hi, error message is clear 🙂 but you can confirm this with Azure support team.

• cooldude001

  Mr or Mrs. 500

  Points: 528

  More actions

  May 22, 2021 at 12:01 pm

  #3886713

  Thankyou, Do you happen to have any links for whitepaper on Azure Managed Instance (like best practices and guidelines for db setup).

  • This reply was modified 3 years, 7 months ago by  cooldude001.

• July 16, 2021 at 2:17 am

  This was removed by the editor as SPAM