Solved

Microsoft Dynamics Great Plains Bench test

Posted on 2013-06-27
5
872 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-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

On Sep 22nd 2014 Microsoft released Update Rollup 1 for Microsoft Dynamics CRM 2013 Service Pack 1 and back in July Update Rollup 3 was released.  So we now have:   Update Rollup 1Update Rollup 2Update Rollup 3Service Pack 1Update Rollup 1 for S…
User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
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 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 …

911 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now