single server vs multi-server installation

[#1]

hi,

what is difference between single server installation vs multi-server installation w.r.to bpc5.1 m?

i'm asking details just high level view, not in detail & not as basis consultant?

Is single/multi server installation is only with MS vesion or is it also avilable in bpc 7 nw version?

thanks..

[former_member192799 · Accepted solution]

Hi Raju,

There are may ways of installing BPC as described by the other responses. But here are the main reasons for going with a multi-server system:

- scalability. The Application server component (linked to IIS) is a 32-bit application. This limits the amount of RAM that it can use, and as a consequence the number of concurent users it can serve. If you have a large number of users, the solution is to have several application servers side-by-side, all behind a Network load balancer.

- SQL server can run either on 64-bit or 32-bit. On a single server it will be limited to 32-bit because of the requirement for the application server module being on the same box. But on a multi-server, SQL and Analysys Services can run on a separate server in 64-bit and take full advantage of much larger amounts of RAM.

- High-availability: Clustering SQL and OLAP and the File Server require multi-server systems.

There are many possible combinations, each having it's avantages and costs. In the end it all depends on the specific requirements of the customer

As for BPC for Netweaver, there are other factors, as the .Net server has to run on MS Windows, but the Netweaver system can run on any platform supported by Netweaver (so it could be on Linux or on Solaris for example)

I hope this clarifies a bit

Best regards,

Bruno

[Former Member]

You may have :

1 BPC Server + 1 SQL/OLAP Server

or

2 (or more) BPC Servers behind a web load-balancing solution + 1 SQL/OLAP Server.

For high availability :

2 BPC Servers (+ NLB solution) + 2 SQL/OLAP Server (+MS Cluster).

[Former Member]

If you have 2 or more BPC Application servers you'd need SQL Server Enterprise license for each of them because standard version doesn't support scale-out deployment of reporting services.

With single server you are limited to 32-bit OS/SQL Server.

Regards,

Akim

[Former Member]

Hi,

One way is to install both SQL and BPC on one server. Another way is to install them in different systems.