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 5:10 PM |  Mark 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
__.____._ 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
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
_.____.__ 
