Allow Memory Grant Percent To Be Set In Standard Edition
In 2016 SP1 we got many features handed down to Standard Edition, but Resource Governor was not one of them.
In Enterprise Edition, Resource Governor is frequently used to reduce the maximum memory grant percent down from 25. That prevents queries that you don't have control over from totally trashing your server. Since memory grant feedback is not available in Standard Edition, users aren't left with many options. Query hints are nice, but only if you can change the queries.
Max grant percent should be either settable in Standard Edition, or decoupled from Resource Governor and settable at the database or server level.
Chris Wood commented
Lets make it a database setting in both Enterprise and Standard Edition
Gabriele D'Onufrio commented