I realize this is a question about SSRS 2005, but I have exhausted my knowledge on trying to resolve this. I utilize SSRS 2005 Enterprise in SSRS Web Farm, using SQL 2005 as backend catalog. Before this issue, I had 3 servers in farm, and they perform very fast. I have a business need to add a SSRS #4 to the farm. The only difference between #1-3 and #4 is hardware and OS levels. Once I completed the setups and joined the new #4 to the farm, #4 performs horribly while #1-3 continue to fly. Below I've pasted some info, including info on performance. InstanceName Execution_Count TimeDataRetrieval TimeProcessing TimeRendering TotalTime =========== ============== ================= ============== ============= ========= BPGBYQPR1 31325 0.0117 0.1888 0.0000 0.2005 BPGBYQPR2 32081 0.0003 0.1976 0.0002 0.1980 BPGBYQPR3 31775 0.0003 0.1946 0.0001 0.1950 BPGBYQPR4 1018 0.0000 5.4337 0.0000 5.4337 I have tried a multitude of areas to find the problem. I have a differnt server running Win2008 and SQL and SSRS 2005, and have no issues - and I've compared setups (IIS, SSRS config files, etc) with no difference found. Below I've pasted rsreportserver.config from #1 and #4, and compared them column to column in Excel, and see no differences. I had my server team disable the AV (TrendMicro OfficeScan v10 SP1) and had no changes in performance. The SSRS Config program also performs slowly. Other programs on the server appear to run without slowdowns. I would appreciate any and all insight of what I can check next to find the peformance flaw. I hope to make this new box PROD soon. Here is info on our #1 server (same for #2-3): =========== =========== =========== Microsoft SQL Server Reporting Services Version 9.00.4207.00 en-US Eastern Standard Time d:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\LogFiles\ReportServerWebApp__01_28_2011_14_38_55.log BPGBYQPR1 Microsoft Windows NT 5.2.3790 Service Pack 2 5.2.3790.131072 Here is info on our NEW #4 server: =========== =========== =========== Microsoft SQL Server Reporting Services Version 9.00.4207.00 en-US Eastern Standard Time D:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\LogFiles\ReportServerService__01_28_2011_15_59_50.log BPGBYQPR4 Microsoft Windows NT 6.0.6002 Service Pack 2 6.0.6002.131072 I will post followups with rsreportserver.config for #1 and #4 (due to body length restrictions for each post)

