October 17, 2020 at 4:47 pm
Thanks. Can you comment on Query store, Forced a good plan with query store and left query store on to capture all. So far the server is operating well. Would you think this would help for the cause of high CPU. I have query store max size of 100MB. What happens if the query store reach to max size. Would there be any impact to database other than the collection of data?
If you have auto-cleanup enabled, query store will remove data. If not, it'll fill up and stop collecting. It won't hurt the server more than it already is. Query Store does a little bit of overhead, but for most people in most situations, nothing radical. You can turn on Query Store, but turn off data collection. That allows you to still do plan forcing if you want, but without the overhead of the data collection.
"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 post 16 (of 15 total)
You must be logged in to reply to this topic. Login to reply