November 1, 2015 at 6:39 pm
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?
November 3, 2015 at 7:57 am
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