Query Store - why is my query not in top resource consumers

• DamianC

  SSCrazy Eights

  Points: 8015

  More actions

  October 20, 2019 at 4:42 pm

  #3690452

  Hello

   

  I've been playing around with some of the out-of-the-box Query store reports

  I have no problem using the standard Query Store views against queries that have been run, amount of times, plans, executions etc.

  I just struggle to find the detail in the standard reports

  I can see details if I know the object and track it

  If not, more often than not the query doesn't show up

  As an example, if I set the top resource consumer to show all and run it, my query is not there

  Although, occasional a user query will appear

  I can run the query multiple times (use go 50, for example) and look at this by executions - still nothing

  There are some queries showing

  Why can't I see everything?

   

  Thanks

   

   

  - Damian

• Site Owners

  SSC Guru

  Points: 80320

  More actions

  October 21, 2019 at 5:10 pm

  #3690684

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.