|
|
You're in the
sql server reporting services
group:Charting a large number of values causes problems
sql server reporting services:
basis. Most of the time this chart only displays a handful of values and renders quite quickly. I had a situation recently though where the chart tried to render 2100 values and the report took around 15 or 20 minutes to render. A check of our database server has shown that the SQL query that returns the data is executing in under a second. When I checked the Task Manager on the web server I found that w3wp.exe was running at almost 100%. I would have thought that 2100 data points was not an unreasonable number of points to plot. Does anyone know if the rendering speed of charts has been improved in SSRS 2005? Is it worth upgrading? -- Regards
Hello Martin,
Based on my experience, generally the SSRS 2005 render the charts as quick as SSRS 2000. I would like to know whether this issue appeared on the specify report or on all the report. From your description, this issue seems to related with the report rendering. I would like to suggest you use the Report Cache and the Report Snapshot as a workaround. The Report Cache will cache the report in the tempdb and you may get higher performance. Performance issues can be difficult to troubleshoot and resolve in a newsgroup setting due to the number of variables and the amount of time required to narrow down possible causes and observe the effects. We will assist as best as we can, but you may wish to consider contacting CSS for a more timely resolution for these type issues. To obtain the phone numbers for specific technology request please take a look at the web site listed below. http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS If you are outside the US please see http://support.microsoft.com for regional support phone numbers. Thank you for your patience and understanding. Sincerely, Wei Lu Microsoft Online Community Support ================================================== Get notification to my posts through email? Please refer to http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif ications. Note: The MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from the community or a Microsoft Support Engineer within 1 business day is acceptable. Please note that each follow up response may take approximately 2 business days as the support professional working with you may need further investigation to reach the most efficient resolution. The offering is not appropriate for situations that require urgent, real-time or phone-based interactions or complex project analysis and dump analysis issues. Issues of this nature are best handled working with a dedicated Microsoft Support Engineer by contacting Microsoft Customer Support Services (CSS) at http://msdn.microsoft.com/subscriptions/support/default.aspx. ================================================== (This posting is provided "AS IS", with no warranties, and confers no rights.)
This issue occurs only on a specific report where the chart contains a large
number of values (2100). I have cached the report and this has decreased the render time to 5 minutes. This is still pretty high but I suppose we will just have to live with it. -- Regards Martin [quoted text, click to view] "Wei Lu [MSFT]" wrote:
> Hello Martin, > > Based on my experience, generally the SSRS 2005 render the charts as quick > as SSRS 2000. I would like to know whether this issue appeared on the > specify report or on all the report. From your description, this issue > seems to related with the report rendering. I would like to suggest you use > the Report Cache and the Report Snapshot as a workaround. The Report Cache > will cache the report in the tempdb and you may get higher performance. > > Performance issues can be difficult to troubleshoot and resolve in a > newsgroup setting due to the number of variables and the amount of time > required to narrow down possible causes and observe the effects. We will > assist as best as we can, but you may wish to consider contacting CSS for a > more timely resolution for these type issues. > > To obtain the phone numbers for specific technology request please take a > look at the web site listed below. > http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS > > If you are outside the US please see http://support.microsoft.com > for regional support phone numbers. > > > Thank you for your patience and understanding. > > Sincerely, > > Wei Lu > > Microsoft Online Community Support > > ================================================== > > Get notification to my posts through email? Please refer to > http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif > ications. > > Note: The MSDN Managed Newsgroup support offering is for non-urgent issues > where an initial response from the community or a Microsoft Support > Engineer within 1 business day is acceptable. Please note that each follow > up response may take approximately 2 business days as the support > professional working with you may need further investigation to reach the > most efficient resolution. The offering is not appropriate for situations > that require urgent, real-time or phone-based interactions or complex > project analysis and dump analysis issues. Issues of this nature are best > handled working with a dedicated Microsoft Support Engineer by contacting > Microsoft Customer Support Services (CSS) at > http://msdn.microsoft.com/subscriptions/support/default.aspx. > > ================================================== > (This posting is provided "AS IS", with no warranties, and confers no > rights.) >
Hello Martin,
I am not sure why you have a large number of values in the chart. Do you mean you have 2100 records in the database ? Have you use any complex expression in the chart? Sincerely, Wei Lu Microsoft Online Community Support
When the report loads it requests a couple of parameters from the user (Year
and month). For Aug 2006 the SQL query just happens to return around 2100 records. The query executes in under a second. Two values are then selected from each record and plotted as points on a line chart. There are no complex expressions used in the chart. -- Regards Martin [quoted text, click to view] "Wei Lu [MSFT]" wrote:
> Hello Martin, > > I am not sure why you have a large number of values in the chart. > > Do you mean you have 2100 records in the database ? > > Have you use any complex expression in the chart? > > Sincerely, > > Wei Lu > > Microsoft Online Community Support > > > >
Hello Martin,
I have tested on my side. I use the AdventureWorks databases in a SQL 200 database and I add a Line Chart in the report. The dataset will return about 12000 records and I use the Parameter in the dataset filter. Then the chart will render in about 10 second either in the VS design preview or in the Report Server. Since you use the parameter in the report, I would like to suggest you use the Parameter in the dataset filter to filter the data. So that, the dataset will return all the data at the first time and if you change the Parameter value, the report do not need to query the database again and this will enhance the performance of the Chart Render. Sincerely, Wei Lu Microsoft Online Community Support
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |