Topics: Think Before You Pink
Returns information about all the waits encountered by threads that executed. You can use this aggregated view to diagnose performance issues with SQL Server and also with specific queries and batches. sys.dm_exec_session_wait_stats (Transact-SQL) provides similar information by session.
To call this from Azure SQL Data Warehouse or Parallel Data Warehouse , use the name sys.dm_pdw_nodes_os_wait_stats.
On SQL Server, requires VIEW SERVER STATE permission.
On SQL Database Premium Tiers, requires the VIEW DATABASE STATE permission in the database. On SQL Database Standard and Basic Tiers, requires the Server admin or an Azure Active Directory admin account.