In touch with Reporting Services

Hello, All!
It`s the first time with Reporting Services and would like to know if there
are any performance problems when installed on the same server with a SQL
Server.
I`m a Database Administrator and I have a SQL Server into a DMZ with almost
200GB of data and nowadays the company is demanding a Reporting Service into
a DMZ and we don`t have a dedicated server to use with. Otherwise, we buy a
SQL Server license just for this request don`t worth.
So, we decide to install Reporting Service on this server, but I have no idea
about how much recource is needed to handle it and if this installation could
cause any issues.
Anybody knows how Reporting Service works? Are there any best practices when
installing Reporting Services on a OLTP SQL Server ?
Thanks
Juliano Horta
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200802/1You need to get IIS configured on that server before you can install RS,
which itself is a ASP.NET application. That means you will have to run IIS
and SQL Server on the same box. If the hardware can handle that will depend
on the work load. Also, if the RS is SQL Server RS2000, its report rendering
is quite CPU-hungry process and very slow. If a fairly big reports are
requested often, it will definitely slow things down. SQL Server2005 RS'
report rendering is said much better (than RS2000).
Yes, if you place RS in a box different from where SQL Server is, you need
another SQL Server license. You need to make decision based on your work
load and the possible cost of extra box/license.
"julianohorta via SQLMonster.com" <u13014@.uwe> wrote in message
news:8045aaa722294@.uwe...
> Hello, All!
> It`s the first time with Reporting Services and would like to know if
> there
> are any performance problems when installed on the same server with a SQL
> Server.
> I`m a Database Administrator and I have a SQL Server into a DMZ with
> almost
> 200GB of data and nowadays the company is demanding a Reporting Service
> into
> a DMZ and we don`t have a dedicated server to use with. Otherwise, we buy
> a
> SQL Server license just for this request don`t worth.
> So, we decide to install Reporting Service on this server, but I have no
> idea
> about how much recource is needed to handle it and if this installation
> could
> cause any issues.
> Anybody knows how Reporting Service works? Are there any best practices
> when
> installing Reporting Services on a OLTP SQL Server ?
> Thanks
> Juliano Horta
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200802/1
>