question

IgorGelin-0063 avatar image
0 Votes"
IgorGelin-0063 asked IgorGelin-0063 commented

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

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.

sql-server-generalsql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Isabellaz-1451 avatar image
0 Votes"
Isabellaz-1451 answered IgorGelin-0063 commented

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://docs.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://docs.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.

· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I experienced quite the opposite, sql server authentication much slower then the windows one. I added sql server tag in case this is a permission issue.

0 Votes 0 ·

Are you opening the report in the report manager? If so, I suggest you press the F12 key to see the specific reason for the slowness.

0 Votes 0 ·

What would F12 do?

0 Votes 0 ·