Query Store and NAV Performance

mcoscas
mcoscas Posts: 34
in SQL Performance
Hi everybody,

Does someone know if the activity of the Query store can cause performance problems in NAV 2017 ? Our customer is suffering from performance problems for a few weeks and we suspect that the query store is the origin of the problem...

Thanks in advance for your reply.
M.

Answers

  • Slawek_Guzek
    Slawek_Guzek Posts: 1,692
    As in most general questions about SQL Server performance problems the answer is 'it depends'.

    In this articular case it depends on type of activity - if customer's SQL Server is bombarded with thousands relatively simple queries per second then the Query Store might potentially have some noticeable impact.

    But in a real life NAV data access patterns the Query Store performance penalty is highly unlikely to be noticeable.


    Slawek Guzek - www.yitron.co.uk
    Business Central, MS SQL Server, Wherescape RED;

Categories