Execution Plan

  • Grant Fritchey

    SSC Guru

    Points: 396757

    Admingod wrote:

    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

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

Viewing post 16 (of 16 total)

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