Sage 100

 View Only
  • 1.  Slow Sage System Performance when running Sage Scheduled Task

    Posted 06-25-2019 16:28
    We have a client who is on Sage 2017 Premium PU 3, running on a Server 2016. System performance is satisfactory when the Scheduled Task to auto update inventory transactions is not running. When the scheduled task launches and it seems when the system is generating the Task Scheduler Log, the performance of Sage for most users declines. Examples includes takes a long time for new Sage screens to load, delay in typed in information in a field, lookups screens taking a long time to load. We have pinpointed it to be only when this task scheduler log is generating. We have tried moving the scheduled task off the server and to a virtual machine running in 90 mode. It still effects the entire systems performance. Any ideas on what the cause could be or to disable the task scheduler log from trying to generate?

    ------------------------------
    Kimberly Davis
    Lehman Wesley & Associates
    ------------------------------


  • 2.  RE: Slow Sage System Performance when running Sage Scheduled Task

    Posted 06-25-2019 17:26
    I'm not sure this applies to premium - I had a similar slowdown with task scheduler for a customer with a large Sy_Activity log file.  When the task schedule job ran it would leave stranded SY_ActivityLogReportWRK_##############.M4T files in the MAS_System.  I copied and renamed Sy_Activity log to backup, then reinitialized the file in DFDM and it corrected the issue.

    ------------------------------
    Moira Goggin
    Executive Director
    90 Minds, Inc.
    ------------------------------