Purchase Credit Memo Speed Problem
Mally
Member Posts: 128
Dear Concern
I m having NAV 4.0 SP3 SQL DB,When I posting Purchase Credit Memo of 200 Lines then it takes approx. 2Hours to post (SQL DB) and all functionalities except this is running fine but I do this process (Same DB) in native DB with same no. of lines then it is running smoothly Post PO Credit memo 1 Minute. Whats the problem? I didnt understand?
I m having NAV 4.0 SP3 SQL DB,When I posting Purchase Credit Memo of 200 Lines then it takes approx. 2Hours to post (SQL DB) and all functionalities except this is running fine but I do this process (Same DB) in native DB with same no. of lines then it is running smoothly Post PO Credit memo 1 Minute. Whats the problem? I didnt understand?
0
Comments
-
The problem is may be HW, may be SW, may be missing know-how... but who knows, you gave us only 1% of information about the system -> it is slow and it is NAV 4.00SP3... ;-)
Just search the forum for SQL optimization posts, there are plenty answers etc.0 -
Dear Expert
Slow functionality is when we post Purchase credit memo and all functionalities r running fine.But when we ran it on Native DB it is running fine.Please tell me that why slow speed problem comes only when we r posting purchase credit memo.Whne I doing any other posting then it is running fine................0 -
Than you need to use correct tools to check what is the problem, but this is more complex task to just describe it in one post. Search the forum, learn how to do performance checks, how to use client monitor to find out what is the problem, how to use SQL Profiler etc...0
-
Dear concern
Whats the exact solution for my problem? I didnt find any thing related to my problem,Bcoz my problem is different from other SQL Performance issues.0 -
Mally wrote:Dear concern
Whats the exact solution for my problem? I didnt find any thing related to my problem,Bcoz my problem is different from other SQL Performance issues.
No, it isn't different. And there is no exact solution when we do not know what exactly the problem is. You need to do some research on the problem to find out the bottleneck or you need to hire someone who knows how to do that. If you want to do it for free, learn how to use tools I mentioned, after you will know where the problem is, we can help you to solve this problem.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