SapMonitor.blogspot.com becomes SAPLiveMonitor.com

As of today, my blog also has its own .com domain name : SAPLiveMonitor.com !

SAP Live Monitor at GDF SUEZ during the first days after Major Upgrade last summer

Last summer at GDF SUEZ there has been a Major  ISU and CRM Upgrade, combined with an Architecture Change, and during the Testing Phase, Launch and Run, my SAP Live Monitor has been used a lot ...

Here is a picture taken in the "War Room" right after the Go Live while we were experiencing Load with our call centers 3,500 online users ramping up slowly to reach the peak at the end of the first morning

My SAP Live Monitor was projected on the wall for everybody to see the impact of the users on the Application Servers Work Processes, CPU & Memory

The Satisfaction of having programmed a useful tool is priceless :-)

On this photo, right side, front to back:
- Nicolas MAILLARD , a very good high level SAP System Administrator, Oracle RAC specialist
- Abdel SIDHOM , SAP IT Performance Team manager at GDF SUEZ, also brilliant guy, check out his website: STechno.net (formerly SAPTEchno.net); I learned a lot working closely with him for more than 3 years
- Reynald QUEILLE , Head of ALEMA Conseil, SAP Architecte at GDF SUEZ




http://www.saplivemonitor.com

SAP Live Monitor - Lastest Version & SAP Demo System

Here is a short video of the latest version of my SAP Live Monitor

Soon an online SAP Demo System should be available for you to test all the monitors ... Stay tuned

SAP Live Monitor - Oracle RAC now available

New : Oracle RAC (Real Application Cluster) is now available on my SAP Live Monitor

Below, for each SAP system, see the blue bars showing live sessions, and the CPU for each RAC node

Update July 18th, 2013: 
Here is a short video of the latest version of my SAP Live Monitor
Soon an online SAP Demo System should be available for you to test all the monitors ... Stay tuned

SAP Live Monitor - New Memory Monitor

I am happy to announce a new monitor called Memory Monitor showing real time memory for each application server of a SAP system or several

On the right side of the SAP Live Monitor below, you can see a summarized version of it, with 4 percentages for the Roll, Paging, Extended and Heap Memories for each line / AS

Here everything is green, but once the memory percentages go beyond certain thresholds, they will appear in Orange and then Red - threshold values are settable in the selection screen -

(Image blurred to hide customer data)

Clicking on any memory value will display the detailed Memory Monitor showing, for each application server of the selected system, detailed values for each type of memory:
- Roll Memory
- Paging Memory
- Extended Memory
- Heap Memory
Here also the figures go Orange then Red if any threshold is reached,a dn the whole thing is automatically refresh every second (settable)

(Image blurred to hide customer data)

Also, for each memory type, if requested, you can see the detail of each user's use of this memory, the running program/job and the table queried - if any -.


(Image blurred to hide customer data)


From there, clicking on this table, you can acces the history data of this SQL query and its Explain Plan, etc


(Image blurred to hide customer data)

SAP Live Monitor - Extended Version & Other Root Cause Analysis Tools

As promised, here is an extended version of my SAP Monitoring Tool, SAP Live Monitor, developed in ABAP from ground up


(All images and videos are blurred to hide customer data)

Here are some screenshots from the above videos with a quick description / explanation so you can have an overview in one minute of the monitoring and diagnosys tools I developed

Work Processes & Database Sessions Merged in to one live auto-refreshed Monitor (SM66 + ST04 with more valuable info)

Middle Bdocs Distribution Report : See who/what generated what Bdocs in volume over time 

Main Global Live SAP ISU & CRM Monitor : From this one, you can access all the others

WP & Sessions 

Middleware Queues Live Monitor

Factsheet Repsonse Time Distribution (different levels of time, auto-refresh enabled)

WP & Sessions : The two red lines on the right show that this SQL query - executed right now - does not behave as usual and has deltas in Buffer Gets or Elapsed - delta concept - 

Main Live SAP Monitor: you can click on almost anything to geta  detailed view of what is going on and get to the root of a problem quickly

Jobs Analysis over time: Here one job has been selected - clicked on - in the Main Monitor above and this displays its history and duration in a bar graph

Clicking on any Hasvalue/SQLid will bring you to the Standard SQL EXPLAIN PLAN transaction

for further analysis on the table statistics / indexs used

Active Jobs Monitor: All the Running jobs + Aborted one ('A' red flag)  + Finished ones ('F' green flag)
If a job's duration is abnormal, you are warned by a orange then '!' flag and if you pass your mouse over it, it tells you how long it lasted a week ago 

I receive Alerts, based on thresholds defined for each monitored object (WP, Bdocs flow, DB CPU, SQL Queries Delta, etc); If something goes wrong on these two ISU and CRM systems, I know about within one or two minutes only, as one or more emails arrived on my iPhone inbox with detailled graph screenshot telling exactly what the problem is, and this is 24/7

Database (DB) CPU Alert


SQL Queries Delta Alert

Dialog Work Processes Alert