Microsoft Dynamics GP v10 and supported virtualization platforms

The Windows Server Catalog site may just be one of the best kept secrets on the web. According to the About This Site page, "[t]he Windows Server Catalog lists thousands of hardware and software items compatible with the Microsoft Windows Server 2008 R2, Windows Server 2008 and Windows Server 2003 operating systems. In addition, products may also be compatible with other versions of Microsoft Windows as shown in each product details page."

In response to my friend Steve Endow's inquiry on Microsoft's support of vitualization environments and Dynamics GP, I went in quest of finding the answer since it is not always apparent where to find this information. The first place of course, the Systems Requirements page of CustomerSource/PartnerSource. On this page, you can clearly read the software and hardware virtualization platforms supported, but as usual the fine print is rather more interesting.



It turns out this page points to the Windows Server Catalog page where furthermore you can inquiry on other tested solutions by clicking on the Server Virtualization Validation Program site link.


The site has a Support Policy Wizard link that will take you to a wizard-based tool where you can select the products you would like to obtain support information about.



Next, in the product drop-down, you can choose any of the Microsoft products listed, in this case, Dynamics GP. Version 10 is the only release listed, but I am sure this will change in a couple years from now with the advent of new releases.


After clicking Next, the wizard presented a drop-down list with the supported virtualization technologies. Among the ones listed:

  • Microsoft Hyper-V
  • Cisco WAAS Virtual Blades 4.1
  • Novel SUSE Linux Ent Server 10 SP2
  • VMWare ESX 3.5 Update 2, 3, 4
  • VMWare ESXi 3.5 Update 3, 4
  • VMWare vSphere 4
  • Citrix XenServer 5, 5.5
But there had to be more, right? Right! The wizard allows you to check on the guest operating system configurations and processors along with the environment to verify which configurations have been tested and are currently supported.


As indicated in the screenshot, I decided to try something not too common: I selected Cisco WAAS Virtual Blades 4.1 as the virtualization technology, Windows Server 2008 R2 as the guest OS, and x64 as the OS architecture. When I pressed Next ...



...I was pleasantly surprised to see that Cisco WAAS Virtual Blades with Windows Server 2008 R2 (x64) was a supported platform. The good news is, as long as a platform and a configuration is supported you are able to obtain technical support.

Until next post!

MG.-
Mariano Gomez, MVP
IntellPartners, LLC
http://www.intellpartners.com

Comments

Scott said…
I have access to customersource, but cannot access the Server Virtualization Validation Program. It wants me to sign up for something. I cannot do that at the moment. Can you give me a ballpark idea on something? We set up a sql cluster (2 node active-passive) on windows 2008 R2 enterprise & SQL 2008 R2 (x64). These are dual-core with 16 GB of ram each. With only 10 clients or some testing the system, the CPU is pegging. I know when we had physical hardware we used quad cores, but I read it is not recommended to do this in vmware. It doesn't seem correct that such light usage should cause this. All the standard indexes are present for GP 2010. Can you recommend anything? There was no blocking or deadlocks going on. Just this high CPU staying between 80 and 100%. I couldn't find anything on customer source or google about GP 2010 requirements in a vmware environment, yet I see plenty of people are running it in vmware.

Thanks,
Scott Emick DBA
October 4, 2012 at 4:46 PM
Mariano Gomez said…
Scott,

You can access the Server Virtualization Validation Program site directly at:

http://www.windowsservercatalog.com/svvp.aspx

I did not get asked for any sign up of any kind.

Can you confirm a couple things:

1. Is the server pegging even with no clients accessing it? What if you launch GP directly from the server?

2. Which server is pegging? The SQL Server or the Windows Server? It would sound like the SQL Server according to what you describe, but I just need to confirm.

Finally, I have a number of clients running on VMware without any issues, so clearly there may be something environmental causing this problem.
October 4, 2012 at 8:15 PM
Scott said…
The SQL server is pegging only when the clients are accessing it using GP 2010. I too have other clients using VMWare & SQL/GP 10 with no problems on similar platforms to this one.

