Out of memory when executing Stored Procedure in SPS09

[Former Member]

We have been facing a similar issue after an upgrade to the SPS 10.

We had to downgrade again to SPS 09 but the issue didn't resolve.

The problem manifested in different ways. The most recent one appeared as it follows.

We have a select statement that goes out of memory when running into a store procedure. On the contrary it works fine when executed from SQL console. The select looks like:

SELECT [CALCULATION VIEW] WHERE [CLAUSE]

We have gone over this plenty of times but still don't understand what is going on here.

According to the PlanViz the engine suddenly starts making outer joins for apparently no reason (find the plv attacched).

Moreover if we get rid of the WHERE clause the execution doesn't run out of memory.

We did open an incident, but we are struggling to get an answer.

[lbreddemann]

Reads like a classic case of mistaking correlation for causation.

If the upgrade to SPS 10 had caused the issue, then going back to SPS 9 should have removed it again, which wasn't the case.

You write about that the same problem manifests itself in different ways. How do you know it's the same problem?

Without knowing the calculation view design or the planviz files it's not possible to work on this problem.

Not sure why you struggle to "get an answer" from the support colleagues. Typically there would be requests for data to replicate the issue...