x

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

ramesh 1 gravatar image

ramesh 1
2.2k 63 67 69

(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

Fatherjack gravatar image

Fatherjack ♦♦
42.7k 75 79 108

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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x729
x94
x87

asked: Dec 17, 2010 at 09:57 AM

Seen: 1866 times

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