When I go to the link you listed I cannot find "Dynamics GP", "Microsoft Dynamics GP" or a few other things I searched for. But I guess I don't need to use that, plenty of people are using vmware esx.

This new client I set up the SQL Server Cluster, but their VAR did the GP Install. I haven't had access since. I will probably check all the standard things like recovery model, backups, index rebuilds, update statistics, DMV's (of missing indexes etc), run the sql profiler, run the windows perfmon against memory, cpu, & disk. I guess I was just looking for some kind of special caveats you might have encountered with virtual install of GP 2010.
Thanks for your time and if you have any more suggestions, they are welcome.

Scott
October 5, 2012 at 3:46 AM
Mariano Gomez said…
Scott:

There are couple things that come to mind:

1. Run esxtop to compile some stats on your server. You will want to check for two stats in particular: %wait and %idle. If they are too high, it means there's some I/O operation that the server is waiting on.

2. When your customer built this VM and loaded Windows on it, how many CPUs got assigned to the VM? You may have a problem with your HAL, in this case, you should be using an SMP HAL, which I can't tell if you are or aren't. Come back with an answer on that.

Go into Device Manager, and look under the computer branch, and see what kind of kernel you are running.
October 5, 2012 at 2:23 PM
Post a Comment

Popular posts from this blog

DBMS: 12 Microsoft Dynamics GP: 0 error when updating to Microsoft Dynamics GP 2013 R2

Image
Hello all! It's been quite a while since I've actually written anything of remote interest to anyone who follows my blog, but at the same time, you will be pleased to know that I've been quite busy in the consulting front, with upgrades, server migrations, complex multi-instance postings involving 10's of thousands of transactions, wrapping up some Field Service Automation projects, and the list goes on and on. This time around I want to bring to the forefront, an issue I encountered updating  from Microsoft Dynamics GP 2013 SP2 to Microsoft Dynamics GP 2013 R2 plus the latest service pack. Background My client requested a server migration to a new environment where they wanted to deploy Dynamics GP 2013 R2 web client (plus the latest service pack) and upgrade their relational database management system to Microsoft SQL Server 2014. This is something I'm absolutely comfortable with (for the most part) given also that my client was sitting at Microsoft Dynamics
Read more

Cannot insert the value NULL into column 'CONTACT' error when clicking on Items List in Navigation Pane

Image
Moving on from my previous article on a similar subject - see Cannot insert the value NULL into column 'BASEUOFM' error when clicking on Items List in Navigation Pane , I recently came across this error,  Cannot insert the value NULL into column 'CONTACT' when clicking on the All Purchasing Transactions list under the Purchasing Navigation Pane option, after performing an upgrade from Microsoft Dynamics GP 9.0 to Microsoft Dynamics GP 2010 R2. All Purchasing Transactions list error - Purchasing Navigation List The name of the global temp table - in this case, tempdb.dbo.##2093338- varies in almost all cases, but the end result of the error is the same. The issue has been identified running Microsoft Dynamics GP 2010 RTM, SP1 or SP2. Upon further review, the issue is due to bad data in the Vendor ID (VENDORID) column in the Purchasing Receipt History table (POP30300). In summary, if you have a purchasing receipt with a blank vendor ID or a vendor ID that doe
Read more

#PowerApps: Numeric Up/Down control with persisted button press event using components

Image
I just recently returned from the Microsoft MVP Global Summit 2019 where I had a chance to meet some of the top minds in the Microsoft PowerApps and Flow space. This was a truly exciting moment as I have been learning from the very same MVPs I met - yes, we do learn from each other! In one of my hallway discussions, I ran into my buddy Mehdi Slaoui Adaloussi , Principal Program Manager at Microsoft, who I first met at Microsoft Build 2018. I had read Mehdi's recent article on reusable components and, in particular, that I had been playing with his version of the Numeric Up/Down Control. See 10 Reusable Components: tab control, calendar, dialog box, map control and more . I must start by saying that the components Mehdi put in place expose some very clever implementation techniques, so I highly recommend you download the msapp files and load them up in your environment and study them. The Numeric Up Down control in particular, caught my attention as it required multiple and
Read more