We currently have our Security Domain on a T500E unix box with a maximum of 50 concurrent connections in a 10 minute interval. A standard user takes 10 seconds to login to Business Objects. I’ve been conducting load testing here for a d370a box because we would like to move the Security Domain. However, 1 user consumes 1 CPU to login. The Security Domain itself is only 1.8Mb and in analysis of a login Business Objects is looping through the same tables thousands of times. My question is…does it take everyone 10 seconds to login for a standard user? What kind of server does your Security Domain sit on? How many users do you have?
There are 1500 users here today and growing. It doesn’t make sense to invest in a huge box for a 10 minute interval when the concurrent connections are at their peak. Are we missing some great tuning opportunity here…or is the Business Objects login code just bad?
Quick question, jodie… Have you tested the SQL under the newer versions of BO?
Not a trick question, reason I ask is that we found the same thing, but we did this analysis under webi 2.02 and bo 4.15… it feels better now, but I don’t have the same data here to say it is any different.
Brent
Our domain is on a large’ish unix box, running Oracle 7.3.4 - we have approx 1200 users, and a fairly complicated security set up… We were able to improve performance by adding some indexes, and by moving tablespaces and redo logs, but you are right - there was some pretty serious thrashing going on…
Hello!
We currently have our Security Domain on a T500E unix box with a maximum of
50 concurrent connections in a 10 minute interval. A standard user takes 10
seconds to login to Business Objects. I’ve been conducting load testing
here for a d370a box because we would like to move the Security Domain.
However, 1 user consumes 1 CPU to login. The Security Domain itself is only
1.8Mb and in analysis of a login Business Objects is looping through the
same tables thousands of times. My question is…does it take everyone 10
seconds to login for a standard user? What kind of server does your Security Domain sit on? How many users do you have?