QuestionQ89

VerifiedMonitor, configure, and optimize database resources

You have an Azure SQL Managed Instance called MI1.

You need to configure automatic tuning for MI1's databases.

What should you do?

Explanation

For Azure SQL Managed Instance, the supported automatic-tuning capability is automatic plan correction through FORCE_LAST_GOOD_PLAN, and it must be configured by using Transact-SQL. Azure portal-based automatic-tuning configuration and the REST API configuration described for Azure SQL Database do not apply to Managed Instance.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!