Post reply

Query Store with AOAG stuck on waiting

  • July 1, 2024 at 5:51 pm

    #4432755

    Hey Folks,

    I have a database on SQL 2019 CU24 in an AOAG with 1 primary and 2 secondary.  I have enabled Query Store but it will not open and just shows Waiting on the primary.

    I have QS setup on standalone SQL 2016 databases and they seem to be working fine.

    Any help is appreciated.

  • July 2, 2024 at 12:05 pm

    #4432930

    Sounds like you're trying to enabled Query Store on the secondaries. That's only available in SQL Server 2022, not 2019. Here you go.

    "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

  • July 2, 2024 at 12:22 pm

    #4432932

    No, I only enabled it on the primary and trying to open it in the primary.

Viewing 3 posts - 1 through 2 (of 2 total)

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