Monday, August 4, 2014

Daily Workout of an BASIS Admin to ensure system availability and integrity

Hello BASISians,

We as BASIS people, it's our major responsibility to look after our SAP severs and keep maximum up-time to ensure 99.9999 % productivity of respective organisations. Apart from SAP server up-time, it's also crucial to make sure that server performance throughput is per expectation of business users as it plays an important role in running an organisation. I guess almost all BASIS people receives the first call in case any alien behavior occurs in SAP servers and we also face the same with  our own imagined / framed  solution for the time being and later on after putting lots of efforts  into search engine and various logs, we finally get the solution. As we know very well that SAP is versatile and we can never  say that I have X many years of experience & I know everything in X module since on every new day new enhancements & developments  comes and most of the existed scenarios get changed . Whatever it is , but as pro-active action we all need to ensure ourselves that we find the issue before any end user complains.

So, follow below mentioned basic daily activities :-

1. Check whether all the SAP servers are up & running or not . In case of ABAP servers (ECC, BI, PI etc.), check directly through GUI and for JAVA server (EP, PI, CRISP etc.) check the generic URL http:<FQDN of SPA server>:<port> .

2. Check all the below transactions aka reports in each of crucial ABAP servers :-

RZ20: It's a quick way to get all the alerts in one place . More likely you can monitor the spool space . (RZ20 > SAP CCMS Monitor Templates > Spool System > System Wide > Spool > SpoolNumbers > UsedNumbers )

SM50: Check whether any background process is taking long time

SM37: Check whether any scheduled periodic job got failed

ST22: Check if any recursive dump is coming is system and analyse as per available logs.

SM21: If any user complains that his/her user ID is locked due number of wrong attempts , but he didn't do the same , so through SM21, you can find the intruder's terminal name.

ST06: Check file system usage, CPU utilization etc. various leading performance parameters .

DB02: Check the database usage , percentage of free space etc.

SE38: Execute 'FP_TEST_IA_01' & 'FP_TEST_00' to check whether ADS is working or not.

ST03N: To check the system workload, any kind of business transaction analysis and also to compare the loads per instances in a load balancing system.

ST02: You can check memory related findings like SAP memory, NTAB buffer, table buffer etc. . In addition to that you can also synchronize buffer in respective  instances.

SM13: To check whether any updates failed.

SM12: To check if there is any pending locks

SMQ1 & SMQ2 : To check outbound and inbound queue as well as well as number of available entries in respective queues.

SMLG: To check the status of available instance in a logon group.

Db01: To check for any database lock entry.

DBACOCKPIT: Most of the things are can covered in this transaction like table-space monitoring , Lock wait , Log Space etc.

DB12 & DB13: To check the status of backups & redo log files and to schedule backup calendar.


3. Check the DR servers log sequence . If any mismatch appears, apply the missing logs manually.

4. Apart from testing NWA URL  of all JAVA systems , do the following additional checks :-

Check if any object level locks existed for an user, if requires delete the lock to release the object for further use.

Check whether all JCO connections (used) are working or not.

In case of ESS/MSS , check whether CONNECTOR, WAS, ITS connections are working or not.

5. Finally check the EWA report for any patching , applying security notes or any further steps to running SAP smoothly.

6. You can take the help of OS team to create alert if SAP services get turned off in server,so that immediate action can be taken. For example in windows system if SAP<SID>_<instance number> service gets stopped, it will send SMS or mail to inform the administrator to take immediate action.

7. In all the new net-weaver systems, to OS Collector service can be started with with following two windows services , so make sure that both are running to get current system statistics :-

SAPHostControl

SAPHostExec  


I hope , it would somehow help BASIS Admin to tackle most of the common issues. At the end, I would like to take the opportunity to thank.

30 comments:

  1. It was really a nice article and I was really impressed by reading this article We are also giving all software Course Online Training. The Sap BASIS Online Training is one of the leading Online Training institute in the world.

    ReplyDelete
  2. This is the information that I was looking for and let me tell you one thing that is it is very useful for who is looking for SAP BPC ONLINE TRAINING

    ReplyDelete
  3. This comment has been removed by the author.

    ReplyDelete
  4. Great info! I'm looking for sap bpc training .Its helps me a lot.

    ReplyDelete
  5. good article thanks for sharing indepth overview that i was searching. For brief training by real time experts on SAP Basis look at MindMajix SAP Basis Training

    Check this site Mindmajix for indepth SAP Basis Training

    Go here if you’re looking for information on SAP Basis Training

    Hello joey parker, Go here if you’re looking for information on SAP BPC Training

    ReplyDelete
  6. Thanks for sharing the nice post. Packers and Movers Kolkata, Local Shifting Relocation and Top Movers Packers Kolkata. Packers and Movers Kolkata Household @ www.KolkataPackersMovers.in
    http://kolkatapackersmovers.in/

    ReplyDelete
  7. http://packers-and-movers-delhi.in/
    Packers And Movers Delhi prompt moving, relocation and shifting services for people and corporation moving to Delhi and round the India. For Movers Packers Delhi city full target report on supply of revenue and effective Movers And Packers Delhi, contact today 08290173333. We include our network in major cities like Bengaluru, Bangalore, Gurgaon, Hyderabad, Chandigarh, Haridwar, Chennai, Noida, Mumbai, Pune, Jaipur, Lucknow, Patna, Bhopal, Bhubaneswar, Ahmedabad and Kolkata.

    ReplyDelete
  8. I really enjoyed reading your blog, you have lots of great content.Please visit here:
    http://packersmoversahmedabad.co.in/
    http://packersmoversahmedabad.co.in/packers-and-movers-gandhidham-gujarat
    http://packersmoversahmedabad.co.in/packers-and-movers-surat-gujarat
    http://packersmoversahmedabad.co.in/packers-and-movers-surat-gujarat
    We are expert in Handling, Movers Packers in Ahmedabad and Packing & Shifting of Household Goods, Office goods, Commercial Equipment and Car, Logistics and Transportation.

    ReplyDelete
  9. Thanks for sharing this Information, Got to learn new things from your Blog on Sap basis.
    http://thecreatingexperts.com/sap-basis-training-in-chennai/

    ReplyDelete
  10. I like your website very much thanks for your share. all the imformation are useful for me,I will come again.Please visit here: Packers And Movers Jaipur
    http://jaipurpackersandmovers.in/packers-and-movers-kazipura-jaipur
    http://jaipurpackersandmovers.in/packers-and-movers-keshwana-jaipur

    ReplyDelete
  11. Thanks for sharing great information in your blog. Got to learn new things from your Blog . It was very nice blog to learn about
    SAP BASIS

    ReplyDelete
  12. This comment has been removed by the author.

    ReplyDelete
  13. Thanks for sharing useful information for us.I really enjoyed reading your blog, you have lots of great content.
    Packers And Movers Mumbai
    Packers And Movers Ratnagiri Maharashtra
    Packers And Movers Sangli Maharashtra

    ReplyDelete
  14. I admire the valuable advice you make available in your expertly written content. I want to thank you for this informative read; I really appreciate sharing this great.Packers And Movers chandigarh
    Packers And Movers Faridkot
    Packers And Movers Firozpur

    ReplyDelete

  15. Good one and very put together.
    This is indeed our bread n butter, and we need to do the workout

    Appreciate your efforts.


    SAP training in Chennai


    SAP FICO training in Chennai

    ReplyDelete
  16. For latest and updated SAP certification dumps in PDF format contact us at completeexamcollection@gmail.com.
    Refer our blog for more details http://completeexamcollection.blogspot.in

    ReplyDelete
  17. great tutorial about sap basis training thanks for this valuable information keep it up. sap basis is also a growing sector in sap ERP field best sap training institutes in Bangalore and sap Basis training in Bangalore

    ReplyDelete
  18. Wow.. Thanks much for sharing.. My friend also recommended you so that i can have a helping hand to make my blog as effective as possible.
    SAP HANA Training in Chennai | SAP MM Training in chennai | SAP Basis Training in chennai

    ReplyDelete
  19. This comment has been removed by the author.

    ReplyDelete
  20. Hi, Thanks for sharing your article. For more information please visit.
    SAP BASIS Training Institutes in Ameerpet

    ReplyDelete
  21. Very good explanation on SAP Basis concepts we do SAP Training in Chennai for all SAP Modules.

    ReplyDelete
  22. Thanks for this. I really like what you've posted here and wish you the best of luck with this blog and thanks for sharing. Ucat registration 2021

    ReplyDelete
  23. Nice Blog. Thanks for sharing this. We have the Team of Real-Time SAP Basis Experts and Knowledgeable Working Professionals. sap basis online training india

    ReplyDelete
  24. This comment has been removed by the author.

    ReplyDelete
  25. Really nice information to learn the basic concepts of SAP BASIS online training. You can learn the concepts of SAP BASIS from https://rhsofttech.com/sap-basis-online-training/ in a professional way.

    ReplyDelete