Getting Around Error 40510 to Configure Resource Governor in Azure SQL Managed Instance

This site does not allow itself to be embedded. You can still read it on the original site — the toolbar below keeps your place in the directory.

One feature I’ve not appreciated enough in the past in SQL Server is Resource Governor. Resource Governor allows you to fix problems with Memory Grants in a simple way, as Erik Darling recommends . It also lets you classify sessions into groups and limit the maximum number of simultaneous requests , and /or limit the degree of parallelism if you need more CPU for other workloads. While this…

Read on kendralittle.com ↗