[FEATURE] Don't rely on sys.databases.is_query_store_on

[HenrikHoyer]

Which component(s) does this affect?

• Full Dashboard
• Lite
• [dont know] SQL collection scripts

Problem Statement

Sometimes the info in sys.databases.is_query_store_on is out-of-sync with reality. I have today experienced it on some Azure databases (were you cannot disable the query_store) reporting is_query_store_on = 0

Proposed Solution

I suggest to use the information in sys.database_query_store_options to enable/disable the dashboard features that requires the datastore.

See this for inspiration: BrentOzarULTD/SQL-Server-First-Responder-Kit#2525