Skip to Content

John Mrozek of the SAP Strategic Engagements team provided this webcast on BI Admin Best Practices & troubleshooting to ASUG.  Surveys of ASUG members showed this was the top requested webcast.  Note that so much material was covered in this webcast I have to split it up in different parts.

John said that maintaining a BI system is a lot like maintaining a car; it is important to monitor system.  He said you have to dive in under the hood to do performance troubleshooting, you have to understand the system in-depth to pinpoint what is causing issues.

You need to have tools at your disposal.  The BI suite has millions of lines of code, a lots of servers talking, web server, firewalls. To pinpoint, you have to do troubleshooting and diagnostics.

Good Performance and best practices go hand in hand.  “If you are driving a car, and have snow chains, you don’t drive them in the summer”

He suggested to look at the big picture and “narrow things down before logging”.  Try and remove different items.  Look at a different environment. 

He suggested seeing Derrick Wan’s – methodology of troubleshooting presentation at the ASUG BusinessObjects User Conference.  The link is here.

Products he covers may not be BusinessObjects products; being an administrator means having visibility into your system.

Split APS Servers – Adaptive Processing Servers and System Configuration Wizard BI4.1

/wp-content/uploads/2013/10/1fig_291461.jpg

Figure 1: Source: SAP

By default you have one Adaptive Processing Server.  If you have a small test system you can leave it as default.  Figure 1 shows you should split APS out to get a more robust system for better scaling

APS is “Difficult to troubleshoot as all the servers write to one log”.

/wp-content/uploads/2013/10/2fig_291464.jpg

Figure 2: Source: SAP

Figure 2 shows the System Configuration Wizard.  It makes it easier to deploy system and configure various settings.

In past, you had to go to various servers, stop switches, do not start, tedious and effort – now easy wizard to take components needed

The best practice is to only start services you need.

/wp-content/uploads/2013/10/3fig_291465.jpg

Figure 3: Source: SAP

It allows you to size your system, the wizard will show RAM required and APS’s per node, with templates and as you slide it will automate the sizing. 

Before had to go to an individual server and do this; this wizard does it automatically

It is a good starting point, but not a finished product

Once you do sizing, you still need to review and pay attention to memory usage.

/wp-content/uploads/2013/10/4fig_291466.jpg

Figure 4: Source: SAP

Figure 4 shows you can specify the input output file store; an easy way to do that.

/wp-content/uploads/2013/10/5fig_291467.jpg

Figure 5: Source: SAP

Figure 5 shows the response file.  Response file for multiple installations; he said it is “useful when you want to use for multiple servers. You can also use it to restore in the future.

To be continued…

Subset of Question & Answer

Q: I have existing installation 4.0, what is the recommended approach for upgrading? I have the servers splitted for the adaptive servers, etc.  should I remove them  so the system will re-create them for me? or do leave them?

A: You could do an in-place upgrade and let the system config wizard run; also see sap.com/upgradeBI‑

________________________________________________________________

Q: is there a way to copy the configuration settings to the other envirohments?

A: Yes, the response file it creates – records graphical interface options and use that file and use that‑

________________________________________________________________

Q: Do you have any other Best Practice for LCM performance? What are the main common problems that could affect the performance for the promotion system?

A: See this wiki for LCM: Promotion and Version Management (LCM) – Business Intelligence (BusinessObjects) – SCN Wiki

Related Links:

BI4.1 System Configuration Wizard

BI4.1 System Configuration Wizard – Video

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

  1. Mister Makmerphy

    What happens when we use System Configuration Wizard and choose L on Capacity tabulator? Do we still need to modify Xmx/Xms parameters of APS servers manually or system changes them automatically?

    What about GC? What GC you suggest to use?

    (0) 
  2. Tammy Powlas Post author

    Hi,

    Thank you for reading and commenting

    As I am not an expert in this area, I recommend opening a new discussion and asking this question in the discussion forum.

    Tammy

    (0) 

Leave a Reply