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 4:44 PM |  Mark as helpful |
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
From: FJJohann via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
Sent: 26. mars 2010 8:47
To: Lars-Erik Hallsten
Subject: [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 3:49 PM
I am having a problem with people using "SAP best practise" terms all over.
I need to have clarity on the design we have and if this meets best
practice. We have a 2 application servers running CRM on on and ECC6 with BW
on rhe next. Each of these app servers have thier own spearte databe server.
We also have BO running as the front end on its own evironmnet connecting to
its own database server.
I have a SAp basis consultant who sates he has never seen this cofig and its
a known best practice to have BW running on its own box!
Taking into account taht the apps sever does not do too much work in a bw
inplementeation where BO is used to rended the reports off the cubes stored
in the BW database and that the DB server will be doing all the work I feek
that the DB server needs to be the one that is separated and sized
aprporiataly nd that runaway jobs can be isolated in this manner. (I have
known data loads to kill the db server if not well designed)
__.____._ 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
From: FJJohann via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
Sent: 26. mars 2010 8:47
To: Lars-Erik Hallsten
Subject: [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 3:49 PM
I am having a problem with people using "SAP best practise" terms all over.
I need to have clarity on the design we have and if this meets best
practice. We have a 2 application servers running CRM on on and ECC6 with BW
on rhe next. Each of these app servers have thier own spearte databe server.
We also have BO running as the front end on its own evironmnet connecting to
its own database server.
I have a SAp basis consultant who sates he has never seen this cofig and its
a known best practice to have BW running on its own box!
Taking into account taht the apps sever does not do too much work in a bw
inplementeation where BO is used to rended the reports off the cubes stored
in the BW database and that the DB server will be doing all the work I feek
that the DB server needs to be the one that is separated and sized
aprporiataly nd that runaway jobs can be isolated in this manner. (I have
known data loads to kill the db server if not well designed)
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
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
_.____.__ 
