reporting service

For years I wonder to one thing. As I understand reporting service is designed to create reports for application. However as soon as I installed it, it gets a lot of CPU time even no application request report.

If there are other services running on the box, you need to determine if it is indeed SQL Server that is causing the cpu spikes. Try opening up SQL Profiler to look at the SQL Server activity. Also look at performance monitor for more insightful detail as to the possible causes.

HTH...

Joe|||

What is about task menager. It shows reliable information, it does not. However I got information from there.

Why at the time when nobody request SQL server, reporting service continue to run?

Also when I run management studio in 32 bit windows I see that it gets huge cpu time for short period, then for short period cpu is quiet. And this loop repeats until I close managent studio. In 64 bit version it works better.