Go back to all articles

Load Testing for Microsoft Dynamics NAV System

Jul 8, 2020
4 min read

Testing Object:

Microsoft Dynamics NAV is a customized system that automates accounting and document processing.

It consists of a thick client, a server application, and a database (mssql).

Testing Goals:

  • Performing the initial system load testing.
  • Comparing the runtime for three different system configurations.
  • Testing scenarios only achieved demonstration and creation of the advance payment reports with different contents in different configurations.
Want to Learn More About Our Performance Testing Services?
Find out what’s included and how to start working with us.

The Following Tasks Were Achieved during the Project:

  • filling in the DB with the test data;
  • deploying the Telegraf+Influx+Grafana monitoring, including transaction monitoring from Grafana scripts;
  • developing load testing scripts using .net protocol in LoadRunner;
  • developing a separate C# application that uses Microsoft Dynamic NAV API client;
  • query monitoring configuration using Canape.

The final testing was performed using a free LoadRunner license; we used 8 hosts with 50 threads each and wrote a proprietary automatic metric collector.

We Faced the Following Problems:

  • As the client-server communication was performed using the proprietary msbin1 protocol, it was not possible to intersect the traffic with the regular tools such as LR, Fiddler or wireshark. Queries and responses have been monitored only through the application log and Canape.
  • We did not have documentation on Microsoft Dynamics NAV API, and Microsoft support did not send it to us on request.
  • We could not solve the problem with the correlation of an encrypted binary field with the data while calling a write command in the DB. In the final script version, the writes in the DB were performed with a direct SQL injection, skipping the application server.
  • A similar problem arose when using the Microsoft Dynamics NAV API.
  • As the free LoadRunner version limits the session amount, we had to write a proprietary metrics collection system regarding the transactions in scripts from different hosts through Influx+Grafana.

Results

  • The customer received an initial evaluation on system runtime for different configurations.
  • The discovered errors required DB table blocking, session terminations, etc. until eliminated.
  • PFLB gained experience with the Microsoft proprietary solutions based on Microsoft Dynamics.
Table of contents
Let us know about your needs
We can provide multiple performance testing services and a lot more than that if the situation needs a far more complex approach.
Get a quote You’ll hear back from our tech account manager in one day if not sooner

Related insights in case studies

Explore what we’ve learned from these experiences
8 min read

How Load Testing Helped Texans Survive Power Outages During a Storm

how pflb helped texans survive power outages during a storm preview
Jun 13, 2024

One of the largest electric distribution company in Texas that serves over 100,000 people, ensuring an uninterrupted power supply. To maintain service quality during weather-related power outages, it must comply with the Texas Reliability Entity, which ensures energy providers’ reliability and security. To provide clients with reliable service, the company deployed Storm Center and the […]

4 min read

Tynor Prepared the New Website for High Sales in Four Days

tynor prepared the new website for high sales in four days preview
Dec 12, 2022

Tynor Orthotics is India’s largest manufacturer and exporter of orthopedic and fracture aids established in the 90s to deliver quality healthcare products. Committed to a significant expansion in the next three years, Tynor crafted a new e-commerce website focused on excellent customer experience to support this growth. To be confident at launch, the engineering team of Tynor decided to run pre-go-live stress testing for the website. The tight deadline felt challenging, the customer was relieved to hear we provide a quick load testing solution. Quick Load Testing solution includes a four-day load testing project performed by engineers of PFLB and a 1-month subscription to the innovative load testing PFLB platform.

5 min read

Bank Increases Load Capacity by 450% to Deal with Business Growth

bank increases load capacity by 450 to deal with business growth preview
Oct 3, 2022

Our client's bank was absorbing other banks, and the number of individual clients was growing. The system was not ready for expansion or integration. The owners started to suspect bottlenecks when problems with paying salaries to corporate clients’ employees arose. As a result, in the next pay period, the load on the system increased dramatically, and the system got overloaded. People did not get their salaries in time, as the system crashed.

5 min read

Testing Major Meat Producer’s SAP Makes System 8 Times Faster

testing major meat producers sap makes system 8 times faster
Jun 2, 2022

Our client, a major nation-wide meat producer, was actively using local WMS and TMS. As a result, their 5,000 employees used to waste much time and effort storing and processing a lot of data in different systems. To increase the effectiveness of the document flow, the client decided to move all the processes to one SAP ERP system. Massive migration was about to happen, since enormous amounts of data from different legacy systems had to be centralized. The client had extremely high requirements for a performance tuning project contractor. They wanted to entrust the task only to a highly experienced team. The choice fell on PFLB, as the company has a proven track record of delivering SAP load testing projects for many corporate clients around the world.

  • Be the first one to know

    We’ll send you a monthly e-mail with all the useful insights that we will have found and analyzed

  • People love to read

    Explore the most popular articles we’ve written so far