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
Subscribe for more articles
Fortnightly newsletters help sharpen your skills and keep you ahead, with articles, ebooks and opinion to keep you informed.
Want more? Subscribe to our fortnightly newsletter