Here is 1st 1/2 rsreportserver.config on our #1 server (same for #2-3): <Configuration> <Dsn>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAK/EslFlzgke2L9xbiqFmIQQAAAAiAAAAUgBlAHAAbwBy AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAPIRbLcysF24eVjBq9Bp2WAAAAAA BIAAAKAAAAAQAAAA/1KsP5N+Hm43v6MqJH+6hCgBAADJSU9o8otuMfYAEbFYCoEE6aE6Ibb2nsTh EvUlcQ3YJ1ctHixoR0KSuhAloPYslenu1c24pBuUaUqZOOdTueyiTN+BRLxv7qlHfYogOYkhsG+7 N0sPwq8R44elv7BoUzB8DsZSbHClAHDiRju4lRDMTr99o82hnVDy2tJRpcIX0uknaBWVez/0rCQy kCVM+7K5FBXMgPsvCi3uo0GWS7SBZufaLzrjgb0CkrTR6WTbNsejc3q/+WUF8MHgCOZ5hM3e/XSm PT8DpVyPGBYF46fLj9waGtWkytEFx9vUQ7dmvaZcVqayQs7gpL+Hv5AMCOhJaLT420QiraCd+Pz6 OpufLpstZvZL7QXMBFjU6J9tmdcERMZGkCh7aBBv71kRMSnZfKxFjQxcOxQAAADHOIGHtlI+Eyuk XQiX6MfZ3wro4A==</Dsn> <ConnectionType>Default</ConnectionType> <LogonUser></LogonUser> <LogonDomain></LogonDomain> <LogonCred></LogonCred> <InstanceId>MSSQL.1</InstanceId> <InstallationID>{eb8bc1b8-01ff-425c-aad8-b1bdd5cdb080}</InstallationID> <Add Key="SecureConnectionLevel" Value="0" /> <Add Key="ProcessRecycleOptions" Value="0" /> <Add Key="CleanupCycleMinutes" Value="60" /><!-- DBA changed to 60 min cycles to clear ReportServerTempDB--> <Add Key="SQLCommandTimeoutSeconds" Value="60" /> <Add Key="MaxActiveReqForOneUser" Value="150" /><!-- DBA set to 150 allow for large # of APP user logins (MP2, LISA) --> <Add Key="DatabaseQueryTimeout" Value="240" /><!-- DBA set to 240 to increase connection to the report server database time out--> <Add Key="RunningRequestsScavengerCycle" Value="60" /> <Add Key="RunningRequestsDbCycle" Value="60" /> <Add Key="RunningRequestsAge" Value="30" /> <Add Key="MaxScheduleWait" Value="5" /> <Add Key="DisplayErrorLink" Value="true" /> <Add Key="WebServiceUseFileShareStorage" Value="false" /> <!--<Add Key="WatsonFlags" Value="0x0430" /> full dump--> <!--<Add Key="WatsonFlags" Value="0x0428" /> minidump --> <!--<Add Key="WatsonFlags" Value="0x0002" /> no dump--> <Add Key="WatsonFlags" Value="0x0428" /> <Add Key="WatsonDumpOnExceptions" Value="Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException" /> <Add Key="WatsonDumpExcludeIfContainsExceptions" Value="System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException" /> <Service> <IsSchedulingService>True</IsSchedulingService> <IsNotificationService>True</IsNotificationService> <IsEventService>True</IsEventService> <PollingInterval>10</PollingInterval> <WindowsServiceUseFileShareStorage>False</WindowsServiceUseFileShareStorage> <MemoryLimit>60</MemoryLimit> <RecycleTime>1440</RecycleTime> <MaximumMemoryLimit>80</MaximumMemoryLimit> <MaxAppDomainUnloadTime>30</MaxAppDomainUnloadTime> <MaxQueueThreads>1</MaxQueueThreads> <UrlRoot>http://bpgbyqpr1/reportserver</UrlRoot> <UnattendedExecutionAccount> <UserName>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAK/EslFlzgke2L9xbiqFmIQQAAAAiAAAAUgBlAHAAbwBy AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAGu7rEVmnp5RgDDByQWMc3wAAAAA BIAAAKAAAAAQAAAArLn0bVbWjn8b/ARtf2/i+igAAAChfK3GaPwxCL2p0iiGsPABuAFidbr411LN jJkEQFuc3I8jFt83snqnFAAAAHWr+GgBlUVxDxvXJBLVy+NQdxRj </UserName> <Password>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAK/EslFlzgke2L9xbiqFmIQQAAAAiAAAAUgBlAHAAbwBy AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAHz4mX4LOMT+uz535x6AT0wAAAAA BIAAAKAAAAAQAAAAt9g6zjf6yI3WckqtvGsJTRgAAABTsE0Tnn3l4VZ0/0LeUDgdd9ApRr1sFRYU AAAA5FI+GlngDyIRFW2eG3GdZswQJu0=</Password> <Domain>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAK/EslFlzgke2L9xbiqFmIQQAAAAiAAAAUgBlAHAAbwBy AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAG6haEpt7cqVpjtY/Wzuw7QAAAAA BIAAAKAAAAAQAAAASST0lATXtuNoyP/PHuKg8RAAAABKd9VPQOGcwD4hteg5kjmqFAAAAAMrNrvd 1QcbkOvpznKEpeBna3r+ </Domain></UnattendedExecutionAccount> <PolicyLevel>rssrvpolicy.config</PolicyLevel> <WebServiceAccount>NT Authority\NetworkService</WebServiceAccount> <IsWebServiceEnabled>True</IsWebServiceEnabled> <FileShareStorageLocation> <Path></Path> </FileShareStorageLocation> </Service> <Extensions> <Delivery> <Extension Name="Report Server FileShare" Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider">

