Sql Azure - Unexplained locking

Vote count:

0

We have a console app running on our server which generates reports according to a schedule.

Frequently, the processing gets blocked by a sql lock, which can last for several minutes.

I can't determine what is causing the locking, even with the use of the dynamic management views.

E.g.

SELECT sqltext.TEXT,
req.session_id,
req.status,
req.command,
req.cpu_time,
req.total_elapsed_time
FROM sys.dm_exec_requests req
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext

gives:

Row 1 is the query that is being blocked. Row 2 is the query I used to generate the result.

This is causing significant issues in production, and I'm at a loss as to how to proceed.

asked 30 secs ago

user2209634

33

Sql Azure - Unexplained locking