RE:[sap-basis] BW Architecture - Is it best practice to have BW app and databse on the same server or to split them
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by FJJohann on Mar 26 at 6:05 PM |  Mark as helpful |
This is a government dept with aroud 6 000 employees. CRM is the B I G system here.
I must also mention the following facts that dont come thu. Users never connect to SAP BW. All reporting is done off SAP BO as Webi reports, Excelcius feeds for dashboards crystal reports for scheduled reports etc.
The Prd environment looks like this
4 Apps servers with each SAP module installed as a separate application. CRM clustered across 2 boxes. FI shaing a box with BW (used as a business warehouse no reporting at all.
4 database servers with each database on its own NFS mount of the 15TB of disk space allocated by the Netapp storage.
2 servers to run BO
1 for the Bo database and 1 for the portal.
Additionaly we have a SQL server farm that is used to do the data prep (SSIS) into a staging warehouse before this is loaded into SAP BW, if I had my way I would be using SQL 2008 OLAP as my dataprovider but the SAP ream felt that as we have BW and most of the cubes come pre-built lets just use this (FI and CRM).
We will be using BP to load each and every business and citizen into business partner. In my mind this is a "LARGE" if not huge system. Must say I am having my brains toasted getting a entirely new team to deploy this solution.
Would shate the design with you but the foum does not accomodate attchements.
email@removed
---------------Original Message---------------
From: Lars-Erik Hallsten
Sent: Friday, March 26, 2010 4:48 PM
Subject: BW Architecture - Is it best practice to have BW app and databse on the same server or to split them
> Hi,
>
>
>
> Well, I wouldn't call it a mickey mouse implementation, but it's pretty far
> from being considered as a huge implementation, I think.
>
> It seems like a quite normal implementation in the SMB range.
>
> How many concurrent users are using the ERP/BW system in a normal day? The
> amount of reports and how frequent they are used is also an important
> factor.
>
> I've not been in the situation myself, but I have heard about a couple of
> customers that was running ERP and BW in the same system, which after a
> while of bad performance, decided to split the system on separate servers.
> It solved all of their performance issues.
>
>
>
> Regards,
>
> LEH
__.____._ I must also mention the following facts that dont come thu. Users never connect to SAP BW. All reporting is done off SAP BO as Webi reports, Excelcius feeds for dashboards crystal reports for scheduled reports etc.
The Prd environment looks like this
4 Apps servers with each SAP module installed as a separate application. CRM clustered across 2 boxes. FI shaing a box with BW (used as a business warehouse no reporting at all.
4 database servers with each database on its own NFS mount of the 15TB of disk space allocated by the Netapp storage.
2 servers to run BO
1 for the Bo database and 1 for the portal.
Additionaly we have a SQL server farm that is used to do the data prep (SSIS) into a staging warehouse before this is loaded into SAP BW, if I had my way I would be using SQL 2008 OLAP as my dataprovider but the SAP ream felt that as we have BW and most of the cubes come pre-built lets just use this (FI and CRM).
We will be using BP to load each and every business and citizen into business partner. In my mind this is a "LARGE" if not huge system. Must say I am having my brains toasted getting a entirely new team to deploy this solution.
Would shate the design with you but the foum does not accomodate attchements.
email@removed
---------------Original Message---------------
From: Lars-Erik Hallsten
Sent: Friday, March 26, 2010 4:48 PM
Subject: BW Architecture - Is it best practice to have BW app and databse on the same server or to split them
> Hi,
>
>
>
> Well, I wouldn't call it a mickey mouse implementation, but it's pretty far
> from being considered as a huge implementation, I think.
>
> It seems like a quite normal implementation in the SMB range.
>
> How many concurrent users are using the ERP/BW system in a normal day? The
> amount of reports and how frequent they are used is also an important
> factor.
>
> I've not been in the situation myself, but I have heard about a couple of
> customers that was running ERP and BW in the same system, which after a
> while of bad performance, decided to split the system on separate servers.
> It solved all of their performance issues.
>
>
>
> Regards,
>
> LEH
Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Related Content
In the Spotlight
White Papers
In the Spotlight
55% of IT Pros Use Social Media to Advance Their Careers. See the Survey Results
View this thread online
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
_.____.__ 
