Re: Execution location and Default Isolation Mode
- From: Darren Gosbell <jam@xxxxxxxxxxxxxxxxx>
- Date: Thu, 3 Nov 2005 13:50:57 +1100
You add these settings to the connection string that the client uses,
separating the parameters with semi-colons
eg
;Execution Location=3;Default Isolation Mode=1
You can test these settings in MDX sample by just adding the above
string after the server name in the connection dialog box.
Note that there are some operations which will not run on the server no
matter what you do, so as they say "your mileage may vary"
--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell
In article <O8LQcoA4FHA.636@xxxxxxxxxxxxxxxxxxxx>, jesperzz@xxxxxxxxxxx
says...
> I went digging through the Performance Guide and came about these two
> properties I want to change. We have data in two locations and we're hitting
> on limitations. I'd like to set the queries to execute on the server rather
> than resolve on the server and client box.
>
> My question is...where are they set? Is it just a setting on the client?
>
>
>
.
- References:
- Execution location and Default Isolation Mode
- From: Jesse O
- Execution location and Default Isolation Mode
- Prev by Date: Re: Can I use many-to-many dimensions in AS2005?
- Next by Date: Re: Performance of Cube request
- Previous by thread: Execution location and Default Isolation Mode
- Next by thread: RE: Yet another Unable to browse error
- Index(es):
Relevant Pages
|
