Re: Azure Pricing

[Greg Keogh]

On 27 July 2016 at 08:21, Grant Molloy  wrote:

> Hi Greg,
>
> I did these calcs before seeing the calculator, and it pretty much
> confirmed my calcs for storage.
>
> As a complete Azure newb, I'm assuming I have the following options..
>
> 1. Virtual machine where I'd install company licensed versions of SQL, run
> IIS, and maybe some disk storage for files and SQL backups, etc
>
> Or
>
> 2. Web app service, SQL, storage for files etc.
>
> Is this correct?
>
I think so (boffins please clarify if I'm wrong).

You can provision a whole server in a VM, but you can do that anywhere
(GoDaddy, Amazon, Rackspace, etc) and you have to manage most of it
yourself just as if the box was sitting under your desk.

Otherwise, if you deploy web apps, SQL instances, tables, blobs, files, etc
directly they just live "up there" somewhere and you have the advantage of
being able to go to the management portal and adjust performance,
duplication, scaling, load balancing, CDNs in different geographical
regions, etc. I've never needed to do any of this myself in anger, but you
can see it's all possible.

I have a growing bias against physical boxes for servers and find the idea
of having things deployed in "The Matrix" quite attractive (that's the
Neuromancer Matrix, not the one in the movie). I still have a server box
under my desk, but as I said in my previous post, the cost of moving my
SQL Instance and several more web services and sites to Azure is
prohibitive for a one-man business. So I'm stuck with a box here humming
and needing nursing and maintenance.

*Greg*

Re: Azure Pricing

[Craig van Nieuwkerk]

You can use a combination of 1 & 2, it really depends on how 'legacy' your
app is. Does the installation have lots of custom bits you need to do and
things to be installed, if so a VM or Web Role is probably best. If it
doesn't have many dependencies like that then you can probably use a WebApp.

SQL Azure supports most standard SQL Server features, you can see the
differences here
https://azure.microsoft.com/en-us/documentation/articles/sql-database-transact-sql-information/

Craig

On Wed, Jul 27, 2016 at 8:21 AM, Grant Molloy  wrote:

> Hi Greg,
>
> I did these calcs before seeing the calculator, and it pretty much
> confirmed my calcs for storage.
>
> As a complete Azure newb, I'm assuming I have the following options..
>
> 1. Virtual machine where I'd install company licensed versions of SQL, run
> IIS, and maybe some disk storage for files and SQL backups, etc
>
> Or
>
> 2. Web app service, SQL, storage for files etc.
>
> Is this correct?
>
> On Jul 27, 2016 7:40 AM, "Greg Keogh"  wrote:
>
>> Hi Grant, you might be one of the few people in history with the will
>> power to attempt to use the calculator, I balked. My usage is small in
>> comparison, about 60MB of Table rows and 3GB of Blobs, all with trivial IO
>> counts. My recent account summaries show a cost of about $0.25/month for
>> this data, so I'm guessing your low figures are in the right order of
>> magnitude.
>>
>> I also have a Basic Small App running my personal web site, which also
>> has trivial hit rates and it costs $55/month. I recently deleted a tiny SQL
>> database which had zero IO and was costing about $30/month. I restate my
>> alarm over these costs, especially the Apps, which can add-up to
>> frightening annual amounts which might dissuade small business from
>> chucking out their own boxes and migrating to the cloud.
>>
>> *Greg*
>>
>> On 26 July 2016 at 15:45, Grant Molloy  wrote:
>>
>>> Hi list..
>>>
>>> Azure has always baffled me a bit with their pricing..  I'm looking into
>>> something for my employer and looking at the costs here,
>>> https://azure.microsoft.com/en-us/pricing/details/storage/ and trying
>>> to work out the cost of storing files starting from scratch..
>>>
>>> So with this following scenario, can anyone confirm my pricing examples?
>>> So lets say I have 0 files in Azure to start with.
>>> If each month 5,000 5mb files are uploaded (giving approx 25.6GB of
>>> files at the end of the month), and each file is written only 1 time, but
>>> read 3 times.
>>>
>>>
>>> *BLOB storage *prices (from above link)..
>>> + Storage - GRS (COOL) - First 100TB/M $0.0382 (is prorata'd)
>>> + Access - GRS (COOL) - Put (/10,000) $0.2547
>>> - Other (/10,000)   $0.0127
>>> - Retrieval (GB) $0.0127
>>> -  Write (GB)   $0.0064
>>> - GRS (GB)   $0.1528  (geographical redundancy)
>>>
>>> Example:
>>> END OF FIRST MONTH
>>> Storage: 25.6/2 x ((0.0382/100)*0.025)  NOTE: have halved data amount to
>>> give an average for the month, as you're not paying for the full 25.6GB of
>>> storage for the whole month.
>>> 12.8 * 0.0955 = $ 0.00012224
>>> Access: PUT: 0.2547/10k * 5k = $ 0.12735
>>> READ: 25.6GB * 3 * 0.0127 = $ 0.97536
>>> GRS:  25.6GB * 0.1528 = $ 3.91168
>>> *$$  5.01451224*
>>>
>>> END OF 2nd MONTH
>>> Storage: (25.6GB + 25.6/2) x ((0.0382/100)*(0.025+0.025/2))
>>> 38.4GB x (0.000382 * 0.0375)
>>> 38.4GB x 0.14325 = $ 0.00055008
>>> Access: PUT: 0.2547/10k * 5k = $ 0.12735
>>> READ: 25.6GB * 3 * 0.0127 = $ 0.97536
>>> GRS:  25.6GB * 0.1528 = $ 3.91168
>>> *$$  5.01494008*
>>>
>>>
>>> *FILE storage* (prices from above link too)
>>> File Storage
>>> + Storage - GRS Per GB $0.1401
>>> + Access - GRS - Put (/10k) $0.3821
>>> - List (/10k) $0.1911
>>> - Other (/10k) $0.0191
>>> Example.
>>> END OF FIRST MONTH
>>> Storage: 25.6GB/2 x 0.1401 = $  1.79
>>> Put: (0.3821 / 10k * 5k) = $  0.19
>>> Read: (0.0191 / 10k * 5k) x 3 = $  0.03
>>>  *$$  2.01*
>>> END OF 2nd MONTH
>>> Storage: (25.6 + 25.6/2)GB x 0.1401 = $ 5.38
>>> Put: (0.3821 / 10k * 5k) = $  0.19
>>> Read: (0.0191 / 10k * 5k) x 3 = $  0.03
>>> * $$  5.60*
>>>
>>> Do these calculations look correct ??
>>>
>>
>>

Re: Azure Pricing

[Grant Molloy]

Hi Greg,

I did these calcs before seeing the calculator, and it pretty much
confirmed my calcs for storage.

As a complete Azure newb, I'm assuming I have the following options..

1. Virtual machine where I'd install company licensed versions of SQL, run
IIS, and maybe some disk storage for files and SQL backups, etc

Or

2. Web app service, SQL, storage for files etc.

Is this correct?

On Jul 27, 2016 7:40 AM, "Greg Keogh"  wrote:

> Hi Grant, you might be one of the few people in history with the will
> power to attempt to use the calculator, I balked. My usage is small in
> comparison, about 60MB of Table rows and 3GB of Blobs, all with trivial IO
> counts. My recent account summaries show a cost of about $0.25/month for
> this data, so I'm guessing your low figures are in the right order of
> magnitude.
>
> I also have a Basic Small App running my personal web site, which also has
> trivial hit rates and it costs $55/month. I recently deleted a tiny SQL
> database which had zero IO and was costing about $30/month. I restate my
> alarm over these costs, especially the Apps, which can add-up to
> frightening annual amounts which might dissuade small business from
> chucking out their own boxes and migrating to the cloud.
>
> *Greg*
>
> On 26 July 2016 at 15:45, Grant Molloy  wrote:
>
>> Hi list..
>>
>> Azure has always baffled me a bit with their pricing..  I'm looking into
>> something for my employer and looking at the costs here,
>> https://azure.microsoft.com/en-us/pricing/details/storage/ and trying to
>> work out the cost of storing files starting from scratch..
>>
>> So with this following scenario, can anyone confirm my pricing examples?
>> So lets say I have 0 files in Azure to start with.
>> If each month 5,000 5mb files are uploaded (giving approx 25.6GB of files
>> at the end of the month), and each file is written only 1 time, but read 3
>> times.
>>
>>
>> *BLOB storage *prices (from above link)..
>> + Storage - GRS (COOL) - First 100TB/M $0.0382 (is prorata'd)
>> + Access - GRS (COOL) - Put (/10,000) $0.2547
>> - Other (/10,000)   $0.0127
>> - Retrieval (GB) $0.0127
>> -  Write (GB)   $0.0064
>> - GRS (GB)   $0.1528  (geographical redundancy)
>>
>> Example:
>> END OF FIRST MONTH
>> Storage: 25.6/2 x ((0.0382/100)*0.025)  NOTE: have halved data amount to
>> give an average for the month, as you're not paying for the full 25.6GB of
>> storage for the whole month.
>> 12.8 * 0.0955 = $ 0.00012224
>> Access: PUT: 0.2547/10k * 5k = $ 0.12735
>> READ: 25.6GB * 3 * 0.0127 = $ 0.97536
>> GRS:  25.6GB * 0.1528 = $ 3.91168
>> *$$  5.01451224*
>>
>> END OF 2nd MONTH
>> Storage: (25.6GB + 25.6/2) x ((0.0382/100)*(0.025+0.025/2))
>> 38.4GB x (0.000382 * 0.0375)
>> 38.4GB x 0.14325 = $ 0.00055008
>> Access: PUT: 0.2547/10k * 5k = $ 0.12735
>> READ: 25.6GB * 3 * 0.0127 = $ 0.97536
>> GRS:  25.6GB * 0.1528 = $ 3.91168
>> *$$  5.01494008*
>>
>>
>> *FILE storage* (prices from above link too)
>> File Storage
>> + Storage - GRS Per GB $0.1401
>> + Access - GRS - Put (/10k) $0.3821
>> - List (/10k) $0.1911
>> - Other (/10k) $0.0191
>> Example.
>> END OF FIRST MONTH
>> Storage: 25.6GB/2 x 0.1401 = $  1.79
>> Put: (0.3821 / 10k * 5k) = $  0.19
>> Read: (0.0191 / 10k * 5k) x 3 = $  0.03
>>  *$$  2.01*
>> END OF 2nd MONTH
>> Storage: (25.6 + 25.6/2)GB x 0.1401 = $ 5.38
>> Put: (0.3821 / 10k * 5k) = $  0.19
>> Read: (0.0191 / 10k * 5k) x 3 = $  0.03
>> * $$  5.60*
>>
>> Do these calculations look correct ??
>>
>
>

Re: Azure Pricing

[Greg Keogh]

Hi Grant, you might be one of the few people in history with the will power
to attempt to use the calculator, I balked. My usage is small in
comparison, about 60MB of Table rows and 3GB of Blobs, all with trivial IO
counts. My recent account summaries show a cost of about $0.25/month for
this data, so I'm guessing your low figures are in the right order of
magnitude.

I also have a Basic Small App running my personal web site, which also has
trivial hit rates and it costs $55/month. I recently deleted a tiny SQL
database which had zero IO and was costing about $30/month. I restate my
alarm over these costs, especially the Apps, which can add-up to
frightening annual amounts which might dissuade small business from
chucking out their own boxes and migrating to the cloud.

*Greg*

On 26 July 2016 at 15:45, Grant Molloy  wrote:

> Hi list..
>
> Azure has always baffled me a bit with their pricing..  I'm looking into
> something for my employer and looking at the costs here,
> https://azure.microsoft.com/en-us/pricing/details/storage/ and trying to
> work out the cost of storing files starting from scratch..
>
> So with this following scenario, can anyone confirm my pricing examples?
> So lets say I have 0 files in Azure to start with.
> If each month 5,000 5mb files are uploaded (giving approx 25.6GB of files
> at the end of the month), and each file is written only 1 time, but read 3
> times.
>
>
> *BLOB storage *prices (from above link)..
> + Storage - GRS (COOL) - First 100TB/M $0.0382 (is prorata'd)
> + Access - GRS (COOL) - Put (/10,000) $0.2547
> - Other (/10,000)   $0.0127
> - Retrieval (GB) $0.0127
> -  Write (GB)   $0.0064
> - GRS (GB)   $0.1528  (geographical redundancy)
>
> Example:
> END OF FIRST MONTH
> Storage: 25.6/2 x ((0.0382/100)*0.025)  NOTE: have halved data amount to
> give an average for the month, as you're not paying for the full 25.6GB of
> storage for the whole month.
> 12.8 * 0.0955 = $ 0.00012224
> Access: PUT: 0.2547/10k * 5k = $ 0.12735
> READ: 25.6GB * 3 * 0.0127 = $ 0.97536
> GRS:  25.6GB * 0.1528 = $ 3.91168
> *$$  5.01451224*
>
> END OF 2nd MONTH
> Storage: (25.6GB + 25.6/2) x ((0.0382/100)*(0.025+0.025/2))
> 38.4GB x (0.000382 * 0.0375)
> 38.4GB x 0.14325 = $ 0.00055008
> Access: PUT: 0.2547/10k * 5k = $ 0.12735
> READ: 25.6GB * 3 * 0.0127 = $ 0.97536
> GRS:  25.6GB * 0.1528 = $ 3.91168
> *$$  5.01494008*
>
>
> *FILE storage* (prices from above link too)
> File Storage
> + Storage - GRS Per GB $0.1401
> + Access - GRS - Put (/10k) $0.3821
> - List (/10k) $0.1911
> - Other (/10k) $0.0191
> Example.
> END OF FIRST MONTH
> Storage: 25.6GB/2 x 0.1401 = $  1.79
> Put: (0.3821 / 10k * 5k) = $  0.19
> Read: (0.0191 / 10k * 5k) x 3 = $  0.03
>  *$$  2.01*
> END OF 2nd MONTH
> Storage: (25.6 + 25.6/2)GB x 0.1401 = $ 5.38
> Put: (0.3821 / 10k * 5k) = $  0.19
> Read: (0.0191 / 10k * 5k) x 3 = $  0.03
> * $$  5.60*
>
> Do these calculations look correct ??
>

Azure Pricing

[Grant Molloy]

Hi list..

Azure has always baffled me a bit with their pricing..  I'm looking into
something for my employer and looking at the costs here,
https://azure.microsoft.com/en-us/pricing/details/storage/ and trying to
work out the cost of storing files starting from scratch..

So with this following scenario, can anyone confirm my pricing examples?
So lets say I have 0 files in Azure to start with.
If each month 5,000 5mb files are uploaded (giving approx 25.6GB of files
at the end of the month), and each file is written only 1 time, but read 3
times.


*BLOB storage *prices (from above link)..
+ Storage - GRS (COOL) - First 100TB/M $0.0382 (is prorata'd)
+ Access - GRS (COOL) - Put (/10,000) $0.2547
- Other (/10,000)   $0.0127
- Retrieval (GB) $0.0127
-  Write (GB)   $0.0064
- GRS (GB)   $0.1528  (geographical redundancy)

Example:
END OF FIRST MONTH
Storage: 25.6/2 x ((0.0382/100)*0.025)  NOTE: have halved data amount to
give an average for the month, as you're not paying for the full 25.6GB of
storage for the whole month.
12.8 * 0.0955 = $ 0.00012224
Access: PUT: 0.2547/10k * 5k = $ 0.12735
READ: 25.6GB * 3 * 0.0127 = $ 0.97536
GRS:  25.6GB * 0.1528 = $ 3.91168
*$$  5.01451224*

END OF 2nd MONTH
Storage: (25.6GB + 25.6/2) x ((0.0382/100)*(0.025+0.025/2))
38.4GB x (0.000382 * 0.0375)
38.4GB x 0.14325 = $ 0.00055008
Access: PUT: 0.2547/10k * 5k = $ 0.12735
READ: 25.6GB * 3 * 0.0127 = $ 0.97536
GRS:  25.6GB * 0.1528 = $ 3.91168
*$$  5.01494008*


*FILE storage* (prices from above link too)
File Storage
+ Storage - GRS Per GB $0.1401
+ Access - GRS - Put (/10k) $0.3821
- List (/10k) $0.1911
- Other (/10k) $0.0191
Example.
END OF FIRST MONTH
Storage: 25.6GB/2 x 0.1401 = $  1.79
Put: (0.3821 / 10k * 5k) = $  0.19
Read: (0.0191 / 10k * 5k) x 3 = $  0.03
 *$$  2.01*
END OF 2nd MONTH
Storage: (25.6 + 25.6/2)GB x 0.1401 = $ 5.38
Put: (0.3821 / 10k * 5k) = $  0.19
Read: (0.0191 / 10k * 5k) x 3 = $  0.03
* $$  5.60*

Do these calculations look correct ??

[OT] Azure pricing

[Greg Keogh]

Hi folks, anyone working this week? (if you're not, then you should be
tweaking your hobby code).

Because I get free Azure quotas as part of my MSDN subscription, and
because I never push Azure really hard, I don't have a feel for what is
costs in a typical business environment. Is anyone here using Azure as part
of a small to medium sized business app, perhaps with a SQL database and
some blobs and tables? If so, what magnitude of monthly bills do you
receive?

I ask, because more often I suggest to people that they push their apps and
work into the cloud, but if I'm asked what the cost is like I can't give
them a comparison or a ballpark figure. Perhaps someone here has had
typical realistic experience in this.

I also ask because most Azure Team news broadcast emails I receive contains
words like "This change may cause a price increase on your monthly Azure
bill" (as the last one did). I only ever seem to get notifications of price
increases and it really makes me nervous about recommending it to anyone.

Cheers,
*Greg K*

RE: [OT] Azure pricing

[Rob Andrew]

Hi Greg,We currently have a medium sized app (web site, some batch processes, 1-2 Gb DB) that was doing very little other than idling and receiving the odd data request to process. This was just running in an Azure VM. We were using it mainly for integration testing - so changes were reliant upon the other partners invoking our system.When we used the 'defaults' our bill was close to $200 / month. I was rather astounded at the cost - I can get a full VM in a DC in AU for < $90 /mth, probably better if I hunted around. But doing a lot of hunting around I managed to move us to a smaller plan and we are down to closer to $20 / month which is more what I expected given our load. Two things that hit me while doing this :* It's rather difficult to figure out where your costs are, and how to lower them / control them.* There are a lot of options that you are given by default that you dont need (but I think a lot of that is just us learning the ropes). * Azure SQL is not the full SQL Server :) [that caught us]. Anyhow - just our experiences...
Rob Andrew 
AEGIS SOFTWORKS PTY LTD
- Original Message - From: Greg Keogh [mailto:gfke...@gmail.com] To: ozdotnet@ozdotnet.com Sent: Wed, 30 Dec 2015 10:15:33 +1100 Subject: 

Hi folks, anyone working this week? (if you're not, then you should be tweaking your hobby code).
 
Because I get free Azure quotas as part of my MSDN subscription, and because I never push Azure really hard, I don't have a feel for what is costs in a typical business environment. Is anyone here using Azure as part of a small to medium sized business app, perhaps with a SQL database and some blobs and tables? If so, what magnitude of monthly bills do you receive?
 
I ask, because more often I suggest to people that they push their apps and work into the cloud, but if I'm asked what the cost is like I can't give them a comparison or a ballpark figure. Perhaps someone here has had typical realistic experience in this.
 
I also ask because most Azure Team news broadcast emails I receive contains words like "This change may cause a price increase on your monthly Azure bill" (as the last one did). I only ever seem to get notifications of price increases and it really makes me nervous about recommending it to anyone.
 
Cheers,
Greg K

Re: [OT] Azure pricing

[罗格雷格博士]

I see a lot of small companies using a basic web tier (up to 10 sites) and an 
S1 Azure SQL DB, with monthly costs around $114 AUD.

You can't directly compare it with a VM as that both requires management, etc 
plus doesn't have built in HA options. PaaS is the future not IaaS, which is 
really just an interim use of cloud systems.

Regards

Greg

Dr Greg Low
SQL Down Under
+61 419201410
1300SQLSQL (1300775775)

On 30 Dec 2015, at 10:24 AM, Rob Andrew 
> wrote:

Hi Greg,

We currently have a medium sized app (web site, some batch processes, 1-2 Gb 
DB) that was doing very little other than idling and receiving the odd data 
request to process. This was just running in an Azure VM.

We were using it mainly for integration testing - so changes were reliant upon 
the other partners invoking our system.

When we used the 'defaults' our bill was close to $200 / month. I was rather 
astounded at the cost - I can get a full VM in a DC in AU for < $90 /mth, 
probably better if I hunted around.

But doing a lot of hunting around I managed to move us to a smaller plan and we 
are down to closer to $20 / month which is more what I expected given our load.

Two things that hit me while doing this :

* It's rather difficult to figure out where your costs are, and how to lower 
them / control them.
* There are a lot of options that you are given by default that you dont need 
(but I think a lot of that is just us learning the ropes).
* Azure SQL is not the full SQL Server :) [that caught us].

Anyhow - just our experiences...

Rob Andrew

AEGIS SOFTWORKS PTY LTD


- Original Message -
From: Greg Keogh [mailto:gfke...@gmail.com]
To: ozdotnet@ozdotnet.com
Sent: Wed, 30 Dec 2015 10:15:33 +1100
Subject:

Hi folks, anyone working this week? (if you're not, then you should be tweaking 
your hobby code).

Because I get free Azure quotas as part of my MSDN subscription, and because I 
never push Azure really hard, I don't have a feel for what is costs in a 
typical business environment. Is anyone here using Azure as part of a small to 
medium sized business app, perhaps with a SQL database and some blobs and 
tables? If so, what magnitude of monthly bills do you receive?

I ask, because more often I suggest to people that they push their apps and 
work into the cloud, but if I'm asked what the cost is like I can't give them a 
comparison or a ballpark figure. Perhaps someone here has had typical realistic 
experience in this.

I also ask because most Azure Team news broadcast emails I receive contains 
words like "This change may cause a price increase on your monthly Azure bill" 
(as the last one did). I only ever seem to get notifications of price increases 
and it really makes me nervous about recommending it to anyone.

Cheers,
Greg K

Re: [OT] Azure pricing

[Craig van Nieuwkerk]

We run www.youreontime.com on it and it costs about $350 per month. This
includes SQL Azure S2, 2 x Standard WebApps, several shared WebApps, Redis
Cache, 1 x Small VM and heaps of blog and table storage.

Craig

On Wed, Dec 30, 2015 at 10:15 AM, Greg Keogh  wrote:

> Hi folks, anyone working this week? (if you're not, then you should be
> tweaking your hobby code).
>
> Because I get free Azure quotas as part of my MSDN subscription, and
> because I never push Azure really hard, I don't have a feel for what is
> costs in a typical business environment. Is anyone here using Azure as part
> of a small to medium sized business app, perhaps with a SQL database and
> some blobs and tables? If so, what magnitude of monthly bills do you
> receive?
>
> I ask, because more often I suggest to people that they push their apps
> and work into the cloud, but if I'm asked what the cost is like I can't
> give them a comparison or a ballpark figure. Perhaps someone here has had
> typical realistic experience in this.
>
> I also ask because most Azure Team news broadcast emails I receive
> contains words like "This change may cause a price increase on your monthly
> Azure bill" (as the last one did). I only ever seem to get notifications of
> price increases and it really makes me nervous about recommending it to
> anyone.
>
> Cheers,
> *Greg K*
>