February 6, 2019 at 2:25 pm
I have query store turned on for several of my db's on a AG node. New database added last week turned on query store for it. After a week went to look at data all empty, none of the standard views show anything.(and yes transactions being written to this db) anyone seen this I can't find a setting (it is in read only which is all my query store db's which return data)
February 7, 2019 at 4:54 am
The database is Read Only?
Hmmm. I haven't tested that. I'll get on it. Thanks for the blog post idea.
Now, what are all the Query Store settings? It's likely that there's a setting that's inappropriate.
"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
February 7, 2019 at 5:03 am
sorry may have found it query store was set to read only not read write, database is regular oltp database
February 7, 2019 at 5:33 am
Ah, yeah, if the Query Store is read only, it sure won't be collecting data. I'm still going to test what happens when the database itself is read only. I have a guess, but I don't know.
"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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply