Compatibility level check



  • 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?



  • The recommended process to increase your database compatibility level is documented here:

    enter image description here

    https://docs.microsoft.com/en-us/sql/database-engine/install-windows/change-the-database-compatibility-mode-and-use-the-query-store?view=sql-server-ver15




Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2