Re: Olap Cube excessive processing time
From: Ben Tetreault (anonymous_at_discussions.microsoft.com)
Date: 03/04/04
- Next message: Pat: "Re: Looking for books or resources."
- Previous message: greensp: "Re: OLAP cube not accessible to the Groups - Project Manager or Executive"
- In reply to: Lars Hammarberg: "Re: Olap Cube excessive processing time"
- Next in thread: Matt S.: "Re: Olap Cube excessive processing time"
- Reply: Matt S.: "Re: Olap Cube excessive processing time"
- Reply: Gary L. Chefetz [MVP]: "Re: Olap Cube excessive processing time"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 4 Mar 2004 09:57:08 -0800
Thanks for your answer Lars.
I know that the date range doesn't help in reducing the
processing time but still, should it take that long when
there is nothing else running on the project server at 1AM
in the morning and the fact the SQL server is also
dedicated to MSP?
Ben
>-----Original Message-----
>Hi!
>
>There's a step prior to letting the OLAP server grab the
data in the
>process:
>
>The Views Notification service (VWNOTIFY.EXE in
TaskManager) is responsible
>for a lot of things - one of which is to retrieve data
from the
>MSP_VIEW_xxxxx tables and parcel that data out to the
cube staging tables
>MSP_CUBE_xxxx in time-phased, day-by-day form. This can
take quite a long
>time - if:
>1. The date range is wide with lots of tasks - or more to
the point - a
>large number of assignments.
>2. There's a LOT of time-phased data specified - e.g.:
baselines 1-10 all
>used, actual data for every assignment, lots of
assignments spanning the
>entire date range, etc.
>3. The service is being interrupted by projects being
saved/published during
>the process (vwnotify is also responsible for the Publish
to MSP_VIEW_xxx
>bits...)
>4. All services are running on the same machine -
specifically the Views
>Notification Service not running on a dedicated server,
as is quite
>possible - you should look into this - check Technet for
more info)
>5. The database server is running other applications or
db-apps hogging cpu
>time.
>
>When the Views Notification service is done, the OLAP
server finally gets to
>do its stuff with the data in the MSP_CUBE_xxx staging
tables - this part
>will probably not take many minutes and can just as
easily be done from
>within the Analysis Manager if you want to tweak the
process or simply to
>check up on the data interactively.
>
>--
>
>/Lars Hammarberg
>www.camako.se
>MSProject Premier Partner
>
>
>"Ben Tetreault" <anonymous@discussions.microsoft.com>
wrote in message
>news:647301c40161$4b5c4450$a301280a@phx.gbl...
>> Hello, we are experiencing excessively long processing
>> time for the portfolio analyzer cube to regenerate. The
>> cube is scheduled to start daily at 1AM but finishes
close
>> to 3PM!
>> The date range used is past 6 months with the next 24
>> months (ya I know it's a lot but that's what the users
>> want).
>> Can someone help me with understanding this long process
>> and why when regenerating it using analysis manager the
>> process only takes minutes?
>>
>> Thanks
>> Benoit
>
>
>.
>
- Next message: Pat: "Re: Looking for books or resources."
- Previous message: greensp: "Re: OLAP cube not accessible to the Groups - Project Manager or Executive"
- In reply to: Lars Hammarberg: "Re: Olap Cube excessive processing time"
- Next in thread: Matt S.: "Re: Olap Cube excessive processing time"
- Reply: Matt S.: "Re: Olap Cube excessive processing time"
- Reply: Gary L. Chefetz [MVP]: "Re: Olap Cube excessive processing time"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
