Free Trial *Internet Service Required
Windows Azure Platform > Windows Azure Forums > SQL Azure > Increase Azure Reporting performance by adding more CPU

Answered Increase Azure Reporting performance by adding more CPU

    •  
      Wednesday, November 02, 2011 1:24 PM
       
       
      Sign In to Vote
      1
      Sign In to Vote

      Hello.

      I have several Azure Reports that consist of only one Tablix, which holds textboxes, gauges and indicators.

      The queries take <1 second to run, but rendering the report takes between 5-15 seconds.

      Here is one example from the Execution log.

      ItemAction TimeDataRetrieval TimeProcessing TimeRendering RowCount
      Render 837 1478 5074 32

      My assumption is that it is the gauges and indicators that take this time because I have set calculated values for the Pointer, Scale and Range.

      I would really like to improve performance without changing the design of the reports. Is it possible to increase performance by adding CPU Power to the Azure Reporting server?


      • Edited by Joel S Wednesday, November 02, 2011 2:17 PM
      •  
       

    Answers