none
Performance issue in SSRS map

    Question

  • Hi All,

    For one of my dashboard requirements, I was visualizing revenue information using SSRS MAP (using color codes). I stored all the geography information about the countries in a SQL table. I created a dataset in SSRS, using this table to give input to the map. The map is working fine without any error.

    The problem I face is, it is taking around 10 minutes to render this report in reporting server.

    Please suggest me some techniques to improve the performance.

    Wednesday, September 25, 2013 9:43 AM

Answers

  • Take a look also at

    http://msdn.microsoft.com/en-us/library/bb522806.aspx         -         Troubleshooting Reports Performance

    http://msdn.microsoft.com/en-us/library/bb522786.aspx         -         Reporting Services Performance

      

    Friday, September 27, 2013 8:00 AM
  • Hi Ganesh,

    From your description, it takes long time to render the report, right? This is a performance issue, Report server performance is affected by a combination of factors. The total time to generate a reporting server report (RDL) can be divided into three elements: Time to retrieve the data (TimeDataRetrieval), Time to process the report (TimeProcessing), Time to render the report (TimeRendering). We can review the report server execution log to find out how long each processing takes to process. Please refer to the following article about report performance:
    Troubleshooting Reports: Report Performance

    Hope this helps.

    Regards,


    Charlie Liao
    TechNet Community Support

    Friday, September 27, 2013 7:31 AM
    Moderator
  • Hi All,

    Thanks for the information.

    This issue is now resolved. In my case TimeDataRetrieval and TimeRendering were taking more time

    1. To improve TimeDataRetrieval, i created summary table and retrieved data from that table.

    2. To improve TimeRendering, I embedded the spatial data in RDL itself.

    Above two solved my issue.

    • Marked as answer by Ganesh_Sundar Monday, October 07, 2013 5:51 AM
    Monday, October 07, 2013 5:51 AM

All replies

  • Hi Ganesh,

    From your description, it takes long time to render the report, right? This is a performance issue, Report server performance is affected by a combination of factors. The total time to generate a reporting server report (RDL) can be divided into three elements: Time to retrieve the data (TimeDataRetrieval), Time to process the report (TimeProcessing), Time to render the report (TimeRendering). We can review the report server execution log to find out how long each processing takes to process. Please refer to the following article about report performance:
    Troubleshooting Reports: Report Performance

    Hope this helps.

    Regards,


    Charlie Liao
    TechNet Community Support

    Friday, September 27, 2013 7:31 AM
    Moderator
  • Take a look also at

    http://msdn.microsoft.com/en-us/library/bb522806.aspx         -         Troubleshooting Reports Performance

    http://msdn.microsoft.com/en-us/library/bb522786.aspx         -         Reporting Services Performance

      

    Friday, September 27, 2013 8:00 AM
  • Hi All,

    Thanks for the information.

    This issue is now resolved. In my case TimeDataRetrieval and TimeRendering were taking more time

    1. To improve TimeDataRetrieval, i created summary table and retrieved data from that table.

    2. To improve TimeRendering, I embedded the spatial data in RDL itself.

    Above two solved my issue.

    • Marked as answer by Ganesh_Sundar Monday, October 07, 2013 5:51 AM
    Monday, October 07, 2013 5:51 AM