Solved

Microsoft Dynamics Great Plains Bench test

Posted on 2013-06-27
5
909 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Automatically creating a Trello card using data from a Microsoft Dynamics CRM record turned out to be an easy project that yielded great results.  Here's how I did this for an internal team at General Code.
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
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 …
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

690 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