BWA – performance monitoring with Wily Introscope
Hello BWA experts,
may be some of you were asked from time to time by some developers or BW system advisor where you can I see the load (CPU,memory etc…) of the BWA. There are 3 known possiblities supported from SAP:
TREXAdmin standalone tool (based on python, located on OS)
Possibility 1) and 2) are really difficult to handle, because you need either OS access or authorization to use the tools.
If you are already using Wily Introscope for other applications and systems, you can also use it for BWA.
Follow the steps and you can present your colleagues a good tool for monitoring performance/load of BWA at the end of the day:
You need the following things to implement Wily for BWA:
– Solution Manager (configured SMD + SLD)
– Wily Installation (Workstation / Enterprise Manager)
– some knowlegde on solution manager/wily and linux
– User sapadm on all BWA hosts
– Install files for host and diagnostic agents
You must setup your BWA in your solution manager in TA SMSY:
Configure first your BWA as TREX in categorie ‘Technical Systems’according the pictures:
Add a new Technical System under TREX (e.g. BAP, SID of your BWA)
Add your current software component under the shown tab above
Add your server hosts (these server must be predefined in SMSY ‘Server’) under tab instances
Afterwards configure it as ‘SAP BI ACCELERATOR’ under ‘Product Systems’
2. Download files
The files which you need for installation depending on your current solution manager stack (should always be the latest one). Check the notes which host and diagnostic agent is the right one for you.
Support Packages and Patches – Entry by Application Group” SAP Technology Components” SAP SOLUTION MANAGER” SAP SOLUTION MANAGER 7.0″ Entry by Component” Agents for Satellite Systems
The Host Agent should be included in the Diagnostic Agents download SAR.
Support Packages and Patches – Entry by Application Group” SAP Technology Components” SAP HOST AGENT
Copy the install files to your BWA hosts (or shared filesystem like gpfs). Extract it with SAPCAR (-xvf).
export DISPLAY variable for X-Windows installation: export DISPLAY=host:port
host is the computer/server where the X-Server is installed and the port is usually port 0.
Another solution is to activate runlevel 5 (on OS, graphical output) to install it directly on the BWA blade. This isn´t the normaly way but I just want to show you another way without remote X-server 😉
Start the sapinst in the extracted folder.
First of all install the Host Agent: Software Life-Cycle Optiones -> Additioninal Preperations -> Host Agent
Here is nothing to take notice on, the kernel was also included in the compressed SAR file (e.g.: SMD711_K_UI_LINUX_X86_64). It´s needed by both installations. Just enter the path for it.
Check installation with command ‘ps -ef | grep host’ or script ‘/etc/init.d/sapinit status‘.
After successful installation of host agent we go forward to the diagnostic agent. Just start again the sapinst like described already above.
The installation depends on your system landscape. More information you will get via the sap instguides.
The installation can be executed online without downtime of your BWA!
Start TA SOLMAN_SETUP -> Managed System Configuration -> change system type to TREX -> choose your BWA system and setup your system
Select Change -> Execute All -> Continue
Click contintue till this picture is displayed. Here you can navigate through each server and assign the agents.
Sometimes the configuration ends in such an error. We see that SAPOscol is mentioned again. But we already set this config?! So what´s gone wrong? The anser is easy – nothing. You will see that the data in Wily will be displayed and you will get no other errors which are refering to this error. It´s possible that it takes some time, until the host/agent is registrated completely.
Known Errors during configuration:
The installation can result in an error (‘Cannot get CPU information from SAPOSCol webservice’), because an entry in file /usr/sap/hostctrl/exe/host_profile is missing. Please check note 1400891 for further information.
The entry should like this:
service/porttypes = SAPHostControl NwaManagement SAPCCMS SAPOscol
After you changed the entry, restart the host agent via ‘/etc/init.d/sapinit restart’
!!!Note: If you use sapinit it will restart also the TREX instance!!!
You can use as alternative the following procedure:
logon as sidadm (agent user, e.g. daaadm) -> “stopsap; startsap” -> this will restart only the diagnostic agent.
Rerun installation it should now finishing successfully.
Start your Wily Interscope Enterprise Manager workstation (http://host:port/workstation) or webview (http://host:port/webview and install Silverlight). Filter via ‘lens’ the BWA host(s) and click on ‘TREX’ ‘Triage’ or ‘Overview’, some statistic values you will find also on dashboard ‘Host’. In the best case the data are displayed like shown in the pictures below:
There are a lot of categories which can be monitored.
It depends on the version of Wily if you can add user and create dashboards. In the ‘light’ version you only have 2 users -> admin and guest. The restriction for guest is only that this user can´t execute a transaction trace.
I hope I could help you with this little how-to to integrate the BWA in your Wily monitoring.