Memory Pressure Issue

Question

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.

Answer 1

See if this helps http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/1922fe23-b6f4-4bdc-aca7-4081fdf124f4/

Come back, if not

---

Please vote as helpful or mark as answer, if it helps
Cheers, Raunak | t: @raunakjhawar | My Blog

Answer 2

Raunak

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.

---

Akansha Agarwal

Answer 3

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.

---

Akansha Agarwal

Answer 4

Please help.. After spending some much, we are not able to find the root cause?

---

Akansha Agarwal

Answer 5

Akansha, You might find that HardMemoryLimit is your friend.

See http://richardlees.blogspot.com.au/2012/04/ssas-freezing-needs-restarting-or.html

Richard Lees

---

Richard