Post reply

Query Store not collecting?

  • January 9, 2019 at 8:54 am

    #370058

    Ive got a 2016 instance with Query Store enabled on it. its in Read_Write requested and actual mode.
    It worked for a while. but somewhere along the line (I'm embarrassed to say how long ago) it simply quit collecting.
    There is free space in the query store allocation for the database so its not a matter of it being full (and if it was fully, it'd have switched to a read_only actual mode). 

    I dont see any errors or reasons for it. the servers been restarted since then. ive also disabled and reenabled Query Store to no effect. Ive searched and see nada on this condition... anyone else encountered this?

    Thanks in advance!

  • January 10, 2019 at 7:01 am

    #2018520

    I have not seen this behavior. Is the size allocated smaller than the actual size? I've seen that cause problems. Try flushing it to see if that clears the collection. It usually just works.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • January 10, 2019 at 8:03 am

    #2018528

    Grant Fritchey - Thursday, January 10, 2019 7:01 AM

    I have not seen this behavior. Is the size allocated smaller than the actual size? I've seen that cause problems. Try flushing it to see if that clears the collection. It usually just works.

    it was set to 1000mb, it shows 800mb used. I increased it to 3000 and no change.

    just noticed though... shows query store used of 800mb and query store available as 2.1gb. it was 1000mb before i changed it to 3000mb. the 'purge query data' button asks me to confirm and then does nothing:

  • January 10, 2019 at 11:00 am

    #2018597

    Yeah, and you're in "all" and "auto" for the capture... Maybe change the capture mode. Auto only captures queries that are called more than three times or run longer than... I think it's 1 second? I forget. Anyway, Auto might be masking some of the behavior.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • January 10, 2019 at 11:04 am

    #2018599

    thanks Grant! 🙂

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply