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.

37 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. really a vry nice blog i really appreciate all your efforts ,thank you so mch for sharing this valuable information with all of us.
    Packers And Movers Chennai based company provided that Movers And Packers Chennai Services for Office, Home, Local or domestic and commercial purposes.
    http://packersmoverschennai.in/

    ReplyDelete
  7. 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
  8. Packers and Movers Hyderabad, Local Shifting Relocation and Top Movers Packers Hyderabad. Packers and Movers Hyderabad Household @ www.PackersMoversHyderabadCity.in
    http://packersmovershyderabadcity.in/
    http://blog.packersmovershyderabadcity.in/

    ReplyDelete
  9. Thanks for sharing such a great article and it’s helpful for everyone. Great Post
    http://packersmoversbangalore.in/

    ReplyDelete
  10. 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
  11. 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
  12. All latest and updated SAP certification dumps in PDF format is available with us, contact us at completeexamcollection@gmail.com. Refer our blog for more details http://completeexamcollection.blogspot.in/

    ReplyDelete
  13. 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
  14. Thanks for sharing this Information, Got to learn new things from your Blog on sap basis training in chennai

    ReplyDelete
  15. For latest and updated SAS certification dumps in PDF format contact us at completeexamcollection@gmail.com
    Refer our blog for more details http://completeexamcollection.blogspot.in/2015/12/sas-certification-dumps.html

    ReplyDelete
  16. 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
  17. really a vry nice blog i really appreciate all your efforts ,thank you so mch for sharing this valuable information with all of us
    You need to guarantee that you pick just those people who are better ready to coordinate your prerequisites. In the event that you are pondering on the best way to make sense of the right choice then you can ask for the free quotes by them to benefit #best #moving administrations in Bangalore.
    http://packers-movers-bangalore.in/

    ReplyDelete
  18. 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
  19. 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
  20. 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
  21. 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
  22. 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
  23. 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
  24. This comment has been removed by the author.

    ReplyDelete
  25. 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
  26. 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
  27. 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
  28. Thanks for the great information ,was looking for this information from long.Great blog SAP Basis Training in Chennai

    ReplyDelete
  29. i cannot truly enable but admire your weblog, your weblog is so adorable and great.It has given me courage to try scarier things. I tend to steer clear of them but not anymore.
    Packers And Movers Lucknow

    ReplyDelete
  30. Thanks for sharing this Informative content. Well explained. Got to learn new things from your Blog on SAP Basis

    ReplyDelete

  31. 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
  32. 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