Re: Query performance dramatically different
Dusan, the fast version is obviously sending the query to the remote
site to be ran. You can find the SQL being passed in the OTHER column
of PLAN_TABLE. The second plans is issuing several remote queries so
it is likely full scanning on some of these. Some suggestions:
You might want to look at the session settings for all session
modifiable database parameters to make sure these are not different.
This is just an expansion of Sybrand's suggestion.
..
Verify that RLS is not in play
Verify that all users are looking at the same local and remote objects
(synonymns and link users)
HTH -- Mark D Powell --
.
Relevant Pages
- Re: Which Domain Controller
... > We have several domain controllers in our network, ... > remote. ... I am trying to verify which DC our users are authenticating to ...
(microsoft.public.win2000.networking) - Re: Which Domain Controller
... > We have several domain controllers in our network, ... > remote. ... I am trying to verify which DC our users are authenticating to and ...
(microsoft.public.win2000.networking) - Re: RWW for 1 client not working anymore
... Verify that the errant system is in the same OU as all the others. ... Verify that the remote connections are enabled in the system properties of the station.... ... Now I have 1 client that cannot use Remote ...
(microsoft.public.windows.server.sbs) - Re: Remote Desktop wont accept connection
... up the System Properties GUI and select the Remote tab. ... Select Remote Users... ... You might also need to verify the group policies haven't been locked down to ... "Liquidshokk" wrote: ...
(microsoft.public.windowsxp.work_remotely) |
|
