OLAP Cube audit logs?

G

Greg

We're having an issue where the OLAP cube on our
development PS2002 server started taking approximately 2
times as long to generate as it has been in recent weeks.
The cube on our production server now is in a perpetual
building state.

Is there any log file that captures some minimal
information such as date and time that a cube was build
that would help me see exactly when the behavior changed?
I'd ideally like to find some historical log of this
activity.

Thanks,

Greg O.
 
G

Gary L. Chefetz [MVP]

Greg:

It's not exactly in a perpetual building state, it simply says that in the
display page. What errors are you seeing in the Application Event Log on the
server? These typically accompany failed cube builds.
 
G

Greg O.

I should clarify what I meant about perpetual-- we
schedule the cube to build each night. On the development
system, we use the default values, including specifying
the date range for retrieving resource availability
information-- the next 4 months. On the production box,
we set this to the next 10 months. Both contain 0 for
past months.

What we saw was that when we set the development to 10
months, it took twice as long-- which I'd expect to take
longer. Being that the production box used to take 8
hours, I suspect it's now taking longer than 24 hours, and
not completing before it's scheduled to go again.

The application log is not showing any errors related to
project while the cube is building. No warnings, no
Information entries that I can correlate as having
anything to do with a Project process on the web/app
server.

However I now see that the SQL server has an informational
entry saying this: This instance of SQL Server has been
using a process id of 996 since 2/12/2004 6:33:08 PM
(local) 2/13/2004 12:33:08 AM (UTC). What's puzzling
though is that the development sql server also has a
similar message, but when we set the date range back to
the next 4 months, it returned to it's 4 hour cube build
yesterday.

It would just be nice to have a little more information
about an ongoing cube build, and some historical data to
look through in a situation like this.

Thanks,

Greg O.
 
G

Gary L. Chefetz [MVP]

Greg:

That information is helpful. Now we need to look at the metrics: Server
specs and portfolio specs. Does your SQL box need upgrading or is there
something odd in the way you've crafted your portfolio. Either of these
could explain the extended build times.
 
Top