SSRS Server Upgrade Create huge Performance issue in reports to download

Question

Hi team,

we have upgraded the window server from 2012 to 2019, we are using Aspose Slide reporting service 17.10 version in our application to retrieve the SSRS RPL report in PPTS format ,after upgrading the server from 2012 to 2019 we are facing huge performance issue. earlier with 2012 web server, it was taking 3 second to download the report with minimum data now its taking more 1.50 minutes to download .

This Code takes too much time to render

 byte[] result = executionService.Render("RPL", deviceInfo, out extension, out encoding, out mimeType, out warnings, out streamIDs);
                return new MemoryStream(result);

Answer 1

Hi @Arora, Preeti @ Global D&T

Regarding SSRS performance issues, you can check the execution log ExecutionLog3 to see whether data retrieval, report processing or report rendering takes a long time. You can refer to this document to help troubleshoot performance issues: Troubleshooting Reports: Report Performance.

Best regards,

Aniya

Answer 2

Hi Aniya,

We have same rdl and Server Configuration that we are using from many years. Just we have updated Window 2012 to Window 2019 in server post that changes we are getting this performance issue and we are using excel(working fine) , ppt , pptx (both have issue) format we are using in reports. Previously it takes 3-4 seconds in downloading now its taking 2-3 minutes in report downloading.

We have reverted window upgrade in Production environment then its working fine in production with same code.

BUT in UAT server we did not reverted window update so its getting problem. We have Sql Server 2014 and SSRS 2016 13.0.7024.30 . Any configuration we need to do post upgrade on windows.

Please help us to fix in this priority as window we need to upgrade in Server as its too old.

Excel is working fine in rendering but PPT and PPTX having issue in rendering as we are not using this method in excel only ppt downloading getting issue.

var executionService = new ReportExecutionService
            {
                Url = _reportingServiceUrl + "/ReportExecution2005.asmx?wsdl",
                Credentials =
                    !string.IsNullOrWhiteSpace(Username)
                        ? new System.Net.NetworkCredential(Username, Password, string.Empty)
                        : System.Net.CredentialCache.DefaultCredentials
            };
            executionService.Timeout = 600000;
            executionService.LoadReport(reportPath, null);
            executionService.SetExecutionParameters(SsrsParameters, "en-us");

executionService.Render(fileformat, deviceinfo, out extension, out encoding, out mimeType, out warnings, out streamIDs);

We are using this with aspose code below is the code that we are using:-

https://docs.aspose.com/slides/reportingservices/export-report-to-powerpoint-without-installation-of-aspose-slides-reportingservice-on-server/

Regards

Preeti Arora

Answer 3

Hi @Anonymous

Please update.......