Skip to Content
Author's profile photo Suman Chakravarthy K

What is SAP Early Watch Alert

Introduction

                 Anything in this World requires General/Critical maintenance to increase the survival. I will take two Classic examples here, to make you more clear about What I am going to talk about in this blog. One is Human body and another one is Vehicle. Both require regular Check-ups/Maintenance to have long life. Similarly, all our SAP Systems require regular Check-Ups and General/Critical Maintenance to keep them lively. You will find interesting sections below which could be produced by EWA. I am gong to show only very important sections but not everything. Let’s jump into EWA now.

  • An SAP EWA can be produced by SOLMAN, which is nothing but Solution Manager
  • It can be generated on Weekly basis to keep an eye on whole Production System status
  • I am using the same terms which SAP uses in the report and you could find explanations for some of them in brackets
  • I am highlighting Column headers and imagine your configuration details in those tables to make sense
  • My intention is to show you What all parameters(Column Headers) will SAP EWA consider
  • There will be multiple sections describing about your Hardware details
  • Report starts with all Hardware and Software information precisely for BASIS administrators (as well as for BW guys for Knowledge sake)
  • Lower part of the report is for BI Developers/Support Guys which talks about Largest Aggregates etc.,

Your report heading would be like Early Watch Alert – BI_SYSTEM_LANDSCAPE

It gives a complete high level overview of your BW system with ratings on various parameters


Topic Sub Topic Rating
Performance Overview Performance Evaluation Eg: Green Tick Mark
SAP System Operating Program Errors (ABAP Dumps)
Update Errors
Hardware Capacity
Database Performance Missing Indexes
BW Checks BW Administration & Design
BW Reporting & Planning
BW Warehouse Management
Security SAP Security Notes: ABAP and Kernel Software Corrections
Users with Critical Authorizations
JAVA System Data Java Workload Overview
Java Application Performance

Service Summary

Performance Indicators for Production BW (System Name)

Area Indicators Value Trend
System Performance Active Users (>400 steps)
Avg. Availability per Week
Avg. Response Time in Dialog Task
Max. Dialog Steps per Hour
Avg. Response Time at Peak Dialog Hour
Avg. Response Time in RFC Task
Max. Number of RFCs per Hour
Avg. RFC Response Time at Peak Hour
Hardware Capacity Max. CPU Utilization on Appl. Server
Database Performance Avg. DB Request Time in Dialog Task
Avg. DB Request Time for RFC

Landscape

1) Products and Components in current Landscape


Product

SID SAP Product SAP Product Version
SAP NetWeaver      Eg: 3.5 / 7.0 / 7.3

Main Instances (ABAP or Java based)

SID Main Instance
Eg: Application Server JAVA
Eg: Enterprise Portal

Databases

SID Database System Database Version
Eg: Oracle, MS-SQL, HANA etc,


2) Servers in current Landscape


SAP Application Servers (If you have multiple servers, those will be listed down below)

SID Host Instance Name Logical Host ABAP JAVA

DB Servers

SID Host Logical Host( SAPDBHOST)

Components

Related SID Component Host Instance Name Logical Host

3) Hardware Configuration

Host Overview

Host CPU Type Operating System No. of CPUs Memory in MB

ST-PI and ST-A/PI Plug-Ins. This will indicate you to update to the latest levels.

Rating Plug-In Release Patch Level Release Rec Patch Level Rec
ST-A/PI

Software Configuration For your Production System


SAP Product Version End of Mainstream Maintenance Status
Eg: SAP NetWeaver Version 7.0                    31.12.2017

Support Package Maintenance – ABAP.

This info can be found in your BW System via System–>Status, except Latest Available Patch Level Info. Below table indicates us to update to latest Patches.

Software Component Version Patch Level Latest Avail. Patch Level Support Package Component Description

Support Package Maintenance – JAVA

Component Version SP Latest Available SP


Database – Maintenance Phases

Database System Database Version End of Standard Vendor Support* Comment End of Extended Vendor Support* Comment Status SAP Note
1177356

Similar table for your Operating System also.

SAP Kernel Release. You can find this via System–>Status

Instance(s) SAP Kernel Release Patch Level Age in Months OS Family

They indicate you to update to latest Support Package Stack for your Kernel Release, if required.

Overview System (your SID)

General

This analysis basically shows the workload during the peak working hours (9-11, 13) and is based on the hourly averages.

CPU

If the average CPU load exceeds 75%, temporary CPU bottlenecks are likely to occur. An average CPU load of more than 90% is a strong indicator of a CPU bottleneck.

Memory

If your hardware cannot handle the maximum memory consumption, this causes a memory bottleneck in your SAP system that can impair performance.

Workload Overview (Your SID)

  • Workload By Users
  • Workload By Task Types Eg: RFC, HTTP(S)

Th above information will be given in fantastic graphical presentation by SAP.You can make out good sense out of them.

BW Checks for (Your SID)

BW – KPIs : Some BW KPIs exceed their reference values. This indicates either that there are critical problems or that performance, data volumes, or administration can be optimized.


KPI Description Observed Reference Rating Relevant for Overall Service Rating
Nr of Aggregates recommended to delete Eg: 25 Eg: 13 Yellow

This indicates all Zero calls Aggregates can be deleted.

Program Errors (ABAP Dumps)

This section shows the ABAP Dumps(ST22) which have occurred in the last week. They will suggest us to monitor on a regular basis and we should determine the possible causes asap. Eg : CX_SY_OPEN_SQL_DB

Users with Critical Authorizations

This section suggests us to review all our Authorization Roles and Profiles on a regular basis. for additional info SAP Note : 863362

Missing Indexes

This section indicates us to have an eye on whether Primary indexes are exists on the tables in database. Because, missing indexes can lead to severe performance issues.

Data Distribution

Largest InfoCubes : We should make sure we do Compression on a regular basis.


InfoCube Name # Records

Largest Aggregates : Large Aggregates high run times for Roll ups and Attribute Change runs. So we should check them periodically and modify them at least on quarterly basis.


InfoCube Aggregate Name # Records

Analysis of InfoProviders : This table basically shows the Counts

Info Providers Basis Cubes Multi Providers Aggregates Virtual Cubes Remote Cubes Transactional Cubes DSO Objects Info Objects Info Sets

DSO Objects : This table basically shows the Counts

# DSO Objects # DSO Objects with BEX flag # DSO Objects with unique flag # Transactional DSO Objects


InfoCube Design of Dimensions : You can check this by running SAP_INFOCUBE_DESIGNS in SE38

InfoCube # rows Max % entries in DIMs compared to F-table

Aggregates Overview : We can take a call to delete unused Aggregates by observing this table

#Aggregates #Aggregates to consider if to be deleted #Aggregates with 0 calls #Basis Aggregates

Aggregates to be considered for deletion (Most important Section to take a quick action)

Cube name Aggr.-cube # entries Avg. reduce factor # calls Created at Last Call # Nav. Attr. # Hier.


DTP Error Handling : You can deactivate error stack if you don’t expect errors often. It’s better to use “No Update No Reporting” option.

# DTPs with error handling # Total DTPs % of DTPs with error handling


BW Statistics

All your BI Admin Cockpit information will be provided in detailed tabular presentation about OLAP Times, Run time etc., Many tables will be there for every aspect which I cannot show you in this blog, as it is already too big now 😉

Conclusion

“SAP Early Watch Alert” gives us a complete picture of our BW System in all aspects. This is a fantastic service gives by SAP to keep us alert before any damage happens to the system. I have tried to show you almost all important things in this blog.

