We are running a scaled out deployment of SSRS 2008 on two servers.Everything runs great but we are having to reset the reportserver service on one server or the other about once a week due to high CPU usage. The servers run fine for days and then one of them will spike the report sevice up to 70% CPU and it will stay there until we recycle it. I have gathered CPU usage perfmon counters at 1 minute intervals and compared to reports executing prior or during the spikes but cannot make a link based on logs or executionlog entries. We run 10,000 reports per day on the farm. SQL is not installed on this box and SSRS is the only app on this server. Anyone have any ideas on troubleshooting this or know of a way to try to determine what is causing this CPU spike?

---This first thing to check if CPU is at 100% is to look for parallel queries: -- Tasks running in parallel (filtering out MARS requests below): select * from sys.dm_os_tasks as t where t.session_id in ( select t1.session_id from sys.dm_os_tasks as t1 group by t1.session_id having count(*) > 1 and min(t1.request_id) = max(t1.request_id)); -- Requests running in parallel: select * from sys.dm_exec_requests as r join ( select t1.session_id, min(t1.request_id) from sys.dm_os_tasks as t1 group by t1.session_id having count(*) > 1 and min(t1.request_id) = max(t1.request_id) ) as t(session_id, request_id) on r.session_id = t.session_id and r.request_id = t.request_id; Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Thanks. I will run these the next time we get a CPU spike.

Is this a similar issue: http://social.technet.microsoft.com/Forums/en/sqlreportingservices/thread/d56765d1-8cd5-4cc4-9633-2f5c5e3bf7ca

Yes this thread is the same issue. I do not see an answer for the issue though.

Yes this thread is the same issue. I do not see an answer for the issue though.

Hi Florida guy, You could click link to get some reference http://blogs.msdn.com/b/psssql/archive/2009/12/09/high-cpu-with-reporting-services-2008.aspx Thanks, Challen Fu Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi Florida guy, For this issue, you could click link to get some reference http://blogs.msdn.com/b/psssql/archive/2009/12/09/high-cpu-with-reporting-services-2008.aspx Thanks, Challen FuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.

Challen Fu I do not think the OP was introduced his own code in reporting service Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Hi Uri Dimant, Many thanks for pointing out this, actually the link in my reply is just one possible cause. If OP has no his own code, this link could not help him. Thanks again. Regards, Challen FuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.