BI Publisher / One View Real World Architecture Question
Hello All,
We are a Wintel SQL Server shop. We are about to start our implementation of BIP and One View. We are currently not using either of them (except BIP embedded for doc layout). I would like to hear from all of you about real world performance / gotchas so we can plan servers correctly.
First, our architecture
- E1 9.1, TR 9.1.4.4
- all win 2008 R2, sql server 2008 R2
- We have these vm servers:
- DV/PY database server, DV/PY application server and webserver (weblogic, 1 JVM per pathcode)
- PD database server, PD application server and 2 webservers (weblogic, 2 JVM per webserver)
We have 100 users, but only about 10 will be using OneView. We prefer to keep PD/PY on separate servers for maintenance, TR upgrades, etc. We have pretty low development demands. Larger projects can be scheduled so as not to be concurrent. The downside for a small shop like us is waste of licenses and idle servers (vm helps in that CPU and memory can be shared among servers, but there is still a cost).