Query Store and NAV Performance

mcoscas
mcoscas Member 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 Member Posts: 1,690
    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
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03

Categories