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 26 at 5:46 PM | |
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
From: FJJohann via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
Sent: 26. mars 2010 10:10
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 5:10 PM
<http://it.toolbox.com/api/ContentVote/3402246/1/1 /> Mark this reply as
helpfulMark as helpful
Seems we agree. The two database servers have separare databses for each
application.
ie
DB1
SIDs: CRQ ? CRM QAS
EPQ ? Enterprise Portal QAS
XIQ ? NW PI QAS
OS: RHEL 5.2 (64bit)
CPU: 2x Quad Core 3.00 GHz Xeon
Memory: 32 GB
DB2
Storage: / 16 GB; Swap 32 GB
SIDs: ECQ ? ECC QAS
BWQ ? BI (BW) QAS
EPQ ? Enterprise Portal QAS
MDQ ? MDM QAS
OS: RHEL 5.2 (64bit)
CPU: 2x Quad Core 3.00 GHz Xeon
Memory: 32 GB
Storage: / 16 GB; Swap 32 GB
The actual data is stored on a netAPP 3170 with plenty spindles. We are
definatly not using a MCOD implementation and yes this a huge implementaion.
The config above is for QAS and we have added 2 more servers for production.
Does the commnet still stand that this is a "micky mouse" implementation.
---------------Original Message---------------
From: Lars-Erik Hallsten
Sent: Friday, March 26, 2010 3:48 PM
Subject: BW Architecture - Is it best practice to have BW app and databse on
the same server or to split them
> Hi,
>
>
>
> I've seen this config many times (where BW is only a separate client in
the
> ERP system) and it's perfectly ok, as long as the SAP system is a small
> installation serving only relatively few users. (Less than 100, in my
> opinion.)
>
> However, it's not a setup I would recommend to my customers in a new
> implementation. I prefer having each system type on separate databases.
CRM
> in one, ERP in one, BW in one and so on. BW performs much better on an
OLAP
> database and ERP performs best on the OLTP database. It could also be
quite
> hard to tune the other performance parameters correctly in a system where
> ERP and BW runs together, as they often need very different parameter
values
> to be optimized.
>
> These issues are not too important in a small system, though.
>
>
>
> Regarding the "best practice" issue, I would agree with your Basis
> consultant, but your setup is 100% supported by SAP.
>
>
>
> Regards,
>
> LEH
__.____._ 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
From: FJJohann via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
Sent: 26. mars 2010 10:10
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 5:10 PM
<http://it.toolbox.com/api/ContentVote/3402246/1/1 /> Mark this reply as
helpfulMark as helpful
Seems we agree. The two database servers have separare databses for each
application.
ie
DB1
SIDs: CRQ ? CRM QAS
EPQ ? Enterprise Portal QAS
XIQ ? NW PI QAS
OS: RHEL 5.2 (64bit)
CPU: 2x Quad Core 3.00 GHz Xeon
Memory: 32 GB
DB2
Storage: / 16 GB; Swap 32 GB
SIDs: ECQ ? ECC QAS
BWQ ? BI (BW) QAS
EPQ ? Enterprise Portal QAS
MDQ ? MDM QAS
OS: RHEL 5.2 (64bit)
CPU: 2x Quad Core 3.00 GHz Xeon
Memory: 32 GB
Storage: / 16 GB; Swap 32 GB
The actual data is stored on a netAPP 3170 with plenty spindles. We are
definatly not using a MCOD implementation and yes this a huge implementaion.
The config above is for QAS and we have added 2 more servers for production.
Does the commnet still stand that this is a "micky mouse" implementation.
---------------Original Message---------------
From: Lars-Erik Hallsten
Sent: Friday, March 26, 2010 3:48 PM
Subject: BW Architecture - Is it best practice to have BW app and databse on
the same server or to split them
> Hi,
>
>
>
> I've seen this config many times (where BW is only a separate client in
the
> ERP system) and it's perfectly ok, as long as the SAP system is a small
> installation serving only relatively few users. (Less than 100, in my
> opinion.)
>
> However, it's not a setup I would recommend to my customers in a new
> implementation. I prefer having each system type on separate databases.
CRM
> in one, ERP in one, BW in one and so on. BW performs much better on an
OLAP
> database and ERP performs best on the OLTP database. It could also be
quite
> hard to tune the other performance parameters correctly in a system where
> ERP and BW runs together, as they often need very different parameter
values
> to be optimized.
>
> These issues are not too important in a small system, though.
>
>
>
> Regarding the "best practice" issue, I would agree with your Basis
> consultant, but your setup is 100% supported by SAP.
>
>
>
> 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
SAP 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