Reporting Services/BI Model processing

My company is in the process of migrating to SQL Reporting Services 2005. At
this time we are most interested in the Business Intelligence functionality
included in SS2K5. While we were testing this product we had everything all
on the same box...SS, Reporting Services, web tools...everything. Now, we are
scaling out the project and are trying to determine where the processing of
the reports and BI models takes place. Is it on the SQL Server box or on the
Reporting Services box?
Thanks in advance!!
--
ManuelRS is a aps.net application. It uses SQL Server databases for its object and
metadata storage. It stores reporting definitions, subscriptions, etc.
Rendering occurs in RAM. So, a big report can definitely really drag on the
server. Then, if your data is also coming from SQL Server then SQL Server DB
engine has the work to retrieve the data. This is totally separate from the
work that RS is doing.
When RS is put on its own server you still need to have a SQL Server license
for the box. It doesn't matter where the RS databases reside (ReportServer
and ReportServerTempDB). My advice is, unless you are doing a web farm,
install the SQL Server database for the metadata storage on the box that
will run RS. Then keep the data you are reporting off of on a second box. In
that way, the temp data storage, the report definitions, etc are close at
hand. And, a big report won't slow down your database server which contains
your data.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"mlg1906" <mlg1906@.discussions.microsoft.com> wrote in message
news:256AEE4E-AC81-4388-A20B-67247EE7EA59@.microsoft.com...
> My company is in the process of migrating to SQL Reporting Services 2005.
> At
> this time we are most interested in the Business Intelligence
> functionality
> included in SS2K5. While we were testing this product we had everything
> all
> on the same box...SS, Reporting Services, web tools...everything. Now, we
> are
> scaling out the project and are trying to determine where the processing
> of
> the reports and BI models takes place. Is it on the SQL Server box or on
> the
> Reporting Services box?
> Thanks in advance!!
> --
> Manuel
>|||We're a lot clearer on what our approach will be. Thanks a million!
--
Manuel
"Bruce L-C [MVP]" wrote:
> RS is a aps.net application. It uses SQL Server databases for its object and
> metadata storage. It stores reporting definitions, subscriptions, etc.
> Rendering occurs in RAM. So, a big report can definitely really drag on the
> server. Then, if your data is also coming from SQL Server then SQL Server DB
> engine has the work to retrieve the data. This is totally separate from the
> work that RS is doing.
> When RS is put on its own server you still need to have a SQL Server license
> for the box. It doesn't matter where the RS databases reside (ReportServer
> and ReportServerTempDB). My advice is, unless you are doing a web farm,
> install the SQL Server database for the metadata storage on the box that
> will run RS. Then keep the data you are reporting off of on a second box. In
> that way, the temp data storage, the report definitions, etc are close at
> hand. And, a big report won't slow down your database server which contains
> your data.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "mlg1906" <mlg1906@.discussions.microsoft.com> wrote in message
> news:256AEE4E-AC81-4388-A20B-67247EE7EA59@.microsoft.com...
> > My company is in the process of migrating to SQL Reporting Services 2005.
> > At
> > this time we are most interested in the Business Intelligence
> > functionality
> > included in SS2K5. While we were testing this product we had everything
> > all
> > on the same box...SS, Reporting Services, web tools...everything. Now, we
> > are
> > scaling out the project and are trying to determine where the processing
> > of
> > the reports and BI models takes place. Is it on the SQL Server box or on
> > the
> > Reporting Services box?
> >
> > Thanks in advance!!
> > --
> > Manuel
> >
>
>