Hi
We are evaluating options for installing MII 12.1 (currently in ramp-up) in a distributed manner.
We have SQL Server setup in one site. We would be installing MII instances on multiple sites. But would like to know in terms of Netweaver Database, if we can create multiple netweaver db instances on the same SQL Server one for each site and use them with distributed Netweaver CE 7.1 Application servers on each site.
In essence, all Netweaver App servers across sites would connect to different SQL Server instances that arel hosted on the same physical host at 1 site.
Would this result in serious performance degradations because the SQL Server is farther away from the Netweaver Application server? Will the application make a call to the netweaver database for each click since the code is residing on the Netweaver database or does it cache enough to avoid the trips?
Please let me know
Thanks
Deepa