x Want to participate? Join the group to interact
  • Replies 6 replies
  • Subscribers 135 subscribers
  • Views 3795 views
  • Users 0 members are here
Browse Forums
Announcements
268
topics
260
replies
Databases and Operating Systems
756
topics
2k
replies
Financials Suite
1k
topics
3k
replies
General Discussion
2k
topics
10k
replies
Operational Suite
851
topics
2k
replies
Reporting and Analytics
1k
topics
3k
replies
Reports, Macros, and Customizations
876
topics
3k
replies
Sage CRM for Sage 300
182
topics
410
replies
Joepcs

Sage 300, and VM's in the year 2021, slow performance still?

Posted By

I've seen posts about sage300 and sql server not supported on VM,s and simply can't believe that to be true. Especially with all the people selling hosting packages now a days.   So I have to ask, is it still True?  

I have slow performance, and have went through the following, with the following server:

Dell R740, Intel Xeon 4214 @ 2.2 ghz.  Perc 740 running 8 SSD drives in raid 10, 128gb of ram. The base server rips, it installs software so fast I thought the install of a backup software failed at first.

Runing 4 VMs, one a low duty app server, then  Sage300 (with remote desktop services but no remote users at the moment) , sage crm server, and finally the sql server.  All just upgraded to server 2019.  SQL server is still SQL 2012 at the moment.  Sage 300 version 2019.

The virtual switch running just the VM's is a 10gb connection to the main switch, which itself is a gb switch.  We have active at the moment only 7 users, but sometimes it's 10.  THe sql database also runs third party shipping software, and crm.  This should be very light loading. Company database is 20.7gb.

 

I went through registries and links, no references to old servers or data servers.  I thought that running an inventory on hand detail report shouldn't take minutes running directly on the server.

Even opening up screens sometimes takes a few seconds.  Am I expecting to much? 

Sage300 server: 32gb of ram (VM)

Sage SQL (58gb of ram(VM)

Any pointers on what to look at next?

  • Were you ever able to find any solution to this issue?

    I have a similar setup (similar server hardware and database size) and it was performing not bad for Sage 300 2019; however when I upgraded to Sage 300 2021 the performance dropped significantly and continues to get worse as time goes on.

  • in reply to Eric Warkentin

    No solution yet, re-indexing the database had a slight impact.  Had our third party implementer's network expert looking at it, and he blamed it on SSD SATA saying SAS 15k drives would perform way better.  Online research seems to say otherwise, and I had the problem existing on 15k sas before I upgraded servers.  I noticed the decline upon upgrade form 2016 to 2019 also.  I wonder if there is something about upgrading that adds time wasting elements to queries.  I looked for all links to old software in registry, and even have full fresh install clients exhibiting the same issue.  I can only devout so much time to solving it. 

  • in reply to Joepcs

    I found a good site that talks about performance adjustments on VMWare systems for SQL - worth a read. A lot of the settings make obvious sense and I should have done them a long time ago (like changing the power mode to high performance.

    SQL Server on VMware vSphere Best Practices: Host, Disk, CPU and Memory Considerations – Virtually Stable

  • in reply to Eric Warkentin

    Reindexing is important to do and can have great benefits. I recommend this maintenance tool which builds up scripts to make that all slick and easy:

    https://ola.hallengren.com/

  • Here is my experience. last version that was running fine on VM was 2016 but after upgrading to 2019 had to move application servers to a physical machine and turn off Windows defender. It is running slightly faster on Windows 2016 than Windows 2019 but Defender must be off.

    I still keep domain controllers, printer server, SQL Server on VM and it is fine. Did not see any improvements by moving SQL server to physical machine Quad Server with 240 GB of ram, so for now SQL server is on VM, 16 cores, and 90 GB of ram, SQL capped to a 70GB.

    For application servers using  two DELL 730 2xE5-2650 with 120GB of ram. About 6-7 users per server and it is running fine. 

  • in reply to chiman

    That seems like a ton of computer power for only 7 users on each server.  I really do think the versions of sage300 higher than 16 are pigs for performance.   I haven't tried moving the application server over, I'd have to V to P it to avoid re-setting everything up.  Is there an easier way to transition application servers?

*Community Hub is the new name for Sage City