Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.7K 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
- 317 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K 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
Client Monitor SQL
wheresjustin
Member Posts: 26
Hi,
Upon reading the document "Tuning Navision for Better Performance" revision 5, I tried to use the Debug tools (Code Coverage, Client Monitor, etc) version DEBUGW13.10.01 to check the table locking orders were correct for customer modifications made to various posting code units.
The system I was checking was Nav V4.00 with SP1 (and the CU12 HotFix) running on MS SQL.
Has anyone ever used checked the table locking order of various code units? If, so can you explain the process better than the brief explanation in the above mentioned document (Can be found in the Mibuso downloads).
Does anyone have a better list of the table locking orders that should be used for standard Nav tables?
Is there a more upto date version of the debug/performance tools to DEBUGW13.10.01 ?
Justin
Upon reading the document "Tuning Navision for Better Performance" revision 5, I tried to use the Debug tools (Code Coverage, Client Monitor, etc) version DEBUGW13.10.01 to check the table locking orders were correct for customer modifications made to various posting code units.
The system I was checking was Nav V4.00 with SP1 (and the CU12 HotFix) running on MS SQL.
Has anyone ever used checked the table locking order of various code units? If, so can you explain the process better than the brief explanation in the above mentioned document (Can be found in the Mibuso downloads).
Does anyone have a better list of the table locking orders that should be used for standard Nav tables?
Is there a more upto date version of the debug/performance tools to DEBUGW13.10.01 ?
Justin
0