To prevent memory grant (excessive) problems I want to change my DB compatibility level to 150
How can I be sure I won’t have a problem ?
Is there any script/tool to check my DB for 150?
Below are the methods you can try. The first solution is probably the best. Try others if the first one doesn’t work. Senior developers aren’t just copying/pasting – they read the methods carefully & apply them wisely to each case.
The recommended process to increase your database compatibility level is documented here:
Change the Database Compatibility Level and use the Query Store
All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0