July 1, 2024 at 5:51 pm
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
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
No, I only enabled it on the primary and trying to open it in the primary.
July 4, 2024 at 9:05 am
Hm,
I just tried to activate the query store, and everythings works fine.
But I got the CU27. Maybe you should install the latest CU and check this issue again.
Best regards,
Andreas
July 5, 2024 at 12:08 pm
Thank you for checking.
July 8, 2024 at 3:00 pm
Update:
Looks like it's taking around 45min to an hour for the panels to show data. Still can't figure out what's causing the delay.
July 8, 2024 at 3:28 pm
That sure doesn't sound normal. And this is related to the initial question?
"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 8, 2024 at 5:07 pm
yes
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply