The database that I'm working on unfortunately has a lot of functions, with select statements in them, that are heavily used in where clauses in multiple stored procedures. This is not good design or good for performance, obviously.
Let's say one of the functions is named ObjectAccessGet. It comes up first when I run the Query Store "top resource consuming queries" report, in CPU and Logical Reads.
I'm trying to answer the question: "Of the stored procedures that call the function ObjectAccessGet, which ones are causing ObjectAccessGet to be used the most?
This will then determine WHICH of the stored procedures that call ObjectAccessGet that I will fix first.
I'm happy looking directly at the underlying tables (for instance sys.query_store_runtime_stats, etc).