Solved

Microsoft Dynamics Great Plains Bench test

Posted on 2013-06-27
5
891 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

This very simple solution applies to a narrow cross-section of the "needs to close" variety. In this case, the full message in Event Viewer was in applog, Event ID 1000: Faulting application iexplore.exe, version 8.0.6001.18702, faulting module …
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

733 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