INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

BOE Switching Servers

BOE Switching Servers

(OP)
How does BOE determine what server to run reports on? I have about 20 reports running right now and they are all running on one server (and hitting it really hard). Is there any kind of load balancing that occurs when running reports? I assumed there was but that is not what is happening right now. Maybe there is a setting I don't have configured correctly?

RE: BOE Switching Servers

Yes, it should balance between the servers. However, some of that depends on how you have things set up in the CMC. What kind of reports are they - Crystal, Webi, something else? Do you have server groups defined? Are you talking about scheduled reports or view on demand reports? If they're scheduled, look at the Job servers - what is the max concurrent jobs for each? Are you talking physical servers, the server processes that run inside BO, or both? If it's physical servers, how many server processes do you have running on each physical server?

-Dell

DecisionFirst Technologies - Six-time SAP BusinessObjects Solution Partner of the Year
www.decisionfirst.com

RE: BOE Switching Servers

(OP)
Hello,

These for Crystal Reports that are scheduled...some may be demand...but majority scheduled reports.

I have 4 Physical servers and I do have the server Groups defined.

The Job servers for all of my servers are set to 20 Jobs per server.

But what ends up happening is all of the reports will run from 1 server and sometimes que up that server instead of going to the other 3 servers that are free.

I would Ideally like to have them look at the most freed up server instead of it always hitting one server.

E.I

Report 1 Server 1
Report 2 Server 2
Report 3 Server 3
Report 4 Server 4
Report 5 Determine which server has more freed up space
Report 6 Determine which server has more freed up space




Currently this is how it looks

Report 1 Server 1
Report 2 Server 1
Report 3 Server 1
Report 4 Server 1
Report 5 Server 1
Report 6 Server 1

Please let me know if I am making sense.

RE: BOE Switching Servers

For Crystal reports, the job server processes scheduled reports and the processing server handles view on demand. For Webi, the job server sets off the schedule and then passes it to the processing server. So it helps to know what you're working with.

I would set the job server to have a max of 5 to 10 concurrent reports. It's better to have multiple server processes running fewer reports on a given physical server - you CAN add additional job server processes to the configuration - than to have just one server process running many reports.

You can also use the Server Groups that have been configured in the CMC by specifying a server group for scheduling in the default properties for each report - if you set it a "Give preferences to servers belonging to the selected group" then you're not constraining it to run on only one server but it can use the setting to determine where it will run.

Other than these suggestions, there really is no way to control how BO does its load balancing between the server processes (it doesn't particularly take note of the physical server, just the server process that's running.)

-Dell

DecisionFirst Technologies - Six-time SAP BusinessObjects Solution Partner of the Year
www.decisionfirst.com

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close