Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 267 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
NAV SQL Trace Analysis
Administrator
Member, Moderator, Administrator Posts: 2,496
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.
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.
0
Comments
Option "Scope=repeater" is not allowed.
:-k
Will have to upgrade the client I guess.
Tino Ruijs
Microsoft Dynamics NAV specialist
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
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