Allow Recovery Model to be changed to SIMPLE in Azure SQL Database
According to this article (https://blogs.msdn.microsoft.com/azuresqldbsupport/2018/12/28/lesson-learned-50-adding-pk-led-to-transaction-log-full-error/) the recovery model of a Azure SQL Database cannot be altered from the default option FULL. In a very data intensive setup, this blows up the transaction log -> the LOG IO percentage in portal is at 100% all the time. Allowing the SIMPLE recovery model should improved the performance significantly.
Azure SQL is sufficient for smaller BI environments. Azure DWH would be an overkill (features, pricing).
Therefore Simple Recovery Mode is a MUST for such BI environments. Especially for its ETL Processes loading/transforming data volumes every day.
I also would like to see this happen
Hennie de Nooijer commented
Yes, please. IMO is full logging not acceptable for DWH ing. SQL DW is not an option for a couple 100 GB's (<1TB) of data.
Mike Shih commented
Would love to see this feature as well. We lose a lot of flexibility on which service tiers we can be on because of the log I/O bottlenecks.
Naveen Kumar Thummalapenta commented
May be considering this feedback would be definitely be an additional asset to Azure SQL Offerings.
Benjamin Weber commented
This is very crucial. In the current situation, Azure SQL DB is not usable for BI without extremely high costs.