Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Microsoft Dynamics Great Plains Bench test

Posted on 2013-06-27
5
Medium Priority
?
928 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 2000 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 learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
Desired Skill Set for Microsoft Dynamics CRM Technical Resources – Part II
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 …
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

610 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