Here is 2nd 1/2 rsreportserver.config on our #1 server (same for #2-3): <MaxRetries>3</MaxRetries> <SecondsBeforeRetry>900</SecondsBeforeRetry> <Configuration> <FileShareConfiguration> <ExcludedRenderFormats> <RenderingExtension>HTMLOWC</RenderingExtension> <RenderingExtension>NULL</RenderingExtension> <RenderingExtension>RGDI</RenderingExtension> </ExcludedRenderFormats> </FileShareConfiguration> </Configuration> </Extension> <Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider"> <MaxRetries>3</MaxRetries> <SecondsBeforeRetry>900</SecondsBeforeRetry> <Configuration> <RSEmailDPConfiguration> <SMTPServer>GPOCS.rr.gapac.com</SMTPServer> <SMTPServerPort></SMTPServerPort> <SMTPAccountName></SMTPAccountName> <SMTPConnectionTimeout></SMTPConnectionTimeout> <SMTPServerPickupDirectory></SMTPServerPickupDirectory> <SMTPUseSSL></SMTPUseSSL> <SendUsing>2</SendUsing> <SMTPAuthenticate></SMTPAuthenticate> <From>BPReportServer@gapac.com</From> <EmbeddedRenderFormats> <RenderingExtension>MHTML</RenderingExtension> </EmbeddedRenderFormats> <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats> <ExcludedRenderFormats> <RenderingExtension>HTMLOWC</RenderingExtension> <RenderingExtension>NULL</RenderingExtension> <RenderingExtension>RGDI</RenderingExtension> </ExcludedRenderFormats> <SendEmailToUserAlias>False</SendEmailToUserAlias> <DefaultHostName></DefaultHostName> <PermittedHosts> </PermittedHosts> </RSEmailDPConfiguration> </Configuration> </Extension> <Extension Name="NULL" Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider" /> <Extension Name="Report Server DocumentLibrary" Type="Microsoft.ReportingServices.SharePoint.SharePointDeliveryExtension.DocumentLibraryProvider,ReportingServicesSharePointDeliveryExtension"> <MaxRetries>3</MaxRetries> <SecondsBeforeRetry>900</SecondsBeforeRetry> <Configuration> <DocumentLibraryConfiguration> <ExcludedRenderFormats> <RenderingExtension>HTMLOWC</RenderingExtension> <RenderingExtension>NULL</RenderingExtension> <RenderingExtension>RGDI</RenderingExtension> </ExcludedRenderFormats> </DocumentLibraryConfiguration> </Configuration> </Extension> </Delivery> <Render> <Extension Name="XML" Type="Microsoft.ReportingServices.Rendering.XmlDataRenderer.XmlDataReport,Microsoft.ReportingServices.XmlRendering" /> <Extension Name="NULL" Type="Microsoft.ReportingServices.Rendering.NullRenderer.NullReport,Microsoft.ReportingServices.NullRendering" Visible="false" /> <Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering" /> <Extension Name="IMAGE" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.ImageReport,Microsoft.ReportingServices.ImageRendering" /> <Extension Name="PDF" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport,Microsoft.ReportingServices.ImageRendering" /> <Extension Name="RGDI" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.RemoteGdiReport,Microsoft.ReportingServices.ImageRendering" Visible="false" LogAllExecutionRequests="false" /> <Extension Name="HTML4.0" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html40RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false" LogAllExecutionRequests="false" /> <Extension Name="HTML3.2" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html32RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false" /> <Extension Name="MHTML" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.MHtmlRenderingExtension,Microsoft.ReportingServices.HtmlRendering" /> <Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering" /> </Render> <Data> <Extension Name="SQL" Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,Microsoft.ReportingServices.DataExtensions" /> <Extension Name="OLEDB" Type="Microsoft.ReportingServices.DataExtensions.OleDbConnectionWrapper,Microsoft.ReportingServices.DataExtensions" /> <Extension Name="OLEDB-MD" Type="Microsoft.ReportingServices.DataExtensions.AdoMdConnection,Microsoft.ReportingServices.DataExtensions" /> <Extension Name="ORACLE" Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapper,Microsoft.ReportingServices.DataExtensions" /> <Extension Name="ODBC" Type="Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper,Microsoft.ReportingServices.DataExtensions" /> <Extension Name="XML" Type="Microsoft.ReportingServices.DataExtensions.XmlDPConnection,Microsoft.ReportingServices.DataExtensions" /> <Extension Name="SAPBW" Type="Microsoft.ReportingServices.DataExtensions.SapBw.SapBwConnection,Microsoft.ReportingServices.DataExtensions.SapBw" /> <Extension Name="ESSBASE" Type="Microsoft.ReportingServices.DataExtensions.Essbase.EssbaseConnection,Microsoft.ReportingServices.DataExtensions.Essbase" /> <Extension Name="SSIS" Type="Microsoft.SqlServer.Dts.DtsClient.DtsConnection,Microsoft.SqlServer.Dts.DtsClient, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" /> <Extension Name="Activplant Query Service" Type="Activplant.Data.DataExtension.QueryServiceConnection, QueryServiceDataProviderExtensions" /> <!-- <Extension Name="SAP" Type="Microsoft.Adapter.SAP.SAPConnection,Microsoft.Adapter.SAP.SAPProvider, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/> --> </Data> <SemanticQuery> <Extension Name="SQL" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.MSSQL.MSSqlSQCommand,Microsoft.ReportingServices.SemanticQueryEngine"> <Configuration> <EnableMathOpCasting>False</EnableMathOpCasting> </Configuration> </Extension> <Extension Name="ORACLE" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.Oracle.OraSqlSQCommand,Microsoft.ReportingServices.SemanticQueryEngine"> <Configuration> <EnableMathOpCasting>True</EnableMathOpCasting> <DisableNO_MERGEInLeftOuters>False</DisableNO_MERGEInLeftOuters> <EnableUnistr>False</EnableUnistr> <DisableTSTruncation>False</DisableTSTruncation> </Configuration> </Extension> <Extension Name="OLEDB-MD" Type="Microsoft.AnalysisServices.Modeling.QueryExecution.ASSemanticQueryCommand,Microsoft.AnalysisServices.Modeling" /> </SemanticQuery> <ModelGeneration> <Extension Name="SQL" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.MSSQL.MsSqlModelGenerator,Microsoft.ReportingServices.SemanticQueryEngine" /> <Extension Name="ORACLE" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.Oracle.OraSqlModelGenerator,Microsoft.ReportingServices.SemanticQueryEngine" /> <Extension Name="OLEDB-MD" Type="Microsoft.AnalysisServices.Modeling.Generation.ModelGeneratorExtention,Microsoft.AnalysisServices.Modeling" /> </ModelGeneration> <Security> <Extension Name="Windows" Type="Microsoft.ReportingServices.Authorization.WindowsAuthorization, Microsoft.ReportingServices.Authorization" /> </Security> <Authentication> <Extension Name="Windows" Type="Microsoft.ReportingServices.Authentication.WindowsAuthentication, Microsoft.ReportingServices.Authorization" /> </Authentication> <EventProcessing> <Extension Name="SnapShot Extension" Type="Microsoft.ReportingServices.Library.HistorySnapShotCreatedHandler,ReportingServicesLibrary"> <Event> <Type>ReportHistorySnapshotCreated</Type> </Event> </Extension> <Extension Name="Timed Subscription Extension" Type="Microsoft.ReportingServices.Library.TimedSubscriptionHandler,ReportingServicesLibrary"> <Event> <Type>TimedSubscription</Type> </Event> </Extension> <Extension Name="Cache Update Extension" Type="Microsoft.ReportingServices.Library.ReportExecutionSnapshotUpdateEventHandler,ReportingServicesLibrary"> <Event> <Type>SnapshotUpdated</Type> </Event> </Extension> </EventProcessing> <ReportItems> <ReportItem Name="DundasCalendarControl" Type="Dundas.ReportingServices.Calendar.DundasCalendar,DundasRSCalendar" /> <ReportItem Name="DundasChartControl" Type="Dundas.ReportingServices.DundasChart,DundasRSChart" /> <ReportItem Name="DundasGaugeControl" Type="Dundas.ReportingServices.DundasGauge,DundasRSGauge" /> <ReportItem Name="DundasMapControl" Type="Dundas.ReportingServices.Maps.DundasMap,DundasRSMap" /> <ReportItem Name="NeodynamicBarcodeControl" Type="Neodynamic.ReportingServices.BarcodeReportItem, Neodynamic.ReportingServices.Barcode" /> </ReportItems> </Extensions> </Configuration>

Here is 1st 1/2 rsreportserver.config on our NEW #4 server: <Configuration> <Dsn>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAfADPxsDYbkyPVBMrBQGwXgQAAAAiAAAAUgBlAHAAbwBy AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAHCoD+mBsI8nsOcnuf5YbMgAAAAA BIAAAKAAAAAQAAAAXeG+2p155/IOetVhjaU/higBAABcP0W/ySWAUrSW3VkiR1tqrAas2DZLsSe2 Ow6hhJQFm61Kb2tW80ZkaEQjo1nX40urli7JwZk1/XOF5iKbLR7TdajA8cP5/HjQ2hqpz5NyQomz PRFV90B2fsG9IcgWAixQHGPjt2pdxGBxCNzeQj4oHcfybkN/LdJ6DGqOs7TKF0c1GV9JJ6SUNaQP DxjikqNvu3FdlC+LACvQxCb4tlNFWzM1NL1rxqV7ATEiOPVxK5dg1q/FBu4G79249RSVAMjQgDmh stTrQjS6VPZoZtSDqEHflJcBNUzgTU1xanbbbUk150m52Ks2jAzYI91u/ZdK16j0g2fSfZpItavN yk7U8Z3pabeQb7tDHGk/ZQJsAnlqGltTE2SPvbDfwEe4/ZLMZzl7vf9jFBQAAACy8JIrOckrayP3 552CGkm1cLfkIQ==</Dsn> <ConnectionType>Default</ConnectionType> <LogonUser></LogonUser> <LogonDomain></LogonDomain> <LogonCred></LogonCred> <InstanceId>MSSQL.1</InstanceId> <InstallationID>{2a7d35f8-675e-4428-8996-d46413511989}</InstallationID> <Add Key="SecureConnectionLevel" Value="0"/> <Add Key="ProcessRecycleOptions" Value="0"/> <Add Key="CleanupCycleMinutes" Value="60"/><!-- DBA changed to 60 min cycles to clear ReportServerTempDB --> <Add Key="SQLCommandTimeoutSeconds" Value="60"/> <Add Key="MaxActiveReqForOneUser" Value="150"/><!-- DBA set to 150 allow for large # of APP user logins (MP2, LISA) --> <Add Key="DatabaseQueryTimeout" Value="240"/><!-- DBA set to 240 to increase connection for SSRS database time out--> <Add Key="RunningRequestsScavengerCycle" Value="60"/> <Add Key="RunningRequestsDbCycle" Value="60"/> <Add Key="RunningRequestsAge" Value="30"/> <Add Key="MaxScheduleWait" Value="5"/> <Add Key="DisplayErrorLink" Value="true"/> <Add Key="WebServiceUseFileShareStorage" Value="false"/> <!-- <Add Key="WatsonFlags" Value="0x0430" /> full dump--> <!-- <Add Key="WatsonFlags" Value="0x0428" /> minidump --> <!-- <Add Key="WatsonFlags" Value="0x0002" /> no dump--> <Add Key="WatsonFlags" Value="0x0428"/> <Add Key="WatsonDumpOnExceptions" Value="Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException"/> <Add Key="WatsonDumpExcludeIfContainsExceptions" Value="System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException"/> <Service> <IsSchedulingService>True</IsSchedulingService> <IsNotificationService>True</IsNotificationService> <IsEventService>True</IsEventService> <PollingInterval>10</PollingInterval> <WindowsServiceUseFileShareStorage>False</WindowsServiceUseFileShareStorage> <MemoryLimit>60</MemoryLimit> <RecycleTime>1440</RecycleTime><!-- DBA set to 1440 to allow daily recycle --> <MaximumMemoryLimit>80</MaximumMemoryLimit> <MaxAppDomainUnloadTime>30</MaxAppDomainUnloadTime> <MaxQueueThreads>1</MaxQueueThreads><!-- DBA set to 1 will allow you to use all of the memory for the report --> <UrlRoot>http://bpgbyqpr4/reportserver</UrlRoot> <UnattendedExecutionAccount> <UserName>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAfADPxsDYbkyPVBMrBQGwXgQAAAAiAAAAUgBlAHAAbwBy AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAALNSF6mjghPArFSyFvU2wwAAAAAA BIAAAKAAAAAQAAAAPqq/mDUBRiZhCJRadzvJ+CgAAAB9gktpUaCaux9SAJBc8+Q24dSBYjYSPT/j MAKtX5XA8zssNp4OgrYCFAAAAInh0JpMHzQgUNxshLfWyYw3LeJ5 </UserName> <Password>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAfADPxsDYbkyPVBMrBQGwXgQAAAAiAAAAUgBlAHAAbwBy AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAFNyaQ8H/WACy1lsW8i/2YYAAAAA BIAAAKAAAAAQAAAAKTqjmzBi/H4PGyqSNy1WVhgAAAB2vSgPKf7jIZLXl8JeiC8BF1ht3DvGf+YU AAAA52V+q/svgsIhMWGvn0Ag/ULIy+o=</Password> <Domain>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAfADPxsDYbkyPVBMrBQGwXgQAAAAiAAAAUgBlAHAAbwBy AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAMeLD7fUoAj5Sx1ZBazn3a8AAAAA BIAAAKAAAAAQAAAArHfZjRwpH8hlIZ01pHUeIxAAAABnVmwZarsIpIfOWXCX1rePFAAAAC5jGc1g GLPrrKjnxdL+Ncrvjg++ </Domain></UnattendedExecutionAccount> <PolicyLevel>rssrvpolicy.config</PolicyLevel> <WebServiceAccount>NT Authority\NetworkService</WebServiceAccount> <IsWebServiceEnabled>True</IsWebServiceEnabled> <FileShareStorageLocation> <Path></Path> </FileShareStorageLocation> </Service> <Extensions> <Delivery> <Extension Name="Report Server FileShare" Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider"> <MaxRetries>3</MaxRetries> <SecondsBeforeRetry>900</SecondsBeforeRetry> <Configuration> <FileShareConfiguration> <ExcludedRenderFormats> <RenderingExtension>HTMLOWC</RenderingExtension> <RenderingExtension>NULL</RenderingExtension> <RenderingExtension>RGDI</RenderingExtension> </ExcludedRenderFormats> </FileShareConfiguration> </Extension></Configuration> <Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider"> <MaxRetries>3</MaxRetries> <SecondsBeforeRetry>900</SecondsBeforeRetry> <Configuration> <RSEmailDPConfiguration> <SMTPServer>GPOCS.rr.gapac.com</SMTPServer> <SMTPServerPort></SMTPServerPort> <SMTPAccountName></SMTPAccountName> <SMTPConnectionTimeout></SMTPConnectionTimeout> <SMTPServerPickupDirectory></SMTPServerPickupDirectory> <SMTPUseSSL></SMTPUseSSL> <SendUsing>2</SendUsing> <SMTPAuthenticate></SMTPAuthenticate> <From>BPReportServer@gapac.com</From> <EmbeddedRenderFormats> <RenderingExtension>MHTML</RenderingExtension> </EmbeddedRenderFormats> <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats> <ExcludedRenderFormats> <RenderingExtension>HTMLOWC</RenderingExtension> <RenderingExtension>NULL</RenderingExtension> <RenderingExtension>RGDI</RenderingExtension> </ExcludedRenderFormats> <SendEmailToUserAlias>False</SendEmailToUserAlias><!-- DBA set to FALSE to allow email TO field to be edited by the user -->

