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
- 270 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 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 2009 Sql 2005 Performance is very Low for huge Data
kishore_rokkam
Member Posts: 5
Hi to all,
We upgrade the Nav4.0 Sp1to 2009 sp1 the problem the SQL db size is 40gb if i open Navision any item form or any table which having data its taking much time. For ex in ledger Entry Dimension we having 61lakhs records it is very Very slow.At the same time before upgradation 4.0 is fine. Can u help me how to increace the perfomance Sql Nav 2009.I done Optimization, Rebuild index in sql even though same problem...Pls help regarding this issue...
We upgrade the Nav4.0 Sp1to 2009 sp1 the problem the SQL db size is 40gb if i open Navision any item form or any table which having data its taking much time. For ex in ledger Entry Dimension we having 61lakhs records it is very Very slow.At the same time before upgradation 4.0 is fine. Can u help me how to increace the perfomance Sql Nav 2009.I done Optimization, Rebuild index in sql even though same problem...Pls help regarding this issue...
0
Comments
welcome to MIBUSO.com
Well, NAV/SQL performance is actually a permanently discussed matter, so I'd like to suggest to search MIBUSO for "SQL Performance" - I'm sure you would get gazillions of useful advices and receommendations.
Performance troubles could have many many reasons, e.g. involving ...
... Hardware/Platform
... used Versions & Editions (OS, SQL, NAV)
... Configuration & Maintenance
... C/AL code and business processes
... etc.
If you could share more details about specific problems you might get more specific answers.
Kind regards,
Jörg
NAV/SQL Performance Optimization & Troubleshooting
STRYK System Improvement
The Blog - The Book - The Tool