APS / PDW DMVs Explained

In this post we are going to discuss different types of DMV’s in PDW and where the data comes from.   The concept of DMV’s is not new and is taken straight out of SMP SQL Server.  In the appliance though, you don’t need information from just a single instance.  You need it from multiple…


APS/PDW Query Performance: Lock Status

A common scenario customers report is queries which ran quickly yesterday, are taking longer today.  Today I want to cover one aspect that may be causing this behavior: locks.   Most appliances out there have a combination of ETL, ELT, and ad hoc queries.  It is possible one of those ad hoc queries is blocking the…

6

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…


APS AU4 Feature Review: 1.5x data return rate improvement

The Microsoft engineering team has officially signed off on the latest APS update, Appliance Update 4. In this post we will choose one of the features from AU4 and discuss in more detail what the improvement is and what it means for PDW clients. One such improvement that has raised the most question is labeled as “1.5x…