Help - Cube Processing

All,
I m at a loss to understand whats happened to the data warehouse I manage.
Everything was OK up until about 2 weeks ago then overnight the daily Cube
processing jumped from about 15 minutes to nearly 45 minutes/Partition.
I've Defraged and reindexed all the fact tables, that helped for about 2
days but no has no effect.
The server config is
4 x Xeon 2.8 Processors (multi threading applied, effectivly 8 Pros)
4GB of Memory (AWE Disabled)
2GB Sys Paging File
5 Drives all Raid 0+1
I would suggest that you scan through your system using the tips and tricks
suggested in the following two white papers:
http://www.microsoft.com/technet/pro.../ansvcspg.mspx
http://www.microsoft.com/technet/pro.../anservog.mspx
Both contain lots of great recommendations on how to deal with increased
processing times.
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jason Lees" <JasonLees@.discussions.microsoft.com> wrote in message
news:6EAFB483-D8D0-4770-B1B3-78766465757F@.microsoft.com...
> All,
> I m at a loss to understand whats happened to the data warehouse I manage.
> Everything was OK up until about 2 weeks ago then overnight the daily Cube
> processing jumped from about 15 minutes to nearly 45 minutes/Partition.
> I've Defraged and reindexed all the fact tables, that helped for about 2
> days but no has no effect.
> The server config is
> 4 x Xeon 2.8 Processors (multi threading applied, effectivly 8 Pros)
> 4GB of Memory (AWE Disabled)
> 2GB Sys Paging File
> 5 Drives all Raid 0+1
>
>