SSRS Performance Issue

  • Hi, my SSRS environment is experiencing a weird performance issue.

    I've got a report that's pumping 100K rows (standard report, just normal table with nothing) that runs only a few seconds on TEST environment (7 secs total), but running for more than 5 min of (processing time) in PROD. the retrieval and rendering data is under 3 seconds.

    what i noticed is that, when it's running in DEV, the CPU spike to 50%, then report finish.

    where as in PROD, the CPU never even reach 3% and it keeps running for 5 min.

    is there any settings that might prevent the CPU to be used?

    Environment:

    Prod Reporting Service = RPT01

    Prod ReportServer database SQL01

    Prod Reporting Service = DPT01

    Prod ReportServer database DSQL01

    I've tried a few scenario, where PROD point to the TEST ReportServer database (RPT01 to DSQL01), and it did spike the CPU and finish in 7 seconds... so, this should conclude that it's not the server setting on RPT01, and something with the SQL01 database???

    so, is it the database? then I tried to restore the DSQL01 ReportServer database to SQL01, and run (RPT01 to the restored DB on SQL01)... I thought this will work, but it actually run slow again...

    so, I'm back to square one, where I can't point where the issue is.

    anyone can help me with solution or possible test to pinpoint the root cause?

  • Hi

    What about the Resource Governor on Prod?

    Imho this feature can limit the amount of CPU and memory consumption if implemented, but

    this is only small advice.

    Br.

    Mike

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

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