Warner Chaves

Warner Chaves is a Principal Consultant at Pythian where he helps enterprise customers manage, design and optimize their database solutions. With over 10 years of experience as a DBA and consultant, he was previously part of Hewlett-Packard's ITO organization and is also currently a Microsoft Data Platform MVP.

16 September 2016
16 September 2016

Azure SQL Data Warehouse: Explaining the Architecture Through System Views

The architecture of Azure SQL Data Warehouse isn't easy to explain briefly, but if you have some useful queries that access the management and catalog views, and diagrams that show how they relate together, you can very quickly get a feel for what is going on under the hood. By using and extending these queries that use these views, you can check on a variety waits, blocking, status, table distribution and data movement in ASDW.… Read more