Troubleshooting SQL Queries Generated by Dynamics NAV


The documentation on Optimizing SQL Server Performance with Microsoft Dynamics NAV has been updated with information about:

  • Troubleshooting long running SQL queries involving FlowFields by disabling SmartSQL.
  • Using SQL Server 2016 Query Store to monitor query performance in Dynamics NAV.

 

Read more at
https://msdn.microsoft.com/en-us/dynamics-nav/optimizing-sql-server-performance-with-microsoft-dynamics-nav

 

Please get back to us if you miss documentation around running Dynamics NAV on SQL Server (just comment below).

Comments (11)

  1. Yevhen Nedashkivskiy says:

    Hi guys. How I can configure read-only routing for an availability group with NAV?

    1. Dear Yevhen Nedashkivskiy,

      AlwaysOn availability groups are not officially supported in NAV, even though we have customers and partners who use this feature in production. We cannot distinguish read-only vs. read/write traffic in the server platform, and therefore you cannot configure read-only routing to secondary replicas from Dynamics NAV

  2. nice, fast solution to detect bottlenecks for thought wrong flowfields.

  3. How about a Guide to Handle the NAV User Id from the Full SQL Tracing?

    1. Good idea. Added to my backlog of possible documentation changes

  4. Pallea says:

    I jstu dont get this code:

    Customer.SETFILTER(Customer.Balance,’>%1’, LargeCredit);
    IF Customer.FINDSET() THEN REPEAT
    Customer.CALCFIELDS(Customer.Balance)

    To my opinion it breaks all rules. Setting a filter on a field that has not yet been calculated, then return ALL records and THEN calculate the field-value. How can that be fast ??

    1. Hi Palle,

      Help me out on context here. Where did you see that code snippet?

        1. Judith says:

          HI Pallea: Hello I need help please. I’m posting the bank reconciliation on Navegator. I ran the test report and when try to post it I got a message that say “The posted bank rec header already exists. Identification field and value. Bank Account No XXXX Statement no xxx

  5. Judith says:

    Hello I need help please. I’m posting the bank reconciliation on Navegator. I ran the test report and when try to post it I got a message that say “The posted bank rec header already exists. Identification field and value. Bank Account No XXXX Statement no xxx

    1. Pallea says:

      Hi. You should ask the question here: https://community.dynamics.com/nav/f/34 or at https://dynamicsuser.net/

      Thanks
      PalleA

Skip to main content