This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 69%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
On Azure SQL Database in Azure there is a really long query running (many days). The details:
database_name
master
program_name
TdService
It looks like a bug from an Azure SQL Service. On diagnostics while trying to send a support ticket: The "diagnostic did not detect any issues" on the server/database.
Please advise.
Best regards,
Marcin
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 4%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Hi RaTheMigthy,
Provide more information on your actions or script so that you can quickly get help. Or contact Microsoft support via your Azure portal.
There is no option to report a bug in Azure SQL Database other to pay for support above 30$ per month. You can not create a support ticket without buying support plan. So this option from your recommendation is not valid 😞. I used the procedure exec sp_whoisactive. And saw, that there are two above processes that are running for a long time. No one was creating them from the team perspective. It is a form of automatic process from Azure?
I don't think this is a bug. I see similar processes on my two Azure SQL servers. The wait type is XE_LIVE_TARGET_TVF, so I take is that this is a process that monitors an X-Event session. I assume that this process that is part of the service.
If you think something else, please be more specific about what you see.
@Erland Sommarskog thank you for you time. The problem is that it is running for 75 days now. I have many other Azure SQL Databases and for the first time I see something like that. So I suppose it is a bit strange to have the process for so long. I consider to kill this processes with query execution and command 'kill'. But I wonder if I can. I wrote processes because there are two the same processes session_id 80 and 81. All the same records. Type of azure sql database: Service tier General Purpose
Compute tier Serverless
vCores4 vCores
Max storage 200 GB