Solved

Microsoft Dynamics Great Plains Bench test

Posted on 2013-06-27
5
882 Views
Last Modified: 2013-06-28
is there a particular tool or application that is available to test the performance of Great Plains. want to test a virtual copy of the physical server to see what the performance is like.
0
Comment
Question by:ashdennis
  • 3
  • 2
5 Comments
 
LVL 18

Accepted Solution

by:
Steve Endow earned 500 total points
ID: 39284947
Hi,

I am not aware of any publicly available load testing tools for Dynamics GP.  Microsoft has some type of tool or testing mechanism that they use internally, but that is used for their benchmarking, and as far as I know, that is not available to customers.

http://blogs.msdn.com/b/gp/archive/2010/09/07/performance-benchmark-results-for-microsoft-dynamics-gp-2010.aspx

Load testing is complex, expensive, and very time consuming.  There are hundreds of variables and considerations and many technical complexities with automating an application like Dynamics GP.

I think the best approach would be to simulate a few large and / or critical Dynamics GP processes in your test virtual environment.  Post several large batches, run a Historical Aged Trial Balance report, run some large SmartLists, etc.

But more to the point of what I think you are looking to know, Dynamics GP can run fine in a virtual environment if you provide the VMs with enough RAM and CPU--the same two constraints that exist in a physical environment.

I have worked with several Dynamics GP customers that run GP on all virtual servers.  RAM seems to be the biggest performance constraint--many customers don't allocate nearly enough RAM (i.e. 2GB for a SQL Server, which is far too little).  As long as you allocate plenty of RAM and CPU capacity, GP will run just fine.


Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified IT Professional
0
 

Author Comment

by:ashdennis
ID: 39284981
The physical server handles the load well, its now replicated in a virtual environment with exact specs. 32 gigs of memory and 2 quad core processors. I note your feedback and will perform those tests as suggested. Any other pointers.
0
 
LVL 18

Expert Comment

by:Steve Endow
ID: 39285293
Hi,

I have developed an eConnect import load testing application that I use for batch posting load testing.  It can insert thousands of batches and transactions, which allows customers to test how their system behaves when posting tons of batches.

GP Insert Records
It currently only supports inventory transactions and purchasing receipts, but I'm planning on adding Payables Transactions and probably eventually SOP and GL.

If I can get around to refining a few things and enhancing the documentation, I am thinking I'll post it to the community.  I'm thinking it might be useful for load testing and benchmarking different GP environments.

Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified IT Professional
0
 

Author Comment

by:ashdennis
ID: 39285402
The screen shot is interesting, how soon for launch. How can you be contacted outside of this when you make it available.
0
 
LVL 18

Expert Comment

by:Steve Endow
ID: 39285600
Hi,

I will announce it on my Dynamics GP Land blog if I release it:

http://dynamicsgpland.blogspot.com/


I can be contacted through my web site:

http://precipioservices.com/contact-us/


Or via email through my Blogger profile:

http://www.blogger.com/profile/03950475674093020502


Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified IT Professional
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
onenote 2016 sync 40 239
Passing a TempVar to a Combo box form 3 97
SSRS Problems 9 72
converting visio 2010 to powerpoint 2010  - formatting issues 5 72
As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
This collection of functions covers all the normal rounding methods of just about any numeric value.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question