I triggered a very inefficient query against a Azure SQL Server instance that has been running now for hours. I have tried looking at the active spid and trying to kill the process that started it but couldn’t find it.
On the performance reports I get a query id. Maybe there is a way to trace the queryid back to a spid and terminate it?
I also can't restart the Azure SQL Server database to terminate it. I tried scaling up and down but no luck.
I can find it by querying:
SELECT * FROM sys.query_store_plan where query_id = 1111
What can I do?