May 29, 2014 at 7:57 am
Hi all
I have a report created in SSRS 2008 R2 that acts as a dashboard for the business where different users from across the business can open the report to view information specific to their area.
This report works very well but renders very slow for some users, sometimes taking 5 minutes to load.
How can I improve the efficiency of my report and what can be causing the slow render?
I can share the rdl file if it can help you to assist me.
Regards
Scelo
May 29, 2014 at 9:28 am
How frequently does the data on this dashboard need to be updated? Is it an hourly thing, daily thing or up to the second type of thing?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 29, 2014 at 9:29 am
Also, with it being slow for some, it sounds like it works quickly for others. Is that a valid assertion?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 30, 2014 at 12:12 am
Hi
The dashboard is a live one where the user will open it whenever they want and it will show latest stats.
Your ascertion is correct, the dashboard renders quickly for some users and slow for one user (I must add that it is slow on the user that has the largest department so yes there is more data to pull for this one user).
Thanks
May 30, 2014 at 9:11 am
Is it all render time or does the query run slowly too?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 1, 2014 at 11:49 pm
The query executes quite fast but the render time is slow.
June 2, 2014 at 7:44 am
On the box where SSRS is running, you might want to allocate more memory for SSRS. If it is the same box as SQL Server, then you may need to decrease max memory for SQL, config SSRS config file and also make sure you have enough memory left over for the OS.
Since the one person running the report seems to have the largest amount of data to render in report format, it appears memory related.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 25, 2014 at 6:40 pm
I am curious if the report accesses the same tables set for all users, if not then look at index maintenance on the tables used by the slow user.
----------------------------------------------------
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply