We are trying to process the Cube. First time when we processed the cube it took around 1 and 1/2 hours to do full process. But after some time in the same environment its taking more then 6 hours to process. As such there was no change in the environment. We have 64 bit 2 way itinium processor with 32 GB of ram. The size of the cube is aroung 150 MB. We are using the OLE DB2 provider to connect to database.Any environmental issues that needs to be checked.Any thoughts on this issue.Appriciate your help.
Thnaks,
Really hard to say what is going on.
Many factors could be affecting processing perofrmance.
I would first check the performance of relational database. See what is the rate of DB2 delivering the data. 150 meg of data should take way faster to process for Analysis Server.
Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
There does not seems to be any issue with Relational Database side .If I ran the same cube from machine its peocessing very fast.Any factor in analysis box that that can count for slow processing .
Analytical box is 64bit 2 way processor with 64 GB ram.
Thnaks,
|||Try and trace command AS sends to relational database. And then see what rate your 64bit box can get data from relational database
Again, it is had to say without looking at the cube. Try and contact Customer Support Service and have support engineer to look at your situation.
Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
No comments:
Post a Comment