Assigned tags

      75 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Anshu Lilhori
      Anshu Lilhori

      This is interesting document.In Fact i was curious to know about the generation of EWA reports.So now we have the document with complete details.

      Definitely going to become handy soon.

      Regards,

      AL

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K
      Blog Post Author

      As usual, a valuable feedback from you 🙂 Yes, it will give an idea on EWA indeed. Thanks for the rating too.

      Regards,

      Suman

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K
      Blog Post Author

      Hi Anshu,

      If u observe at the bottom of blog, there is some empty space, which i could not hide it. I tried altering the blog scroll bar, but no luck. Any idea?

      Author's profile photo Anshu Lilhori
      Anshu Lilhori

      Yes suman i can see that..Please check in edit mode of your blog if any image is there or something similar to it which is causing that space.

      Regards,

      AL

      Author's profile photo Former Member
      Former Member

      Useful INFO, Thanks For Sharing 🙂 🙂 🙂

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K
      Blog Post Author

      Thank you so much for your good words 🙂 . U r welcome 🙂 🙂 🙂

      Regards,

      Suman

      Author's profile photo CH Raman
      CH Raman

      All of my previous projects am hearing this concept and handled by basis team. We are unable to understand exactly what and how it helps us. Now by reading yoru blogs its very clearry to me about EWA . Thanks for sharing and making.

      Thanks

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K
      Blog Post Author

      Hi Raman,

      That's exactly I want to give awareness about EWA. If you observe the blog, the major part belongs to BASIS. As a BW Consultant, we should concentrate on BW part. Nice to receive good comments from you 🙂

      Regards,

      Suman

      Author's profile photo CH Raman
      CH Raman

      Yes suman, compare to basis we have very less things  to concentrate on BW KPIs. Thanks for your insight.

      Author's profile photo Former Member
      Former Member

      You are right Raman... 🙂

      Author's profile photo CH Raman
      CH Raman

      Thanks Mithun

      Author's profile photo Former Member
      Former Member

      Now i got exact idea about EWA....Thanks for sharing...Keep it up... 🙂

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K
      Blog Post Author

      Hi Mithun,

      Glad to know that you have got a picture now 🙂 . Thanks for the feedback.

      Regards,

      Suman

      Author's profile photo Benedict Venmani Felix
      Benedict Venmani Felix

      Thanks Suman, this is a nice compilation. I first heard of this EWA only last month in Prabhith's document on BW housekeeping, and was wondering what this was 😕

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K
      Blog Post Author

      Hi Vasanth,

      Nice to know you got insight about EWA with my blog 🙂

      Best Regards,

      Suman

      Author's profile photo Former Member
      Former Member

      Good Work Suman.

      Regards,

      Sushant

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K
      Blog Post Author

      Thank you Sushanth for nice appreciation 🙂

      Author's profile photo Satendra Mishra
      Satendra Mishra

      Really very nice and informative information about the WEA.

      🙂 Thanks for sharing with us. 🙂

      regards,

      Sm

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K
      Blog Post Author

      Nice feedback Mishra 🙂 U r welcome

      Author's profile photo Former Member
      Former Member

      Nice one Suman 🙂

      Purushotham.

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K
      Blog Post Author

      Thank you for the feedback Purushotham 🙂

      Author's profile photo Former Member
      Former Member

      Good doc Suman..!

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K
      Blog Post Author

      Thank you Naveen 🙂

      Author's profile photo Former Member
      Former Member

      Very complete and well summarized document. Thanks!

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K
      Blog Post Author

      Hi Clement,

      Thanks for the noble words 🙂

      Regards,

      Suman

      Author's profile photo Srinu S
      Srinu S

      Nice blog Suman. Thanks for sharing 🙂

      Author's profile photo Srinu S
      Srinu S

      Thanks for sharing Suman. 🙂

      Author's profile photo Former Member
      Former Member

      Hi Suman

      Blog shows how much efforts you put on it.I am new to SAP and right now I am in support job.So I havent understood other aspects of your blog but definatly bookmark this because as my knowledge levels increase it will going to help me.

      Any suggestions/guidance  for me will be really appreciated.

      Kind regards

      Kuldeep

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K
      Blog Post Author

      EWA is something like we will come across it for sure in our BW career. It's good to know What is happening in your BW system as far as health is concerned

      Author's profile photo Former Member
      Former Member

      Hi Suman,

      Your Document on EWA is very much self explanatory.

      Keep posting such usefull Documents

      Thanks,

      J.Sakthikumar

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K
      Blog Post Author

      Hi Shakthi,

      Yup. You are right. My objective is to create awareness of EWA among all our BW Consultants.

      Regards,

      Suman

      Author's profile photo Former Member
      Former Member

      Nice Post...More lucidly presented...

      Thank you

      Best Wishes

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K
      Blog Post Author

      Hi Thyagarajan,

      Pleasure to receive many comments from all of you.

      Regards,

      Suman

      Author's profile photo Former Member
      Former Member

      Gud work..well explained 🙂

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K
      Blog Post Author

      Thanks for the valuable feedback 🙂

      Author's profile photo Former Member
      Former Member

      Hi Suman ,

      Very nice bolg as always, thanks for sharing

      rgds,

      Verma

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K
      Blog Post Author

      Thank you for the feedback Verma 🙂

      Author's profile photo Former Member
      Former Member

      Hi Suman,

      very good article. Have given a crystal clear picture what is all about EWA. Thank you so much for sharing.

      Regards

      Venkat...

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K
      Blog Post Author

      Hi Venkateswarlu Ravula,

      Amazing feed back from you. 🙂 Happy to know my blog has given you good isnsight about EWA.

      Regards,

      Suman

      Author's profile photo Former Member
      Former Member

      Hi suman.....

      Good article to read with more vital points to learn....

      Have a nice time...

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K
      Blog Post Author

      Hi Thiyagarajan V ,

      Nice observation. I wanted to share the most imp. info only. Thanks for reading. 🙂

      Regards,

      Suman

      Author's profile photo Former Member
      Former Member

      Very Informative blog Suman.

      Thanks for sharing 🙂

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K
      Blog Post Author

      Hi Poornachandra Anjaneya ,

      Thanks a lot for your feedback 🙂 🙂

      Regards,

      Suman

      Author's profile photo Former Member
      Former Member

      thanks for sharing

      nice post!!!

      regards

      Raj

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K
      Blog Post Author

      Thank you Rajeev Parimi for your valuable feedback. 😎

      Author's profile photo Anjali P
      Anjali P

      Hi Suman,

      Very informative blog!!!  While going through the blog some doubts cropped in my mind...I have heard Client 066 is Early Watch Client.  So will SAP be accessing the customer system to generate the report through this client?  Is this an optional service?

      Regards,

      Anjali

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K
      Blog Post Author

      I am not sure about Client. But yes they will diagnose Customer Production system on weekly basis in terms of all mentioned aspects. Thanks for the feedback 🙂

      Author's profile photo Former Member
      Former Member

      This is really great . So much to learn  , thanks for sharing .

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K
      Blog Post Author

      Hi Shrivastava,

      Thanks a lot for your comments. Yes, there is so much in EWA. 🙂

      Regards,

      Suman

      Author's profile photo Former Member
      Former Member

      Hi Suman,

      Thanks for sharing the document,its really helpul to know fully about EWA..

      🙂 🙂

      Thanks,

      LP

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K
      Blog Post Author

      Glad to read your feedback Lalit 🙂

      Author's profile photo Nitesh Kumar
      Nitesh Kumar

      Hi Suman,

      Thank you so much for sharing this doc.

      I was knowing just an intoduction on this topic. Thanks a lot 🙂 .

      Regards,

      Nitesh

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K
      Blog Post Author

      Hi Nitesh Kumar ,

      Thank you for the wonderful feedback 🙂 Really amazed.

      Regards,

      Suman

      Author's profile photo Former Member
      Former Member

      Hi Suman,

      I am working in SAP PI and I really dont know about SAP BW. This blog is quite interesting about "SAP Early Watch Alert". You have documented in different way and it is nice to read it. Keep up the good work!

      No words to explain! Big Wow to you!

      Advanced Wishes for your New Year 2014 🙂

      Regards,

      Hari Suseelan

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K
      Blog Post Author

      Hi Susheelan,

      It's always been a pleasure to receive feedback from outside area people on my blogs 🙂

      A big thank you for all your sweet words. I have tried my best in this blog. 🙂

      Forgot to say, Thank you and I wish you belated Christmas and Advanced Happy New Year 2014.

      Regards,

      Suman

      Author's profile photo Former Member
      Former Member

      Hi Suman,

      You are not best. You are Awesome!

      I was reading your blogs regularly. It motivate others to think more!

      Once again thank you so much for sharing your blogs and spending time for us!

      Advanced wishes for New Year 2014. 🙂

      Regards,

      Hari Suseelan

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K
      Blog Post Author

      Thanks again for your wonderful comments Hari. I am really excited. 🙂 🙂 🙂 🙂

      Each smiley reflects one digit in 2 0 1 4

      Author's profile photo Former Member
      Former Member

      Hi Suman,

      You dont get excited! We all are excited to see and read your exciting blogs. You have great talent, I request you to post more and more technical & career development. Definitely we all support you forever.

      Regards,

      Hari Suseelan

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K
      Blog Post Author

      I have made another exciting blog in BEx forum. I am sure you will like it very much 😉

      http://scn.sap.com/community/business-explorer/blog/2013/12/16/how-to-achieve-slab-wise-or-bucket-wise-and-age-wise-requirements-in-bex

      Author's profile photo Former Member
      Former Member

      Hi Suman,

      Thanks for your quick response. I will definitely check and provide you the valuable feedback.

      Regards,

      Hari Suseelan

      Author's profile photo Former Member
      Former Member

      Bookmarked. 🙂 🙂

      Author's profile photo Former Member
      Former Member

      Nice new informative blog...

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K
      Blog Post Author

      Thank u Venkatesh

      Author's profile photo Phani KV
      Phani KV

      Hi Suman,

      Nice document.

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K
      Blog Post Author

      Thank you kodanda pani KV for your feedback..

      Author's profile photo Former Member
      Former Member

      Hi Suman,

      Informative post 🙂 Keep posting!!!!!

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K
      Blog Post Author

      Thank you Arunkarthick Annamalai for your valuable feedback 🙂

      Author's profile photo Wasem Hassan
      Wasem Hassan

      Hi Suman,

      its very good one doc..

      Keep up it... 🙂 🙂

      Regards

      Wasem

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K
      Blog Post Author

      Thank you Wasem Hassan for your cool feedback 🙂

      Author's profile photo NAGA SATISH
      NAGA SATISH

      Hi Suman,

      Nice presentation regarding EWA of SAP BI. Need to learn alot from your blog...Great suman. I need to know EWA of SAP HANA, do you have any links...please farward...

      Best Regards,

      NAga.

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K
      Blog Post Author

      Thanks a lot for your detailed comment NAGA SATISH 🙂 🙂

      Sorry I do not work on HANA. If I get any thing intersting, I will post here.

      Author's profile photo Former Member
      Former Member

      Hi Suman,

      Going through the blogs, I found this one and gone through it.

      It's a Good document, this is to know for our consultants to take care of our systems as our Health and Vehicle.

      Thanks and Regards,

      Dinesh

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K
      Blog Post Author

      Hi Dinesh Baddyapalli ,

      Glad to know that you have gone through my blog thoroughly 🙂 . Thanks a lot!!

      Regards,

      Suman

      Author's profile photo Former Member
      Former Member

      I am compelled to say .. this one is Father of all blogs!

      Very well explained .. appreciate. Please keep it continue..

      Author's profile photo Former Member
      Former Member

      Thank you so much Suman for sharing this doc.
      Very useful blogs. Keep it up...