Sage 100

 View Only

  • 1.  Running any Crystal Report on the Server Uses all the CPU Time

    Posted 09-05-2019 08:53
    Running any Crystal Report on the server maxes out the CPU and other users are not able to work in Sage 100.  How can this be fixed?

    ------------------------------
    Doug Higgs
    Assistant Technical Support / Building Maintenance Specialist
    Midwest Commerce Solutions, Inc
    ------------------------------


  • 2.  RE: Running any Crystal Report on the Server Uses all the CPU Time

    Posted 09-05-2019 12:26
    I've seen this on a customer system (VM with one core).  I tried to get their IT to do something about it, but that went nowhere.
    Normally I'd see individual processes capped at 100% of a core (so at 25% on a VM with 4-cores).

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 3.  RE: Running any Crystal Report on the Server Uses all the CPU Time

    Posted 09-05-2019 12:34
    @Kevin Moyes  Sage and Crystal will take advantage of multiple cores?  Yes, this company is on a VM not sure if it is vm ware or hyper-v.​​

    ------------------------------
    Doug Higgs
    Assistant Technical Support / Building Maintenance Specialist
    Midwest Commerce Solutions, Inc
    ------------------------------

    Original Message


  • 4.  RE: Running any Crystal Report on the Server Uses all the CPU Time

    Posted 09-05-2019 12:41
    Alnoor can probably answer that better than I can, but it is my understanding that each process is limited to a single core... so one task shouldn't lock up the whole server if there are multi-cores on the machine.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


  • 5.  RE: Running any Crystal Report on the Server Uses all the CPU Time

    Posted 09-05-2019 12:45
    @Alnoor Cassim  Would you kindly comment on this thread?   ​

    ------------------------------
    Doug Higgs
    Assistant Technical Support / Building Maintenance Specialist
    Midwest Commerce Solutions, Inc
    ------------------------------

    Original Message


  • 6.  RE: Running any Crystal Report on the Server Uses all the CPU Time

    Posted 09-05-2019 15:45
    I think this must be a one core VM, because the typical view says 25% when Crystal has gone off the rails.

    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    Asheville NC
    678.273.4010 ext 5
    ------------------------------

    Original Message


  • 7.  RE: Running any Crystal Report on the Server Uses all the CPU Time

    Posted 09-05-2019 20:33
    @Phil McIntosh. It definitely is a one core vm. If they add another core ​will Sage and/or Crystal be able to take advantage of it and split the work between the cores?

    ------------------------------
    Doug Higgs
    Assistant Technical Support / Building Maintenance Specialist
    Midwest Commerce Solutions, Inc
    ------------------------------

    Original Message


  • 8.  RE: Running any Crystal Report on the Server Uses all the CPU Time

    Posted 09-06-2019 08:37
    Crystal will still take 100% of one core, but other processes should get assigned to the other core

    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    Asheville NC
    678.273.4010 ext 5
    ------------------------------

    Original Message


Related Content