Enhance Azure SQL Data Warehouse performance with new monitoring functionality for Columnstore

https://azure.microsoft.com/en-us/services/sql-data-warehouse/ (SQL DW) is a SQL-based petabyte-scale, massively parallel, cloud solution for data warehousing. It is fully managed and highly elastic, enabling you to provision and scale capacity in minutes. You can scale compute and storage independently, allowing you to range from burst to archival scenarios.

 

Azure SQL DW is powered by a https://docs.microsoft.com/en-us/sql/relational-databases/indexes/columnstore-indexes-overview engine to provide super-fast performance for analytic workloads. This is the same Columnstore engine that is built into the https://blogs.msdn.microsoft.com/sqlserverstorageengine/2016/03/14/columnstore-index-how-does-sql-server-delivers-industry-leading-performance-for-analytic-queries/. To get full speed from the Azure SQL DW, it is important to maximize Columnstore Row Group quality. A row group is the chunk of rows that are compressed together in the Columnstore. In order to enable easier monitoring and tuning of row group quality we are now exposing a new https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/system-dynamic-management-views (DMV).

 

 

Read about it on the https://azure.microsoft.com/en-us/blog/sql-data-warehouse-columstore-monitor/.