Re: Business Objects performance
From: Helma <helma.vinke_at_hotmail.com>
Date: Mon, 13 Jul 2009 07:23:33 -0700 (PDT)
Message-ID: <ed9f8965-3ad7-4fe4-a98c-3096b5e58779_at_e18g2000vbe.googlegroups.com>
On Jul 13, 3:44 pm, John Hurley <johnbhur..._at_sbcglobal.net> wrote:
> On Jul 8, 5:17 am, Helma <helma.vi..._at_hotmail.com> wrote:
>
> snip
>
> > I need to improve the performance of Business Objects reports.
> > Whenever I look when the database is on it knees there is a B.O.
> > report running which causes it.
>
> > For trendanalysis and tuningsimpact, I need to know how long and how
> > often each report runs every month. That information cannot be
> > obtained in B.O. itself. Did anyone solve this problem before?
>
> Well you probably already know that in many cases people setup standby
> database and direct business intelligence reporting activities against
> a system like that.
>
> Once you start giving end users direct ability to kick off things like
> this against a live production OLTP database ... whenever they want
> to ... it is very hard to attempt to regain control unless you get
> some very strong management backing from operational areas that are
> getting impacted negatively.
Date: Mon, 13 Jul 2009 07:23:33 -0700 (PDT)
Message-ID: <ed9f8965-3ad7-4fe4-a98c-3096b5e58779_at_e18g2000vbe.googlegroups.com>
On Jul 13, 3:44 pm, John Hurley <johnbhur..._at_sbcglobal.net> wrote:
> On Jul 8, 5:17 am, Helma <helma.vi..._at_hotmail.com> wrote:
>
> snip
>
> > I need to improve the performance of Business Objects reports.
> > Whenever I look when the database is on it knees there is a B.O.
> > report running which causes it.
>
> > For trendanalysis and tuningsimpact, I need to know how long and how
> > often each report runs every month. That information cannot be
> > obtained in B.O. itself. Did anyone solve this problem before?
>
> Well you probably already know that in many cases people setup standby
> database and direct business intelligence reporting activities against
> a system like that.
>
> Once you start giving end users direct ability to kick off things like
> this against a live production OLTP database ... whenever they want
> to ... it is very hard to attempt to regain control unless you get
> some very strong management backing from operational areas that are
> getting impacted negatively.
True, mixing BI-tools and OLTP db's can lead to severe performance problems. Ad hoc reports can't be tuned. But I need to quantify the performance and identify the top trouble-reports , and try to tune those reports before i can come to the conclusion that we need more iron.
Report-name, runtime, frequency, timeperiod : that's the info i need in order to know the tune-targets. How to get that?
HV Received on Mon Jul 13 2009 - 09:23:33 CDT