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.
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
Join Simple Talk
Join over 200,000 Microsoft professionals, and get full, free access to technical articles, our twice-monthly Simple Talk newsletter, and free SQL tools.