Trying to understand commit cache and performance

Huysmans
Member Posts: 13
Recently we tried to figure out if there was a risk in activating the commit cache. It seems impossible to get a description as to how this cache works. Talking to my NSC I got the impression that it is fairly safe to use it but I'm still not sure. What if the server crashes while there is still some data in the cache? What information is stored in commit cache? And in what order is this information written to disk?
Anyway, performance is such an issue we decided to activate commit cache.
Nice thing is we have a tool (client side report) which merely uses the disk performance tool to write the read/write times to a logfile.
And now, the curious part:
While I'm at it; anyone suggestions for some good reading on Navision performance tuning?
So far I've been looking into "Installation & System management" (w1w1ism.pdf) and of course this forum.
Anyway, performance is such an issue we decided to activate commit cache.
Nice thing is we have a tool (client side report) which merely uses the disk performance tool to write the read/write times to a logfile.
And now, the curious part:
- Before using commit cache:
- read avg: 7 msec (with peaks up to 30 msec)
- write avg: 9 msec (with peaks up to 100 msec)
- After enabling commit cache:
- read avg: 9 msec (with peaks up to 30 msec)
- write avg: 19 msec (with peaks up to 100 msec)
While I'm at it; anyone suggestions for some good reading on Navision performance tuning?
So far I've been looking into "Installation & System management" (w1w1ism.pdf) and of course this forum.
0
Comments
-
Look for Performance Troubleshooting Guide which include some objects and documentation w1w1PerfTGuide.pdf. Objects can be used only with apropriate licence (it is in range 100000...). This guide is included on Navision Tools CD...0
-
I have noticed the positive influence of it when I compile all objects.
That commit cache parameter is a great difference. You do not need a stopwatch to notice that.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