Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

At the moment, it costs $119 per month to use Azure SQL Reporting services. We want to make the move to Azure SQL Reporting/SSRS as our reporting capabilities are expected to grow quite dramatically over the next couple of years.

Right now, only a few reports are run per month. This does not warrant spending $119.

Options:

  1. Hosting SSRS in an Azure VM. This will cut the price in half if a Small VM is used ($67 per month). The problem with this solution is the overhead of maintaining the server, but the ease of moving to Azure SQL Reporting services (when the time comes due to high load) shouldn't be too difficult.

  2. Use an alternative reporting engine. I've had a look at Izenda, DevExpress and Telerik, but they are expensive (around $600 except for Izenda which has no price listing).

  3. Deploying Azure SQL Reporting services when required. I haven't explored this option thoroughly, but we could delete the Azure SQL Reporting deployment after use and recreate it before needing it. Perhaps we can automate this to deploy at 8am and delete at 6pm. This would cut the cost in half, but I am not sure of the logistics here.

Any advice would help! Thanks

Original question was posted here but marked as off-topic.

share|improve this question
    
given this statement "reporting capabilities are expected to grow quite dramatically" I think I'd just pay the $119/month to get the full understanding of the process. my .000001 cents worth. –  tony roth Aug 27 '13 at 13:47
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.