NAV SQL Trace Analysis

Administrator
Administrator Member, Moderator, Administrator Posts: 2,506
edited 2015-03-12 in Download section
NAV SQL Trace Analysis
This tool analyzes a SQL Trace created from a Microsoft Dynamics NAV database using SQL Server Profiler.

It will show how many times each table has been read and written to. I will also show each transaction in detail, including the values used for INSERT and UPDATE statements.

Based on the table License Permission (2000000043), it will also check if the transactions in the trace pass the Limited User write test. When the license contains add-on(s) with special Limited User write permissions, these are taken into account.

http://www.mibuso.com/dlinfo.asp?FileID=1641

Discuss this download here.

Comments

  • tinoruijs
    tinoruijs Member Posts: 1,226
    I saw this will only work in NAV 2015.
    Option "Scope=repeater" is not allowed.
    :-k
    Will have to upgrade the client I guess.
    Tino Ruijs
    Microsoft Dynamics NAV specialist
  • tinoruijs
    tinoruijs Member Posts: 1,226
    I deleted the fields in the page which contained the scope=repeater and am trying to get it to work in NAV 2013 R2.
    Unfortunatly I'm getting a message;

    Microsoft Dynamics NAV Development Environment
    Type 'PeterTijsma.JS.HtmlView;PublicKeyToken=df97a45b18e41732' kan niet worden geladen.
    OK



    And NAV crashes and the following error occurs.
    Microsoft Visual C++ Runtime Library
    Runtime Error!

    Program: C:\Program Files (x8...

    R6025

    - pure virtual function call

    OK


    So maybe I should stop here? :-k
    Tino Ruijs
    Microsoft Dynamics NAV specialist
  • tinoruijs
    tinoruijs Member Posts: 1,226
    Error is:
    Microsoft Dynamics NAV Development Environment
    Could not load type 'PeterTijsma.JS.HtmlView;PublicKeyToken=df97a45b18e41732'.
    OK

    Add-in is present and import .zip is succeeded.

    Will probably not work on NAV2013R2.
    Tino Ruijs
    Microsoft Dynamics NAV specialist

Categories