I have a report which runs but when it does the CPU gets pegged at 100%, when all the SSRS datasets starts then the CPU goes to 100%. Is there anything that I can do to fix this ?

Hi, Do you mean only executing one particular report makes the CPU usage get to 100%? If so, could you post more details about this report? For example, if the report refers custom code/assembly, does the report have many pages or a multi-select drop-down parameter list? In addition, please also post the version of your Reporting Services. Besides that, you can check SSRS's Execution log to do some self-troubleshooting to monitoring performance of a report server. This is a good blog for your reference, http://blogs.msdn.com/b/robertbruckner/archive/2009/01/05/executionlog2-view.aspx If I have something misunderstood, please also point out with no hesitation. Thanks, Tony Chain Tony Chain [MSFT CSG] | Microsoft Community Support Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.