Hi all,
I finally worked out, how to shift the execution location
from client to server. I did not know that Locale
Identification plays such a big role.

Solution:
We had server in english and client in german. Execution
location was client and not server, although we had
set "execution location=3;Default Isolation Mode=1".
Turns out that with two different locales you need to add
the locale of the server to the connection string. (In
our case "Locale identifier=1033"). Then Execution
location is the server.

Question:
Now I have a question concerning the serverside execution
on dual processor systems. During a complicated query
both processors use 50% of their capacity. Is there a way
to fully use both processors in order to increase query
speed? Has anyone made similar observations?

TIA Lutz Morrien

Hi Lutz,

That is good to read.

On your cpu question are you sure that CPU is the bottleneck? Look for that
with perf. monitor.

Also have a look at:

Optimizing Hardware Resources to Improve Performance
from
Microsoft SQL Server 2000 Analysis Services Performance Guide
http://www.microsoft.com/technet/tre...hNet/ProdTechn
ol/SQL/Maintain/Optimize/ANSvcsPG.asp

HTH,
Bas

"This posting is provided "AS IS" with no warranties, and confers no
rights."

Hello Bas,
thank you for your advice.
Actually I noticed that two queries issued in parallel
will use both cpu resulting in 100% cpu useage
(Serverside execution).

The fundamental problem is a large parent child dimension
(customer) with 35.000+ members. Dimension members can
have a maximum of three levels, but most of the members
have no level at all. It is a business requirement for
our client to be able to view the hierarchies and so far
the client has refused our request to add further levels.

The end users request up to all of the dimension members
which keeps AS busy for quite a while.

I am still hoping for a change of mind.

Thanks again, I'll look into the material you referenced.
Lutz