Several improvements in this regard have since come online. Please see Morgan’s comments (posted 6/11/2018). Thanks
An error occurred while saving the commentBrian Hall commented
I agree with Rory and the commenters here and wanted to refresh this conversation. We're currently a startup running a Standard with 200 eDTUs. We tried running at 100 eDTUs but during our highest load were right up around 95%-100% usage. We scale up to 200 and hover around 40%-50%.
That's double the cost while not using over half the resources. One of the features of cloud computing is supposed to be enabling more efficient resource usage. The way elastic pools are currently setup leaves much to be desired.
Thank you for your feedback. We are currently in public preview of blob storage lifecycle management. The feature set offers a rich, rule-based policy engine which you can use to transition your data to the best access tier and to expire data at the end of its lifecycle. See our post on the Azure Blog to get started: https://azure.microsoft.com/en-us/blog/azure-blob-storage-lifecycle-management-public-preview/preview/.
For any further questions, or to discuss your specific scenario, send us an email at DLMFeedback@microsoft.com.