🔥 3-day streak
Microsoft Azure Database Administrator Associate39 / 144
Question 39 of 144
You administer an Azure SQL Managed Instance running an OLTP application. Monitoring shows the plan cache is consuming a large amount of memory, and DMV queries reveal thousands of single-use (adhoc) compiled plans, each with a usecounts value of 1. Available memory for the buffer pool is being squeezed, causing increased physical reads. You want to reduce the memory wasted by these single-use plans with minimal application changes. Which configuration should you apply?
Reviewed for accuracy · Report an issueNext question