I'm having a strange performance behavior. When I’m running a mdx query on management studio, it runs for 10 minutes (its mainly calc members on a large cube)
When I run the same query via linked server and openquery, it runs for 20 minutes.
Is the SQL from some reason does a parsing or running the query twice?
The server is sql2008 UP1 on 64bit. and the "allow in process" is checked. its the default in sql2008
Thanks in advance,
View Complete Post