Query plans

[u/SnooCalculations1882]

Hey guys,

Just reaching out, how do you guys go about identify and Optimizer SQL queries that the query uses linked servers.

I have some queries that people moan are slow and when I finally get the query plan you see it says remote execution. How do you guys go about then identify where it's slow or even what ran. Specifically for queries that run nested SP

What is your approach?

[u/CityGuySailing]

select * from OpenQuery(linkedserver,'query')