RS still crippling server

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
on the same box?You should definitely have a separate license for RS and run it on its
own server.
Bryon wrote:
> 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
> on the same box?|||Jerry wrote:
> You should definitely have a separate license for RS and run it on its
> own server.
>
> Bryon wrote:
>> 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 on the same box?
I that a license for a separate SQL Server? Does this mean use 3 boxes?
One for the web front, one for MS SQL and one for MS SQL with RS?|||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.
Bryon wrote:
> Jerry wrote:
>> You should definitely have a separate license for RS and run it on its
>> own server.
>>
>> Bryon wrote:
>> 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 on the same box?
>
> I that a license for a separate SQL Server? Does this mean use 3 boxes?
> One for the web front, one for MS SQL and one for MS SQL with RS?|||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
"Bryon" <blape@.whittmanhart.com> wrote in message
news:OGyUJK$EFHA.1564@.TK2MSFTNGP09.phx.gbl...
> Jerry wrote:
> > You should definitely have a separate license for RS and run it on its
> > own server.
> >
> >
> > Bryon wrote:
> >
> >> 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 on the same box?
> I that a license for a separate SQL Server? Does this mean use 3 boxes?
> One for the web front, one for MS SQL and one for MS SQL with RS?