Join Query Took More then 2 Hour ,even we cancelled job job still working

#1

Today or past 3 days i have observed my join query which is combination of ms-sql Source Views took sometime more then 2 hour because of this mine Azure SQL DB Reaches 90 % of cpu,please find the attached Profile…

One more query How i can Forcefully stopped Job as i saw even if i have cancelled job ,job state always showing running

e6ade587-3333-45a7-aa19-aa78350ea5a4.zip (32.0 KB)

#2

@Vikash_Singh, did this run faster before? We’re you running this query alone, or were there other concurrent queries?

Please attach additional runs of the same query, then maybe we can get a better idea of what’s going on.

#3

Yes this query run faster but not always ,this query itself run alone

please find attached Profile for Query which run sucssfully

13357b02-6a27-4751-bfe5-90bf69957adc.zip (18.8 KB)