Azure SQL Data Warehouse SQL Operations Studio Extension Available

In may the engineering team for Azure SQL Data Warehouse announced integration with SQL Operations Studio. Now they have released a preview of an extension that contains pre built dashboards to monitor you Data Warehouse instances! Today you can monitor data skew, ColumnStore index health, and system resource usage. We expect more scenarios to be…


Performance: Evaluate Data Skew

This topic applies to both Azure SQL Data Warehouse and Analytic Platform System Data skew occurs when one distribution has more data than others.  When data is inserted into a distributed table, each row will be assigned and sent to a distribution for storage.  The distribution a row is sent to is decided by applying…


PDW Execution Plans: Why are you shuffling my data?!

One of the objectives when architecting a database on a PDW system is to do so with the goal of  minimizing  data movement.  Some data movement is unavailable.  It is important to be able to read an execution plan to be able to determine why a shuffle move, or any data movement for that matter,…


Loading performance – DWLoader, distribution keys and source files

There are several ways to load data in PDW: SSIS, DWLoader client, and with the latest release BCP also(*) In this post I will discuss a specific performance scenario when loading data with DWLoader. You can refer to .CHM for all details on DWLoader client, parameters, syntax, remarks… The first thing to check when looking…


APS AU4 Feature Review: Introducing Round Robin Distribution

This is our second post covering the new features and improvements included in the SQL APS PDW AU4 release.  Starting with AU4, tables in PDW now have a third distribution option.  In addition to the familiar Hash distribution and replicated formats, AU4 introduces the Round Robin distribution type.  This distribution type was first introduced in…