Performance

[Patrick Graydon]

     Hello,

How can I preformance tune the Windows server to make reports work faster.

We are running a Win 2012 server in Amazon Web Services and adding either CPU or memory does not seem to make a report run faster.

I would like some advice on how to performance tune the server/software to get the report to refresh quicker.

The SQL query returns on the DB in less than 2 seconds but the report takes 45+ seceonds to return.

Thanks,

Patrick

[Vinoth Srinivasan]

Hi Patrick, 

 

You can improve the performance of report rendering with following report item level changes. 

 

1.     If you are using Tablix report item and the CanGrow property given as true, then set CanGrow property as false for all textboxes which has static text also possible items which will not exceed design height.  

2.     As said above point you can set CanGrow property as false for Tablix header rows and any static cells.  

3.     Remove unused datasources and datasets in a report.  

 

Regards, 

Vinoth S.