Re: Multiple SQR Servers

[Ray Ontko <rayo@ONTKO.COM>]

Christian,

There isn't really a server called an SQR Server.

"SQR Server" refers to the version of SQR that runs
on a non-workstation.  You don't set up multiple
"SQR Servers" to increase throughput, although you can
certainly install "SQR Server" on multiple, high-powered
boxes and run your SQRs on them.

If you're having performance trouble with SQR programs,
the usual approach is to:

1) tune the queries in the SQR program so that they
   make efficient use of the database, and

2) run the SQR program on the same machine as the
   database (or some other machine connected via
   high-speed network to the database) to minimize
   network traffic between the database and SQR.

Does this help?

Ray

> Hello,
>
> I am looking for information of how to scale
> Brio.Reports with the SQR Server.  Is it possible to
> have multiple SQR Servers to process reports?  And how
> can I go about setting up this configuration.  Do I
> need to purchase an additional SQR Server?
>
> Thanks in advance,
> Christian
>
> __________________________________________________
> Do You Yahoo!?
> Talk to your friends online with Yahoo! Messenger.
> http://im.yahoo.com
>

----------------------------------------------------------------------
Ray Ontko   rayo@ontko.com   Phone 1.765.935.4283   Fax 1.765.962.9788
Ray Ontko & Co.   Software Consulting Services   http://www.ontko.com/