hi team, i our CMR i can see sql server consuming 1-2% of CPU usage but reporting services use 67%. what might be the problem. page life expectancy >300 buffer cache hit ratio is 100%
asked Dec 17 '10 at 09:57 AM in Default
The reporting services web site is a web application that will consume resources, does the CPU change as the load on the report server changes? It may be complex rendering of reports or large numbers of users that is taking the CPU for some activities. Is your SQL Server suffering from lack of CPU, what I mean is, what is the whole CPU usage - close to 100% or at approx 70%? If there is still some CPU unused then its not an immediate risk. You can query the reportserver database to see what reports are running at the times of high CPU to trace the offending objects and look to make them more efficient.
answered Dec 17 '10 at 04:31 PM