Howdy, Stranger!
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
- 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
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 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.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Nav Native DB Performance with Version 6 Client
chrisdf
Member Posts: 82
Hi,
Has anyone noticed a performance issue with the Native Database when simply upgrading the client and server executables from version 5 to version 6? On some customer sites with the native DB split over three disk pairs using version 5 executables the performance is fantastic. We have recently advised a couple of customers to do the same thing (splitting DB over several disks) but in the process we upgraded the executables to version 6. We did not see the same increase in performance that we saw with the V5 client.
Recently I upgraded another customer from V5 executables to V6 executables (single disk) and this customer is now complaining about slow ODBC performance and also slow running of some reports like Aged Receivables.
Apart from the "Native DB is dead" response - is anyone else seeing this and found a solution?? Is it simply the case that V6 executables are much "heavier" on local resources than V5??
Thaks for any feedback on this one!
Has anyone noticed a performance issue with the Native Database when simply upgrading the client and server executables from version 5 to version 6? On some customer sites with the native DB split over three disk pairs using version 5 executables the performance is fantastic. We have recently advised a couple of customers to do the same thing (splitting DB over several disks) but in the process we upgraded the executables to version 6. We did not see the same increase in performance that we saw with the V5 client.
Recently I upgraded another customer from V5 executables to V6 executables (single disk) and this customer is now complaining about slow ODBC performance and also slow running of some reports like Aged Receivables.
Apart from the "Native DB is dead" response - is anyone else seeing this and found a solution?? Is it simply the case that V6 executables are much "heavier" on local resources than V5??
Thaks for any feedback on this one!
0
Comments
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
The classic client server hasn't really changed since the DOS version.
First thing you need to do is run some tests and get some facts. You need to set up before and after scenarios and run timed tests. Making sure that in each before after test you only change one thing at a time.
You are correct that adding drives should make things faster IFF it is done correctly. Maybe the client created 3 LUNs on a SAN. You need to be 100% certain that these are 3 independent RAID 1 arrays each made of two physical dedicated drives.
Personally the remark "advised a couple of customers" doesn't sit well with me. You need to go on site and supervise this to make sure it is done correctly. In the current virtual world, even RDP wont tell the true story.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!