Ok... what does a "Storage Transaction" actually consist of? I ask because many of the hits are pretty large batches. By the same token, we also have tens of million single row hits per hour (and that's just from one app). If each one of those is going to cost $0.0004, then there's going to be hell to pay when someone sees the bill for a month. 😉
Jeff - not sure I completely follow how this gets translated into English, but this might help a bit with the definitions.
https://blogs.msdn.microsoft.com/windowsazurestorage/2010/07/08/understanding-windows-azure-storage-billing-bandwidth-transactions-and-capacity/
I'm hoping that the price per transaction is low because it sounds like you would have a LOT of those suckers in a given month.If I follow the logic it would be substantially more granular than SQL server transactions.
Thanks, Matt. They're a bit non-specific when it comes to the definition of the word "entity", which seems to be a key to how they charge for data access. It would appear from the way they use the word, that they're talking about a single row from a single table. They later go on to describe a transaction as (paraphrased on my part) that a query that returns 500 rows from a single table is a transaction.
That little app I was talking about is a bit of 3rd party artificial intelligence (no comment) that analyses key words and the positions and proximity of those keywords on a document to identify what type of document it is and to which department it should be assigned to. It takes about 8,000 rows of data to analyze a single key word (like I said, no comment)). The long and short of it is that we have approximately 100 million such queries that execute in about 8-10 hours on a normal day. 8,000 rows per query / 500 = 16 transactions. 16*100 million is 1.6 Billion. 1.6 Billion times $0.0004 per transaction is $640,000. That's per 8-10 hour DAY! That's enough to pay for building a wicked good on-premise data center per day along with a year's rent!
Of course, I could be reading all of this the wrong way but the cost calculation just for that 1 part of one app seems to be right according to what I've read.
I think you forgot "gold-plated" in the description of that data center you're building 😛
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?