2 เมษายน 2555 10:54
While running mdx query we are getting "memory pressure".
We have seperately processed the cube data as well as its indexes.But memory pressure issue still remains intact.
But as we re-deploy the cube, mdx runs absolutely fine.
What can be the possible root cause of the memory pressure in our scenario?
Is there anything else except re-deploying the cube again and again as it takes long time.
2 เมษายน 2555 11:29
Come back, if not
Please vote as helpful or mark as answer, if it helps
Cheers, Raunak | t: @raunakjhawar | My Blog
2 เมษายน 2555 12:30
Thanks for the suggestions.
We have already tried it, but it didn't worked.
But one strange thing in our scenario is this, it works fine whenever we re-deploy the cube.
10 เมษายน 2555 8:27
In total we have 24 GB RAM out which we have allocated 14 GB to SSAS and 8 GB to SQL server and 2GB to OS.
19 เมษายน 2555 14:45Please help.. After spending some much, we are not able to find the root cause?
20 เมษายน 2555 1:08
Akansha, You might find that HardMemoryLimit is your friend.