On [!INCLUDE ssNoVersion_md] and SQL Managed Instance, sys.dm_tran_locks requires VIEW SERVER STATE permission. On SQL Database Basic, S0, and S1 service objectives, and for databases in elastic pools ...
All queries executed on SQL pool are logged to sys.dm_pdw_exec_requests. This DMV contains the last 10,000 queries executed. The request_id uniquely identifies each query and is the primary key for ...