Azure SQL Data Warehouse Management

Azure SQL Data Warehouse is a cloud-based, distributed data warehouse capable of batch processing of huge volumes of data, both relational and non-relational. By dividing the data and processing it in parallel on multiple nodes, Azure SQL Data Warehouse can offer huge scalability and dramatically reduce processing time as compared to traditional on-premise tools.

CloudMonix monitors and visualizes Azure SQL Data Warehouse databases by collecting information on their utilization, active loads, connections, sessions, longest running queries, various performance statistics from the perspective of the resource governor and even custom data retrieved via SQL queries. Additionally, CloudMonix can help optimize Warehouse databases by automatically scaling them based on load or pausing/resuming them according to a custom-defined schedule.

Setting up Azure SQL Data Warehouse in CloudMonix takes just a couple of minutes, since the most important metrics, alerts and automation are preconfigured in default templates.

Try Free
Pricing & Plans

Popular Ways to Utilize CloudMonix

Costs Savings

Ensure you’re paying only for the usage you actually need. Pause the resource when you don’t need it and resume compute according to the schedule. Auto-scale the Warehouse based on the actual load.

Usage Tracking

The actual usage can be determined and estimated using data such as queued loads or requests, failed connections, open sessions, CPU usage, DWU utilization. All those metrics, and more, are tracked out of the box.

Performance Insights

Identify the longest running queries, get text of exact commands that are executed, see any related errors and current status.

Custom SQL

Track and alert on custom data retrieved using user-defined SQL queries. Automatically perform regular maintenance tasks by executing user-defined SQL scripts.

Azure SQL Data Warehouse Monitoring

Cloudmonix provides a powerful set of monitoring features for monitoring SQL Data Warehouse databases. Users can be immediately alerted of any performance or availability issues.

  • Track queued loads and requests, DWU utilization, and many more performance statistics
  • Identify the longest running queries
  • Execute custom SQL scripts to obtain data

Azure SQL Data Warehouse Automation

CloudMonix helps users keep their Azure SQL Data Warehouse costs low by auto-scaling and auto-pausing databases.

  • Pause and resume databases according to schedule
  • Automatically scale up and down based on the actual load
  • Execute custom SQL scripts to perform maintenance tasks
screenshot-azure-sql-database-automation

Sign up for CloudMonix and get
deep insight into Azure SQL Data Warehouses

Try Free Today!