1. OLTP workload – Azure SQL DW is an MPP database, data is distributed in many servers to improve reads thus it would hurt your OLTP writes.
  2. High volume of small reads and writes – Same as above
  3. Multi-Tenancy Database –  would be a nightmare to restore a single schema in case your environment is compromised, Azure SQL DW does not offer RLS, Always Encrypted and Column Level Encryption (CLE)
  4. Frequent changing of schema
  5. Row by row processing – in a scenario where UDF’s are needed to process data, MPP system would be a disservice to your processes.
  6. JSON, XML data and Spatial, Struct, Array and Map data types
  7. Power BI direct query requiring dashboard performance – with direct query mode Power BI will perform poorly with a large data set in Azure SQL DW
  8. High concurrency of queries (eg. hundreds of thousands of concurrent queries) – currently Azure SQL DW does not have plan caching mechanism thus all queries have to go through plan search space to find an execution plan.
  9. Small datasets (less than 250GB) – it’s an MPP system
  10. Disaster recovery with stringent RPO and RTO – Azure SQL DW does not have the capability to automatically replicate data to another hot/standby Azure SQL DW for DR purpose. Yes, it’s geo-redundant for data replication every 24hrs to other data centers thus there is the possibility of data loss.

6 thoughts on “10 scenarios where Azure SQL DW is not a good fit”

  1. Wanted to take this opportunity to let you know that I read your blog posts on a regular basis. Your writing style is impressive, keep it up! Danielle Laurence Aluino

  2. Having read this I thought it was very enlightening. I appreciate you taking the time and energy to put this article together. I once again find myself spending way too much time both reading and commenting. But so what, it was still worthwhile! Flossy Alexei Clava

  3. I feel this is among the most important details for me. And i am glad looking at your report. But want to remark on some general things, The web site style is excellent, the articles or blog posts is truly great : D. Very good work, cheers Deanna Teodoor Gunner

  4. Do you mind if I quote a couple of your articles as long as I provide credit and sources back to your website? My website is in the very same niche as yours and my visitors would truly benefit from some of the information you provide here. Please let me know if this alright with you. Many thanks! Beulah Whitaker Tirzah

  5. Everything is very open with a precise description of the challenges. It was truly informative. Your website is very useful. Thanks for sharing! Karola Oren Clerk

Leave a Reply

Your email address will not be published. Required fields are marked *