In touch with Reporting Service

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

In touch with Reporting Service

Author

Topic

jhnegrao
Yak Posting Veteran

81 Posts

Posted - 2008-02-25 : 14:01:21

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

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-02-25 : 17:19:33

Check out:
http://www.microsoft.com/technet/prodtechnol/sql/2005/pspsqlrs.mspx
Also check the links given by Visakh.