Object ID in query_store_query DMV doesn't exist? Where'd it go?

Question

I'm querying the query store DMVs directly but the object_id in the query_store_query DMV is returning a value that can't be found. It isn't 0 so why does it return a value that doesn't seem to exist? Could this be due to the fact some queries are coming from Entity Framework and is creating temporary objects? Clutching at straws here. Any help is appreciated.

Answer 1

An obvious reason is that the object in question have been dropped. But I don't think Entity Framework creates temporary objects.

Something I haven't tested, but what if there is a query that calls a function in a different database? How is this recorded? (If you make a call to a stored procedure in a different database, I would expect that call to be recorded in Query Store for that database.)

Answer 2

You'd think it was obvious, eh, but this was after load testing on the database in question, with no changes to either tables, stored procs, UDFs, etc. No cross-database functionality at all.

It's left me scratching my head as to what's going on.

Answer 3

Maybe you should re-run the load test, but now with a DDL triggers that logs eventdata()? to a table?

When you look up a plan in sys.dm_exec_plan_attributes, you will find an objectid also for ad-hoc queries, which is the internal hash of the query text. However, I don't think think this hash is saved to Query Store, and nor does the documentation suggest that this is the case.