VENTAS: 1-800-867-1389

 none
What kind of session is better to use for SSRS Azure?

    Pregunta

  • Hi,

    We are using Azure SSRS in a web application hosted in Azure. In current version we are using InProcess mode for session because of reporting services. This limits us to a single instance for that webrole but reports performances are acceptable. We tried to use SqlServer session provider or AppFabricCacheSessionStoreProvider but the reports runs very slow and a lot of them are not loading. 

    Did you use Azure Reporting Services in production? What kind of session is better to use for SSRS Azure?

    Thank you,

    Flaviu

    lunes, 05 de marzo de 2012 17:40

Respuestas

  • Hi again Flaviu... 

    Have you tried with a VS2011 beta version available today? Try to use (for testing and see if any improvement) the new ReportViewer in this Visual Studio version. It seems that it has some issues fixed that could affect at the way reports are rendered (from SQL Azure reporting) in an ASP.NET application

    Please if you consider this reply useful, mark it in consecuence, and if not, please provide feedback to know how to improve our support. Let us know if any performance improvement with this new version of the control

    Thanks!


    Maick · augurarte :: Albacete · Spain : Guia practica Expression Web, Anaya Multimedia

    jueves, 08 de marzo de 2012 23:28

Todas las respuestas

  • Hi Flaviu,

    Microsoft SQL Azure Reporting provides a complete, cloud-based platform designed to support a wide variety of reporting needs enabling organizations to deliver relevant information where needed across the entire enterprise. Now developers can deliver highly visual, interactive reports as an integrated part of a Windows Azure-based solution.

    So we usually have two direction of using SQL Azure Reporting, that is deploy the report to SQL Azure report server, then manage the report via Azure Portal, another direction is integrate the SQL Azure reports into Windows Azure application, for the detail steps about these two scenarios, you can refer to this lab http://msdn.microsoft.com/en-us/wazplatformtrainingcourse_introtosqlazurereporting_topic2 

    Thanks,


    Challen Fu

    TechNet Community Support

    martes, 06 de marzo de 2012 6:32
    Moderador
  • Hi Flaviou

    We are using SQL Azure Reporting in production. We have used Azure AppFabric Cache with good results but you have to take into account some key factors regarding code-near pattern. Yo tell that you use an Azure application to access reports. So you should have your SQL Azure database and your SQL Azure reporting server in the same Azure datacenter in order to get the most of your application and desiderably the Web application should  be at the same datacenter too. Is this the case?

    If not, please provide more info, due as mentionend in our case we are using SAR with a customers with no problems.

    Please if you consider this reply useful, mark it in consecuence, and if not, please provide feedback to know how to improve our support.

    Thans!


    Maick · augurarte :: Albacete · Spain : Guia practica Expression Web, Anaya Multimedia

    martes, 06 de marzo de 2012 6:47
  • Hi Miguel,

    Yes we have SQL Azure database, SSRS and the web role in the same data center. Some reports have up to 100000 rows but even small reports with a few hundred rows and are not loading.

    Thank you for your reply,

    Flaviu

    martes, 06 de marzo de 2012 11:54
  • Hi,

    We have both type of reports (local and remote) in our application. We have started with local version last year but after SSRS was available in Azure we start using server version. Both type of reports work but remote reports doesn't work with AppFarbric Cache session provider.

    I have tested all the reports in windows azure portal and VS 2008 preview.

    Thank you

    martes, 06 de marzo de 2012 12:03
  • Hi again Flaviu... 

    Have you tried with a VS2011 beta version available today? Try to use (for testing and see if any improvement) the new ReportViewer in this Visual Studio version. It seems that it has some issues fixed that could affect at the way reports are rendered (from SQL Azure reporting) in an ASP.NET application

    Please if you consider this reply useful, mark it in consecuence, and if not, please provide feedback to know how to improve our support. Let us know if any performance improvement with this new version of the control

    Thanks!


    Maick · augurarte :: Albacete · Spain : Guia practica Expression Web, Anaya Multimedia

    jueves, 08 de marzo de 2012 23:28