Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 SSRS server very slow and always 100% CPU

Author  Topic 

umeandatabase
Starting Member

2 Posts

Posted - 2013-10-09 : 17:23:29
Hi all,

I have issues with SSRS server version 2008R2, Always SSRS showing 100% CPU.
Please some body get involved and give us recommendation to tune the SSRS.





Thanks in Advance
Sree

tm
Posting Yak Master

160 Posts

Posted - 2013-10-10 : 09:58:47
Can you give more information?

Is this a new installation?
If not and it was working before, was there a service pack installed recently?
Stop and restart the SSRS service?
Do you have lots of schedule or subscriptions for reports?
Did you check table ExecutionLog2 on ReportServer database to see if it give any indication of running reports?

Go to Top of Page
   

- Advertisement -