I have a question which i am facing from long back...
My question is...
our Business System has a cube which is processed daily morning.
It should take around 1.30 hours to Process this cube. But its not the same every day.
I wont bother if it takes a little bit more than that, but its taking different timings every day.
one day its around 2 or 3 or 5 or 7 or sometimes its going to around 10 also.
i am really suprised to see why the same cube on the same server is taking such a huge difference in timings everyday.
Can some one Explain me what i need to do to make the timings not to go too long.
View Complete Post