May 05 2017 04:57 AM - edited May 05 2017 05:06 AM
Hi,
Just spend a few weekends and created that fully automated tool http://azureprice.net that should help:
The tool based on Azure Web Sites and DocumentDB in the back-end. All data collecting once per day using Azure Functions through Azure API management and putting everything to Document DB.
DocumentDB Findings
Hope DocumentDB product team will change pricing model because right now I need manually/scripting UP scale RU/s before bulk inserting and after that scale down it to 400 RU/s. I think PaaS service should do that automatically or just bill me for additional RU/s but right now I need to do that with scripting and pay for 10k RU/s for one hour per day where I need only 2-3 minutes with so much RU/s.
Also, it will be wonderful if DocumentDb will have a normal bulk inserting API because "recommended" way using stored procedure feels that a "dog-nail" method with try-again from where it was failed last time.
If you guys have suggestions or feature request feel free to leave a comment here and I will try to implement it.
Vic