Performance Tuning In BI 4.1 & 4.2 & How to Use System Configuration Wizard
As a Basis Consultants we used to get lot of Requests from End User’s regarding Slowness of BI Systems like Reports Access Taking more time, unable to Access WEBI or Crystal Reports and rendering issues etc…. this is where Performance Issue comes into Picture.
Sizing is one of the primary tasks that need to be Taken care by BI Architects or Technical Consultants While Building Business Intelligence platform.
SAP has Provided many resources for Sizing.
Based on No.of End users, Functional , Technical (Expert ) users we can make Capacity Planning.
- For Improved Performance and Scalability we need to Split Adaptive processing Server and Adaptive Job Server. Below note provided Clear process to Split APS and AJS.
https://launchpad.support.sap.com/#/notes/1694041 –> Splitting Adaptive Processing Server
https://launchpad.support.sap.com/#/notes/1950573 —> Splitting Adaptive Job Server
2. Platform Search Application–> Need to change Continuous Crawling to SCHEDULED Crawling
This Application helps users to Search their Documents in BI Launchpad without any performance Issue. Each Document/report that got published /modified/Deleted will be indexed.
In BI 4.2 SP4 Search Algorithm Performance has been Improved
where as SAP Provided an Automated tool to perform Capacity Planning i.e. System Configuration Wizard .
System Configuration Wizard is a tool in SAP BI. we can Access that through CMC. This wizard Guides us through initial Configuration steps required to our BI Landscape.
- Services Auto Start
- Folders Path
once After Completion of Installation and After Logging into CMC, System Configuration Wizard Screen Pop’s up.
Capacity Planning Plays vital Role BI Environment. Based on RAM Size in Our System, Number Of Adaptive Processing Server’s are Deployed.
System Configuration Wizard Screen:
Based on RAM Size, Below are Recommendations provided by SAP
6-8GB —–>1 APS Recommended (XS)
12-16GB—>4 APS Recommended (S)
15-25GB—>7 APS per Node (M)
30-45GB—>9 APS per Node (L)
40-60GB—->11 APS per Node (XL)
we can Access System Configuration Wizard from CMC.
We can Specify Folder paths like Input File Repository, Output File Repository, Log, Data, Auditing etc..
https://launchpad.support.sap.com/#/notes/1735129/E ——-> Sizing Estimator
https://launchpad.support.sap.com/#/notes/2322354/E —>Deployment and Sizing Best Practices
https://archive.sap.com/documents/docs/DOC-33183 —> Resources related to Sizing are provided in this blog