sql server reporting services performance

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%

more ▼

asked Dec 17, 2010 at 09:57 AM in Default

avatar image

ramesh 1
2.2k 66 69 73

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Dec 17, 2010 at 04:31 PM

avatar image

Fatherjack ♦♦
43.8k 79 102 118

yes if fluctuates

Dec 17, 2010 at 11:55 PM ramesh 1

OK, so what is the average CPU of SSRS? Over say an hour or two?

Dec 18, 2010 at 04:56 AM Fatherjack ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Dec 17, 2010 at 09:57 AM

Seen: 2101 times

Last Updated: Dec 17, 2010 at 09:57 AM

Copyright 2018 Redgate Software. Privacy Policy