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 Lars-Erik Hallsten (CEO & Senior Consultant) on Mar 27 at 10:30 AM |  Mark as helpful |
Hi,
OK, more and more details are revealed here and I'm beginning to agree with
you :)
In your setup it seems that the BW functionality doesn't require much from
the servers at all, so it actually looks good.
I'm a little bit confused, though. You say that your running ECC with BW,
but also that ECC and BW has different SIDs.
I guess that means that you are running the application servers for ECC and
BW on the same server and that they are connected to different databases on
another server.
If this is the case, your setup is considered best practice, even if the
different databases are running on the same server. There's nothing wrong in
consolidating system this way, as long as the HW has the sufficient
specifications.
Regards,
LEH
From: FJJohann via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
Sent: 26. mars 2010 11:02
To: Lars-Erik Hallsten
Subject: 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 FJJohann
on Mar 26 at 6:05 PM
<http://it.toolbox.com/api/ContentVote/3402307/1/1 /> Mark this reply as
helpfulMark 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
__.____._ OK, more and more details are revealed here and I'm beginning to agree with
you :)
In your setup it seems that the BW functionality doesn't require much from
the servers at all, so it actually looks good.
I'm a little bit confused, though. You say that your running ECC with BW,
but also that ECC and BW has different SIDs.
I guess that means that you are running the application servers for ECC and
BW on the same server and that they are connected to different databases on
another server.
If this is the case, your setup is considered best practice, even if the
different databases are running on the same server. There's nothing wrong in
consolidating system this way, as long as the HW has the sufficient
specifications.
Regards,
LEH
From: FJJohann via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
Sent: 26. mars 2010 11:02
To: Lars-Erik Hallsten
Subject: 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 FJJohann
on Mar 26 at 6:05 PM
<http://it.toolbox.com/api/ContentVote/3402307/1/1 /> Mark this reply as
helpfulMark 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
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
Lars-Erik HallstenSAP Basis Helper
Posted helpful replies on 50 threads in a group to earn a Silver Achievement
Related Content
In the Spotlight
White Papers
In the Spotlight
Earn Recognition for Your Contributions at Toolbox for IT. Gain Points for Community Achievements
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
_.____.__ 
