DREView gives you a comprehensive insight into your workloads and end-to-end visibility into the performance of your SQL data warehouse, helping you to dramatically reduce the time it takes to isolate and fix data warehouse issues. The monitor provides an intuitive interface on a single pane of glass that visualizes data warehouses and server activity so you can see at a glance where problem areas are..

Features

• Automatically captures and retain the history of queries, plans, runtime statistics

• Real-time dashboard with a dynamic display of data, index, logs, CPU, memory, resource classes and tempdb usage
• Drill-through analysis for sessions, queries, request_steps, sql_requests and dms_workers with a graphical view
• Provides a comprehensive health check report with greater insight
• Insights into any security flaws with a comprehensive audit log viewer 
• Features supporting query optimization and recommendations will be released shortly

Benefits

• Bundled with support from MPP solution experts ( Azure Synapse SQL )
• Decision making support for better capacity utilization and forecasting 
• All in one monitoring dashboard, health check, performance analysis and recommendation application
• Plug and Play SaaS application