How to check locks in Azure SQL?

 

 
SELECT * FROM sys.dm_db_wait_stats
ORDER BY wait_time_ms desc