Performance issues on Azure Sql Servers

I am facing some performance issues when trying to join two tables from different azure sql servers. My query is taking a whole minute to complete. One table contains around 1 million rows the second one around 200k.

Hi @kyliehulst

Kindly provide us the job profile

Share a query profile


Hi Balaji,

We don’t normally do this but recently have been asked to create threads when people come in on intercom. Here is a link he sent me to his profile of query and the intercom chat himself.