When using linked servers, I believe, all processing occurs on the calling server. For processing to occur on the linked server you would use OpenQuery.
One of the most common problems when running SQL Servers is slow queries. The help desk or database team usually hears that described as the application is slow or ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results