Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SSRS vs Azure SQL Reporting - Cost and Implementation

I have currently implemented some reports for a demo project using Azure reporting and Report builder. Now we are going to develop the reports properly I have a few questions about SSRS.

  1. We need subscription and scheduling so I guess we have to set up a SSRS server, can this be hosted on Azure or where is a good place? We have no servers of our own.
  2. What cost is involved for licensing?
  3. Our application is an MVC 4 app and I believe this may cause problems for hosting the report viewer (no post backs). What would be the best approach for an integrated experience for running the reports?

Thank you

like image 951
user2329438 Avatar asked Jun 06 '13 15:06

user2329438


People also ask

How much does SQL Server reporting services cost?

Effective today, the price for Windows Azure SQL Reporting will decrease from $0.88 per hour for every 200 reports to $0.16 per hour for every 30 reports.

Does SSRS exist in Azure?

Deploying SSRS on SQL Server on Azure Virtual Machine If you are rather interested in a quick lift and shift of your existing SSRS solution, you can simply deploy SSRS on Azure Virtual Machine, just like on any (virtual) machine on premises.

How much does it cost to run SQL on Azure?

The price is $0.5218 per vCore hour and $0.115 per GB-month. Additional data charges: If you need point-in-time restore, you'll pay $0.20 per GB-month for backup storage.

Is Azure SQL expensive?

The price is 24 USD per month and 0.032 USD per hour. By the other hand, the cheapest option for an Azure SQL databases is 5 USD per month. In SQL Server on Azure VMs, the price depends on the number of Cores and the SQL Edition. The more cores, the more expensive it is.


1 Answers

Be aware that Microsoft's recommendation of installing ssrs on one Azure VM using the SQL Enterprise gallery image will cost you over $1600 per month and does not meet the requirement of two instances for Microsoft's SLA and does not provide High Availability (HA). We are pretty frustrated with Microsoft right now about this.

like image 52
Robbie Avatar answered Sep 29 '22 00:09

Robbie