NAV - SQL slow performance

Developer101
Member Posts: 569
The users are using a classic client customized form and perform queries on it.
This form is basically looking at two ledger entries tables. So when the users enter a value then it queries customer ledger table and other ledger table same time.
This is slow. There always been users performing queries on Customer ledger entries form directly to look for posted invoices etc. While there are other uses who post invoices. Is it fine to let the users query customer ledger entries form? Or there can be better way please help?
This form is basically looking at two ledger entries tables. So when the users enter a value then it queries customer ledger table and other ledger table same time.
This is slow. There always been users performing queries on Customer ledger entries form directly to look for posted invoices etc. While there are other uses who post invoices. Is it fine to let the users query customer ledger entries form? Or there can be better way please help?
United Kingdom
0
Comments
-
Troubleshooting 'slowness' is always a pain in the beginning because there are so many paths to go down.
It sounds like you have your performance issue narrowed down to specific actions and specific tables.
using sp_configure to force SQL Server to create a new execution plan may help.
as far as other dev options for your customer ledger tables that's not my forte.
SQL Server is however my forte and you'll want to make sure to have your SQL Server optimized for NAV.
0 -
We updated the MSDN documentation on SQL Server setup and configuration two months ago:
https://msdn.microsoft.com/en-us/dynamics-nav/installation-considerations-for-microsoft-sql-server
Maybe there is something in there that you can use.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