SSRS report performance somehow depends on user specified in datasource credentials.

Question

Hi,

I have a report which has cascading parameters. I noticed that when I specify an SQL Server user in the datasource credentials the parameter refreshes in 10 seconds, but when I specify a windows domain user in the datasource credentials the parameter refreshes in less than 1 second.

Why is that?

Thank you.

Answer 1

hi，@IG-0063
I did some test locally,I changed the connection authentication of the data source in the report, and found that the windows authentication was a little bit slower, it was 1 second slower.
Have you tested other simple report on this issue, or only this report has this issue?
I recommend you check the ExecutionLog of the reporting service.
Specific steps:

1. connecting the sql server database by SSMS
2. open the reportserver database
3. preview the report
4. create a query "select top 5* from ExecutionLog3 order by TimeStart desc" and run
   then you can see the record of the report just ran.There are 3 parameters you may focus on,timeDataRetrivel，timeProcessing and timeRendering.You may check the 3 stages to find out which stage cause slowness.
   ExecutionLog Information : https://learn.microsoft.com/en-us/sql/reporting-services/report-server/report-server-executionlog-and-the-executionlog3-view?view=sql-server-ver15
   Also If you want to improve the report server performance, you can refer to this: https://learn.microsoft.com/en-us/sql/reporting-services/report-server/performance-snapshots-caching-reporting-services?view=sql-server-ver15

Best Regards,
Isabella

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.