Performance problem using NAV Three Tier
blopez
Member Posts: 16
Hello,
I have a performance problem using NAV Three Tier in a Job.
First, I´ll try to explain how is the architecture. We are using NAV three tier for communicate a web shop with a sync Bridge developed on .NET, who calls NAV using web service.
Currently we are using two types of webservice, for create a correct structure for us, who is a Contact, Customer and Vendor and an Sales Order for the users who are logged on our web (we send a gift to logged users, and customer wants these data reflect in NAV).
Services published are:
1) The page webservice, publish contact card, and NET use it for made an insert.
2) The codeunit webservice, has 3 methods published, one to inser customer, one to insert vendor, (relating both to the contact), and one who makes the sales order with one line with the gift (not posted, only insert).
These Web services are called in order. After The reason for this post, is the next:
- When we make consecutive calls to generate 5000 users, calling all the services, all goes ok.
- When we make consecutive calls to generate 27000 users, calling all the services, problems occur, like cursor error ID:24000, deadloks, etc...also the SQL Server memory occupied by progressively lower until the server crashes.
Currently, we are using SQL Server 2008 with 4Gb RAM. How can we solve this problem? too many records?
Thanks,
I have a performance problem using NAV Three Tier in a Job.
First, I´ll try to explain how is the architecture. We are using NAV three tier for communicate a web shop with a sync Bridge developed on .NET, who calls NAV using web service.
Currently we are using two types of webservice, for create a correct structure for us, who is a Contact, Customer and Vendor and an Sales Order for the users who are logged on our web (we send a gift to logged users, and customer wants these data reflect in NAV).
Services published are:
1) The page webservice, publish contact card, and NET use it for made an insert.
2) The codeunit webservice, has 3 methods published, one to inser customer, one to insert vendor, (relating both to the contact), and one who makes the sales order with one line with the gift (not posted, only insert).
These Web services are called in order. After The reason for this post, is the next:
- When we make consecutive calls to generate 5000 users, calling all the services, all goes ok.
- When we make consecutive calls to generate 27000 users, calling all the services, problems occur, like cursor error ID:24000, deadloks, etc...also the SQL Server memory occupied by progressively lower until the server crashes.
Currently, we are using SQL Server 2008 with 4Gb RAM. How can we solve this problem? too many records?
Thanks,
0
Comments
-
I would recommend a buffer between the webshop actions and NAV. A buffer table in the webshop db with the records to synchronize. And when records are found in this table to call the webservice at periodic intervals. (it's probably one record at a time, so anything between 10 and 100 ms should be sufficient. See the logs for the 5000 users to determine this interval).
So that no matter how many users are on the website (1 - 1.000.000) the locks in NAV are reduced to a minimum. This because the load is not linked to the users on the website.0 -
Hi,
Did you get a resolve for this? I have issue i've posted regarding concurrent calls to web services and wonder if it could be related.
Cheers
Scott0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K 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
- 328 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