A case against using Basic and Standard (S0 & S1) tiers in Azure SQL Databases
Read OriginalThis technical article argues against using Basic and Standard (S0 & S1) service tiers for Azure SQL Databases. It details critical limitations including severe performance throttling (especially for log writes), restrictive permission models that hinder administrative tasks, and the lack of support for features like In-Memory OLTP and Columnstore indexes. The author warns that these lower tiers can lead to unexpected locking, deadlocks, and administrative roadblocks, making them unsuitable for many production workloads.
Comments
No comments yet
Be the first to share your thoughts!
Browser Extension
Get instant access to AllDevBlogs from your browser