Here is 2nd 1/2 rsreportserver.config on our NEW #4 server: <DefaultHostName></DefaultHostName> <PermittedHosts></PermittedHosts> </RSEmailDPConfiguration> </Extension></Configuration> <Extension Name="NULL" Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/> <Extension Name="Report Server DocumentLibrary" Type="Microsoft.ReportingServices.SharePoint.SharePointDeliveryExtension.DocumentLibraryProvider,ReportingServicesSharePointDeliveryExtension"> <MaxRetries>3</MaxRetries> <SecondsBeforeRetry>900</SecondsBeforeRetry> <Configuration> <DocumentLibraryConfiguration> <ExcludedRenderFormats> <RenderingExtension>HTMLOWC</RenderingExtension> <RenderingExtension>NULL</RenderingExtension> <RenderingExtension>RGDI</RenderingExtension> </ExcludedRenderFormats> </DocumentLibraryConfiguration> </Extension></Configuration> </Delivery> <Render> <Extension Name="XML" Type="Microsoft.ReportingServices.Rendering.XmlDataRenderer.XmlDataReport,Microsoft.ReportingServices.XmlRendering"/> <Extension Name="NULL" Type="Microsoft.ReportingServices.Rendering.NullRenderer.NullReport,Microsoft.ReportingServices.NullRendering" Visible="false"/> <Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"/> <Extension Name="IMAGE" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.ImageReport,Microsoft.ReportingServices.ImageRendering"/> <Extension Name="PDF" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport,Microsoft.ReportingServices.ImageRendering"/> <Extension Name="RGDI" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.RemoteGdiReport,Microsoft.ReportingServices.ImageRendering" Visible="false" LogAllExecutionRequests="false"/> <Extension Name="HTML4.0" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html40RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false" LogAllExecutionRequests="false"/> <Extension Name="HTML3.2" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html32RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false"/> <Extension Name="MHTML" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.MHtmlRenderingExtension,Microsoft.ReportingServices.HtmlRendering"/> <Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering"/> </Render> <Data> <Extension Name="SQL" Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/> <Extension Name="OLEDB" Type="Microsoft.ReportingServices.DataExtensions.OleDbConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/> <Extension Name="OLEDB-MD" Type="Microsoft.ReportingServices.DataExtensions.AdoMdConnection,Microsoft.ReportingServices.DataExtensions"/> <Extension Name="ORACLE" Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/> <Extension Name="ODBC" Type="Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/> <Extension Name="XML" Type="Microsoft.ReportingServices.DataExtensions.XmlDPConnection,Microsoft.ReportingServices.DataExtensions"/> <Extension Name="SAPBW" Type="Microsoft.ReportingServices.DataExtensions.SapBw.SapBwConnection,Microsoft.ReportingServices.DataExtensions.SapBw"/> <Extension Name="ESSBASE" Type="Microsoft.ReportingServices.DataExtensions.Essbase.EssbaseConnection,Microsoft.ReportingServices.DataExtensions.Essbase"/> <Extension Name="SSIS" Type="Microsoft.SqlServer.Dts.DtsClient.DtsConnection,Microsoft.SqlServer.Dts.DtsClient, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/> <!-- DBA set to allow SSIS as a DATA SOURCE --> <!-- <Extension Name="SAP" Type="Microsoft.Adapter.SAP.SAPConnection,Microsoft.Adapter.SAP.SAPProvider, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/> --> </Data> <SemanticQuery> <Extension Name="SQL" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.MSSQL.MSSqlSQCommand,Microsoft.ReportingServices.SemanticQueryEngine"> <Configuration> <EnableMathOpCasting>False</EnableMathOpCasting> </Extension></Configuration> <Extension Name="ORACLE" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.Oracle.OraSqlSQCommand,Microsoft.ReportingServices.SemanticQueryEngine"> <Configuration> <EnableMathOpCasting>True</EnableMathOpCasting> <DisableNO_MERGEInLeftOuters>False</DisableNO_MERGEInLeftOuters> <EnableUnistr>False</EnableUnistr> <DisableTSTruncation>False</DisableTSTruncation> </Extension></Configuration> <Extension Name="OLEDB-MD" Type="Microsoft.AnalysisServices.Modeling.QueryExecution.ASSemanticQueryCommand,Microsoft.AnalysisServices.Modeling"/> </SemanticQuery> <ModelGeneration> <Extension Name="SQL" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.MSSQL.MsSqlModelGenerator,Microsoft.ReportingServices.SemanticQueryEngine"/> <Extension Name="ORACLE" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.Oracle.OraSqlModelGenerator,Microsoft.ReportingServices.SemanticQueryEngine"/> <Extension Name="OLEDB-MD" Type="Microsoft.AnalysisServices.Modeling.Generation.ModelGeneratorExtention,Microsoft.AnalysisServices.Modeling"/> </ModelGeneration> <Security> <Extension Name="Windows" Type="Microsoft.ReportingServices.Authorization.WindowsAuthorization, Microsoft.ReportingServices.Authorization"/> </Security> <Authentication> <Extension Name="Windows" Type="Microsoft.ReportingServices.Authentication.WindowsAuthentication, Microsoft.ReportingServices.Authorization"/> </Authentication> <EventProcessing> <Extension Name="SnapShot Extension" Type="Microsoft.ReportingServices.Library.HistorySnapShotCreatedHandler,ReportingServicesLibrary"> <Event> <Type>ReportHistorySnapshotCreated</Type> </Extension></Event> <Extension Name="Timed Subscription Extension" Type="Microsoft.ReportingServices.Library.TimedSubscriptionHandler,ReportingServicesLibrary"> <Event> <Type>TimedSubscription</Type> </Extension></Event> <Extension Name="Cache Update Extension" Type="Microsoft.ReportingServices.Library.ReportExecutionSnapshotUpdateEventHandler,ReportingServicesLibrary"> <Event> <Type>SnapshotUpdated</Type> </Extension></Event> </EventProcessing> </Extensions> </Configuration>

Hi mdgraves, From your first post, #4 SSRS took much time on report processing. Can you check the #4 server performance using window performance montor on Memory and CUP? If the server hardware is in normal state, then check whether the report is cached or not in from #1 and #4 via querying their executionlog view in report server database. See http://blogs.msdn.com/b/robertbruckner/archive/2009/01/05/executionlog2-view.aspx on ExecutionLog2 View - Analyzing and Optimizing Reports. (Even for SSRS 2008, the source information also can apply to SSRS 2005). Additionally, if any antivirus program was installed on the server 4#, uninstall (NOT just to disable it) it and try to view the report. thanks, Jerry

Jerry, We were unable to find anything that lead to resolution. We reloaded machine back to Win2003R2, and now SSRS 2005 on server #4 performs as other 3. Thanks.