May 21, 2021 at 11:06 am
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?
May 21, 2021 at 8:16 pm
Hi, error message is clear 🙂 but you can confirm this with Azure support team.
May 22, 2021 at 12:01 pm
Thankyou, Do you happen to have any links for whitepaper on Azure Managed Instance (like best practices and guidelines for db setup).
July 16, 2021 at 2:17 am
This was removed by the editor as SPAM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply