x Want to participate? Join the group to interact
  • State Not Answered
  • +3 person also asked this people also asked this
  • Replies 14 replies
  • Subscribers 137 subscribers
  • Views 21410 views
  • Users 0 members are here
Browse Forums
Announcements
271
topics
260
replies
Databases and Operating Systems
767
topics
2k
replies
Financials Suite
1k
topics
3k
replies
General Discussion
2k
topics
10k
replies
Operational Suite
854
topics
2k
replies
Reporting and Analytics
1k
topics
3k
replies
Reports, Macros, and Customizations
877
topics
3k
replies
Sage CRM for Sage 300
183
topics
415
replies
MClark

Erratically slow performance Sage300

Posted By

A customer on a brand new server w/ Server 2012, SQL2012 and Sage 300 is reporting erratically slow response times, though it is getting more pronounced.  They have 5 concurrent users (about 12 workstations), about 5mb in data, no other applications running on the server.  Lots and lots of free space.

Sage 300 is installed on the server - with the volume of data and users they have, I thought this would be OK.  We're doing some mods and I was thinking of managing that process which will continue for some while.

If moving the program files to the workstation will make sense, we can do that, but is that the most effective route to go?  Or are there other things we should look into first?

TIA.

Mary

Parents
  • 0

    Hi.  We run lot of Sage 300s in the cloud.  

    VMs, perse are not the issue.

    Other things to try.  

    • Go directly to the SERVER and test performance.  IF the performance is running well from there - it could be a general network matter.  
    • If you have physical disks (RAID) make sure that those are operating well. 
    • Perform SQL LOG Maintenance
    • Modifications or customizations may not have been correctly scripted for optimal performance

    If you still have issues. Please give us a call and we will sand-box your system without charge to assess your data/erp safely.

    Thanks.

    (877) 888 5525

Reply
  • 0

    Hi.  We run lot of Sage 300s in the cloud.  

    VMs, perse are not the issue.

    Other things to try.  

    • Go directly to the SERVER and test performance.  IF the performance is running well from there - it could be a general network matter.  
    • If you have physical disks (RAID) make sure that those are operating well. 
    • Perform SQL LOG Maintenance
    • Modifications or customizations may not have been correctly scripted for optimal performance

    If you still have issues. Please give us a call and we will sand-box your system without charge to assess your data/erp safely.

    Thanks.

    (877) 888 5525

Children
  • 0 in reply to GoGo
    Ok thanks. I havent been able to narrow down the cause yet, but thats all good ideas. I dont think its a hardware problem otherwise other services on the cluster would be suffering as well, there is no other evidence of hardware problems and its too infrequent to be failing hardware in my opinion.

    i guess its a mystery for now. i will post back if i have any new leads or figure it out.
  • 0 in reply to GoGo
    From the Sage 300 2016 Compatibility Guide:

    Avoid running servers as a virtual instance. At the time of writing, VMware vSphere endorses running database servers as a virtual instance. Sage 300 has not been benchmarked to run the database server on a virtual instance in VMware, despite the vendor allowing this configuration.
    (Page 7 of 17)

    support.na.sage.com/.../viewdocument.do

*Community Hub is the new name for Sage City