Post reply

SSRS 2008 R2 -Performance?

  • September 26, 2012 at 8:54 am

    #262207

    Hi Guys,

    Help me to achieve the "Performance Tuning for new & existing data sets'.

    eg.(Reporting server level settings, table indexes, factors to be considered by end users while accessing large data sets)"

    Other than above,anything else we need to consider for SSRS -Performance Tuning ?

    Regards,
    Kumar

  • October 16, 2012 at 12:43 pm

    #1549741

    Try to make data filters be applied on the SQL side instead of through the report filters.

    If a data set is using a stored procedure with parameters, make sure the stored procedure has a local variable and all references to the parameter is through the local variable.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply