on 09-24-2018 3:00 AM
Folks,
We have 2 node cluster Business Intelligence software 4.1 SP 7 up and running on Windows 2012 Server Platform, Currently we are doing some tests to determine load balancing.
We are running multiple crystal report processes scheduled at the same time, about 30 reports which each would take about 35 min time.
I am trying to frame Query using Query Builder to determine the distribution of jobs among 2 nodes to get the response output.
Any help would be appreciated
You can simply look at job server and CMS servers metrics and see the distribution, no need to run any querries.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Gopal,
You can try the following query
SELECT SI_SCHEDULEINFO.SI_MACHINE_USED, SI_NAME FROM CI_INFOOBJECTS WHERE SI_SCHEDULE_STATUS = 0
Thanks,
Venkat
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
10 | |
9 | |
9 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.