Azure SQL Data Warehouse performance RRS feed

  • Question

  • I had to load 1TB of data from Azure Storage Blob to Azure SQL DW. I have created external tables and loaded data using PolyBase and it took 5 hours.

    When I tested performance of Azure SQL DW with 3000 DWU and compatibility_level = 130, the jMeter query performance was very slow. I couldn't view sys.dm_os_wait_stats. The Azure portal showed Resource class as null, I couldn't figure out why the performance was so poor.

    Is there a documentation to set up Azure SQL DW for better performance? Any views to show the stats of Azure databases?

    Thank you!

    Wednesday, December 14, 2016 11:01 PM

All replies