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 ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results