Navision Performance

DynamicUser
Member Posts: 177
HI
My Client is having a Navision 4.0 with SQL Server 2000 And they have very serious problem with performance i was studying the Pdf that is related with performance issue they suggest some fobs
Like
Session Monitor (Navision Server)
Session Monitor (SQL Server)
Activity Log
Sample use of activity log
Client Monitor
From Where i get this ?
or suggest some simple way to solve this issue.
My Client is having a Navision 4.0 with SQL Server 2000 And they have very serious problem with performance i was studying the Pdf that is related with performance issue they suggest some fobs
Like
Session Monitor (Navision Server)
Session Monitor (SQL Server)
Activity Log
Sample use of activity log
Client Monitor
From Where i get this ?
or suggest some simple way to solve this issue.
0
Comments
-
You will get it from Microsoft partner source website.Anil Kumar Korada
Technical Consultant0 -
The tools you mentioned are known as the "Performance Troubleshooting Tools". IMHO these tools are not quite feasible to investigate and further optimize the performance of a NAV on SQL Server system, as the results could be somewhat "misleading".
If you are looking for NAV based utilities, you should consider the "NAV SQL Server Option Resource Kit" - also available via Partner Source.
According to this, I recommend to use the "Windows Performance Monitor" and "SQL Profiler".Jörg A. Stryk (MVP - Dynamics NAV)
NAV/SQL Performance Optimization & Troubleshooting
STRYK System Improvement
The Blog - The Book - The Tool0 -
... and: if you search these forums for "SQL Performance" you will get TONS of useful advice!Jörg A. Stryk (MVP - Dynamics NAV)
NAV/SQL Performance Optimization & Troubleshooting
STRYK System Improvement
The Blog - The Book - The Tool0 -
I am not getting "NAV-SQL Server OPtion Resource Kit" on partnersource. Can you send me the link.0
-
-
Here the Partner Source Link https://mbs.microsoft.com/downloads/partner/navisionna/Microsoft_Navision_SQL_Resource_Kit.zipJörg A. Stryk (MVP - Dynamics NAV)
NAV/SQL Performance Optimization & Troubleshooting
STRYK System Improvement
The Blog - The Book - The Tool0 -
stryk wrote:Here the Partner Source Link https://mbs.microsoft.com/downloads/partner/navisionna/Microsoft_Navision_SQL_Resource_Kit.zip
Is this the last version? Maybe someone know if Microsoft have plans to update resource kit? :roll:0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions