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
- 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
NAV 5SP1 Very Slow on SQL Server 2008
Kim
Member Posts: 85
Hi guyz;
I don't know whether anyone has experienced this problem. We have implemented NAV5SP1 running on SQL 2008 to one of our
clients and the system has become very slow 1 year down the line.
We have implemented Financials,Sale & Marketing, Purchases, Warehouse, Manufacturing, Inventory
Management and Human Resources.
Retrieving any of the inventory reports has also become a major challenge.
Am wondering how we can improve the speed since we have tried to optimize sql and also ensuring the transaction log file does not grow that much and there appears to be no change.
I don't know whether anyone has experienced this problem. We have implemented NAV5SP1 running on SQL 2008 to one of our
clients and the system has become very slow 1 year down the line.
We have implemented Financials,Sale & Marketing, Purchases, Warehouse, Manufacturing, Inventory
Management and Human Resources.
Retrieving any of the inventory reports has also become a major challenge.
Am wondering how we can improve the speed since we have tried to optimize sql and also ensuring the transaction log file does not grow that much and there appears to be no change.
0
Comments
What matters on the client side (NAV) is the quantity of modifications made and their quality.
In your case my guess would be that the DB has grown over the year and your keys/indexes are not set up or used according to data query needs.
You should consult a nav/sql pro to look into your case.
Search this forum for some ideas.
To start : do you do a regular rebuild index?
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
You can download SQL optimization manual on the Partnersource site. It has a lot of helpful ways to increase performance.
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book