RS still crippling server -- sql server reporting services

Jerry
2/15/2005 8:22:37 PM

You should definitely have a separate license for RS and run it on its
own server.

[quoted text, click to view]

Bryon
2/15/2005 10:49:24 PM

We are still having issues running certain reports that take up to 100%
CPU and eat memory like it is candy. Some of these are not very large.
Could this be due to the fact that IIS, MS SQL and RS are all running

Jerry
2/15/2005 11:02:22 PM

Not three licenses. I assume that IIS and SQL Server were running just
fine for you previously and can stay on the same box. Just get an extra
box and SQL license to run RS. RS is pretty resource intensive and its
happiest by itself.

[quoted text, click to view]

Bryon
2/16/2005 1:41:46 AM

[quoted text, click to view]

I that a license for a separate SQL Server? Does this mean use 3 boxes?

Bruce L-C [MVP]
2/16/2005 9:18:58 AM

The main time I have seen extensive resource utilization is when rendering
to some other format than html. Particularly PDF and Excel. These are done
in memory and can take a lot of memory. If you have a multi-user cpu box
with decent amount of RAM you should be OK. Remember that you can't just use
memory usage because SQL Server will use all available memory and then give
back memory when under load.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : RS still crippling server