Checking Queries Performance on Azure SQL Database (DMVs)

In this post, I will share a couple of important queries that I am using to check performance on Azure SQL Database. Show locking information: SELECT  t1.resource_type,  t1.resource_database_id,  t1.resource_associated_entity_id,  t1.request_mode,  t1.request_session_id,  t2.blocking_session_id FROM sys.dm_tran_locks as t1 INNER JOIN sys.dm_os_waiting_tasks as t2 ON t1.lock_owner_address = t2.resource_address; For further details read: https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-tran-locks-transact-sql Show Top 5 worst performance … Read moreChecking Queries Performance on Azure SQL Database (DMVs)