Performance Issuses with SSRS [closed]

Question

hello guys recently i joined a company. They assigned me a task is to improve the performance of existing SSRS Reports .

i looked at the Stored Procedure's which are running fine .But when it comes to Report execution it's taking time .

Please let me know how to start on this thing? Thanks in Advance

Answer 1

1. Is the report doing it's own calculations on the data that is returned which could potentially take time and resources to accomplish?

2. Is the report drawing graphs that have lots and lots of datapoints which may take longer to reproduce than a graph with a larger increment?

3. Is the report loading images? How are the images handled? Are they embedded or linked from an outside source?

4. Are you creating a lot of groups or drill downs which could take time on the report loading to create?

Answering these questions may start to point you in the correct direction as far as how to make your report more efficient.

Answer 2

You could look at the ExecutionLog table in the ReportServer database. This will give you the break-up of times like data retrieval, processing, rendering etc. This could get you going in the right direction.

For example, in my previous project rendering reports in MS Excel was taking a lot of time - we switched some reports to be exported by default to CSV format and that helped. Similarly, we also identified bottleneck in the report processing and added more resources to the machine. This helped too.

Answer 3

You can also use the the SSRS Dashboard to view performance and config of the SSRS. http://sqlconcept.com/tools/ssrs-dashboard/

Answer 4

What do you mean by 'the stored procedures are running fine'? You might want to investigate this further.

• Run the stored procedures from SSMS and view the query plans it generates. C
• Check that the tables are indexed appropriately to speed up the queries
• Identify and eliminate cruft like unnecessary joins, unneeded selected columns,etc

Answer 5

You can also try for custom paging on reports which showing huge amount of data. By doing this you reduceded cashing time and only showing limited number of records instead of loading whole data at first time.