Azure Monitor log support for Azure SQL Data Warehouse
Published date: 12 November, 2018
Azure SQL Data Warehouse now enables enhanced insights into analytical workloads by integrating directly with Microsoft Azure Monitor diagnostic logs. With this new capability, developers can analyse workload behaviour over an extended time period and make informed decisions on query optimisation or capacity management.
Azure Monitor diagnostic logs support customisable retention periods by saving the logs to a storage account for auditing purposes, the capability to stream logs to event hubs for near real-time telemetry insights and the ability to analyse logs by using Azure Log Analytics with log queries. Diagnostic logs consist of telemetry views of your data warehouse equivalent to the most commonly used performance troubleshooting DMVs for SQL Data Warehouse.
For this initial release, we have enabled views for the following:
- sys.dm_pdw_exec_requests
- sys.dm_pdw_request_steps
- sys.dm_pdw_dms_workers
- sys.dm_pdw_waits
- sys.dm_pdw_sql_requests
For more information about Azure Monitor logs support for SQL Data Warehouse, see the full blog post.