HI, I use reportserver to embed my SSRS reports in web application. But when I call report from reportserver, I have severe performance issues: Parameters combo boxes are slow to open report execution takes lopng time to complete When I open the same reports in Report Manager, performances are much better than ReportServer. Why ReportServer is slower? As I said before, I need to pass by ReportServer to embed report calls in my custom application. When I navigate to http://MyServer/reportServer using IE and call the same reports, I still get performance isues. Thanks Ccote

Hi ccote, Based on your scenario, I would give you steps to troubleshoot this unusual performance issue: You can make use of the Trace Log, when you need to troubleshoot report server operations, you can review Trace Log generated by Reporting services. Trace logs include records application log events, errors and exceptions, low resource warnings, report delivery details, and other details about reporting services operations. You can use any text editor to view the file. This file is located at \Microsoft SQL Server\<SQL Server Instance>\Reporting Services\LogFiles. For more information about Trace log please see http://msdn.microsoft.com/en-us/library/ms156500(v=SQL.105).aspx In addition, you can make use of Performance counter to monitor report server, this counter can help you understand how reporting services is using system resources during on-demand or scheduled report execution. Reporting services includes the following performance objects: · MSRS 2008 Web Service, which is to monitor report server performance. This performance object includes a collection of counters used to track report server processing typically initiated through interactive report viewing operations. These counters are reset whenever ASP.NET stops the Report Server Web service. · MSRS 2008 Windows Service, which is to monitor scheduled operations and report delivery. This performance object includes a collection of counters used to track report processing that is initiated through scheduled operations. Scheduled operations include subscription and delivery, report execution snapshots, and report history. · ReportServer:Service to monitor HTTP-related events and memory management. These counters are specific to Reporting Services, and they track HTTP-related events for the report server, such as requests, connections, and logon attempts. For more information about Windows Performance Counters, please see: http://msdn.microsoft.com/en-us/library/ms159809(v=SQL.105).aspx Currently, if this issue are urgent to your business, you could also contact Microsoft Customer Support Services (CSS) via telephone so that a dedicated Support Professional can assist you in a more efficient manner. However contacting phone support will be a charged call. but it will be free if this is a product issue. 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 Regards, Challen Fu Please remember to mark the replies as answers if they help and unmark them if they provide no help.