SSRS performance tuning

[sanbk]

Cache kashtam bro since there are 250+ combinations a user can select parameter combinations. Filtering data based on parameter eh option requirement ala undi broo. 

 

[BulletBaskar]

36 minutes ago, sanbk said:

Cache kashtam bro since there are 250+ combinations a user can select parameter combinations. Filtering data based on parameter eh option requirement ala undi broo. 

 

parameter datatype and underlying database column datatype same unnaya?

checky chey first....that is really important

[sanbk]

Avi fix chesaa bro but still it didn't improve my performance.. Any other suggestions to avoid sub reports.

[Quickgun_murugan]

1 hour ago, sanbk said:

Avi fix chesaa bro but still it didn't improve my performance.. Any other suggestions to avoid sub reports.

Filters tagginchu... snapshot nunchi render cheyy.. apart from all these née reports SharePoint  server lo run avutunnaya... native mode aa? Also check how many applications are using your report server. Too much load on the report server kuda issue ayundochu... if so try to implement scale out deployment.

[sanbk]

Filters tagginchalenu broo data pull ala undii snapshot koncham kashtame cache vadanu but as I said earlier one or two comibnations ayithe work avuthadi but there could be more than 250+ combinations

[Quickgun_murugan]

15 hours ago, BulletBaskar said:

Try to avoid Filtering in SSRS report, When possible, filter the data at the query level using a WHERE clause because the database is better suited to filter the data 

 

6 minutes ago, sanbk said:

Filters tagginchalenu broo data pull ala undii snapshot koncham kashtame cache vadanu but as I said earlier one or two comibnations ayithe work avuthadi but there could be more than 250+ combinations

 

[sanbk]

yes, filters are done at query level itself. Three subreports use chesthe main report rendering ki about 20 to 25 secs teesukuntundi. Is it a acceptable industry standard level??

[Quickgun_murugan]

8 minutes ago, sanbk said:

yes, filters are done at query level itself. Three subreports use chesthe main report rendering ki about 20 to 25 secs teesukuntundi. Is it a acceptable industry standard level??

25 secs is not bad but not completely acceptable

[sanbk]

That is where naku koncham lightning kavali veellemo ikkada 2 sec 1 sec antunnaru (not technical people) . Evaraina reports choosi tuning chesistha ante nenu ready ivvadaniki...

[sanbk]

Evaru leraa bhayya support iche vallu ssrs performance tuning meeda......

[sanbk]

How to add calculated fields (aggregations involved) to dataset in SSRS??