Similar to the previous example, in the event of a memory underestimation, you can force the optimizer to guarantee a minimum memory grant for a query execution using the MIN_GRANT_PERCENT query hint. It also accepts float values between 0.0 and 100.0. Be very careful with this hint, since if you specify 100% as the minimum grant, the whole resource governor memory will be granted to a single query execution. If you specify more memory than is available, the query will simply wait for the memory grant.
Using MIN_GRANT_PERCENT
Get SQL Server 2017 Developer's Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
