x Want to participate? Join the group to interact
  • State Suggested Answer
  • Replies 2 replies
  • Answers 1 answer
  • Subscribers 137 subscribers
  • Views 951 views
  • Users 0 members are here
Browse Forums
Announcements
237
topics
29
replies
General Discussion
5k
topics
13k
replies
Sage Data & Analytics
56
topics
95
replies
Sage Enterprise Intelligence
210
topics
416
replies
Sage Intelligence Reporting
121
topics
322
replies
SAGENew

Sage X3 on Multicore VM

SUGGESTED
Posted By

Dear Experts, we have a strange problem. Sage X3 is allocating only one core for tasks launched from each of the terminals. The system is running in a VM with a 4x4 (4 Physical each with 4 logical cores) configuration. But while creating a big report, only one Core is taking the load. This is also the reason that it is taking 30-45 seconds to generate one such report. We tried from two terminals, and two cores take the load.

We have checked SQL, VM Config, and found no problem.

Question 1. Is this normal? I mean, if the report generation process is taking 30-45 seconds in one core, why can not it use more cores and finish fast?

Question 2. Is it related to something else? What could it be? I am stuck, please help.

  • 0
    SUGGESTED

    I don't think so.  See the attached video of a very unscientific test run against a VM run on my laptop.    

    Here a link to a video that will be up for a day or two of a test i ran.   

    https://1drv.ms/v/s!AtsjVfYbnckBhKITUDxMGxbB-j8l-Q?e=xIEYOB

     Here is a screen shot from the video that shows the system idle, the running of the stock site report, and then idle again.  Note that all the CPU's picked up some load and that the loads were not the same on each CPU but were properly distributed.   Kind of small. Sorry.  

  • 0 in reply to Stephen

    Hi Stephen, thanks a lot for the video. It is clear. We found one more thing: If the request is placed to SQL from some of the users, it is happening as I wrote above. Surprisingly, we see 3-4 Cores actively taking load if it is done through the Admin login. It does not matter if we do it directly on the VM or from a laptop connected through VPN. Please refer to the below diagrams. The top two images are created by the user. The bottom two are created during tests using admin access. 

    And that makes me more clueless!

*Community Hub is the new name for Sage City