Performance Monitoring in SAP Basis

Optimize your business processes with Performance Monitoring SAP Basis

In the age of digitalization, it is important for companies around the world to streamline their processes and the applications they use to use those processes. The software applications you use to improve your day-to-day business processes must be monitored regularly to ensure their functionality and efficiency.

Performance monitoring in SAP Basis allows you to keep your system under control and consider all important aspects related to your records, workflows, administration, and more.

End-to-end performance monitoring helps you identify and fix problems before they escalate into serious problems. You can also improve the overall performance of your business applications to improve your processes and improve your performance.

Before we dive into the details of performance monitoring in SAP, let’s briefly understand what SAP Basis is.

What is SAP Basis?

BASIS stands for “Business Application Software Integrated Solution”. SAP Basis is a holistic set of tools and programs that interface with your operating system, business applications, database, and communication protocols.

Basis allows a number of different SAP applications such as CO, FI, PP and more to run effectively and communicate with each other across different databases and operating systems.

also known as Netweaver, offers you a wealth of different functionalities, some of which are as follows:

System management and monitoring tools
The common monitoring tool of CCMS (Data Center Management System) to view the alerts of the R/3 System from a central location.
Deployment for server-side scripting in JavaScript and ABAP (Advanced Business Application Programming)
Business server pages for creating online stores and portals.
Utilities for data management and monitoring.
Resource management functions for handling memory, buffers, etc.
Profile management and authorization tools for seamless user management.
Internet access control for your business and system contacts.
Facilitate the transfer of changes in a layout, screen or program from the development system to the production system to ensure accuracy.
Client-server integration and architecture.
Graphical User Interface (GUI) design for the presentation layer.

How is SAP Basis different from SAP ABAP?

SAP ABAP is an ideal alias for SAP Basis. However, it is important to understand the difference between the two. SAP Basis is a system management version of SAP. On the other hand, SAP ABAP (Advanced Business Application Programming) is one of the two most important programming languages used by developers to create SAP applications (the other language is Java).

It is common for the line between SAP Basis administrators and SAP ABAP developers to be blurred in many organizations. It is common for professionals working on both entities to be well acquainted with each other’s tasks. However, most SAP organizations keep the areas of competence of SAP Basis and SAP ABAP separate.

Performance Monitoring in SAP Basis

Because SAP Basis allows different SAP applications to function and communicate with each other, it becomes important for an organization to monitor the performance of this system.

Performance monitoring in SAP Basis is a set of processes dedicated to monitoring application servers, database space, CPU usage, log file evaluation, and more. When you perform thorough performance monitoring in SAP Basis, also consider processes such as:

Monitor batch jobs
Monitoring of spool orders
Monitoring database performance
Monitor application users
Monitoring of print requests
Monitoring system-wide workflows
Monitoring workflows for individual instances
Overlook CPU usage
Monitor lock entries
Monitoring the system log
Monitor buffer statistics

Important transactions for performance monitoring in SAP Basis

To monitor the system and its performance in SAP Basis, you must use certain transaction codes to execute certain processes.

Here are some of the most important transactions involved in performance monitoring in SAP Basis:

Application servers monitor SM51

This transaction is used to monitor all active application servers in your system. This action allows you to review the configured services and work processes in each instance. This gives you complete visibility into the performance and health of your network and all your SAP applications. It also frees up your IT resources, allowing you to focus on more important tasks.

Monitor work processes per instance SM50

This performance monitoring transaction in SAP Basis provides you with all the different processes related to a specific instance that is running, waiting, stopped, or PRIV. Here the status of all processes is checked.

Ideally, the state of processes in each instance should be either “ongoing” or “waiting.” If the status of your processes is different from these two, they need to be evaluated and reported on.

This transaction provides users with a lot of valuable information, including:

The status of your work processes (whether they are busy or not),
The action that is performed by a worker process in the Action column when it is executed, and
The tables that are being worked on.

Now let’s take a look at some of the main issues that the transaction helps to investigate:

Delay caused by a user – It can happen that a user takes too long to log in, or that they cannot log in, causing a delay in transactions. This can be the result of full use of the DIA processes. This can also be a by-product of long-lasting jobs. If necessary, you can cancel the session in question by selecting the jobs, then going to “Processes” and clicking “Cancel without Core”. This will help you cancel the job and share work processes with another user or process.
PRIV status under the “Reason” column – While monitoring your processes, you may also come across users who have the PRIV status in the “Reason” column. This can mean that the user transaction is very large, which increases the need for more memory. In such circumstances, the DIA worker process will become the “property” of the user in question and prevent other users from accessing it. If you encounter this problem, you should contact the affected user and run the job in question as a background job.
Long print job – If you encounter a long print job in an SPO worker process, you should investigate the problem instead of ignoring it. This situation may occur because of a problem related to the printer or print server.

System-wide monitoring of work processes SM66

You can use this transaction to monitor the utilization of the work processes using the global work process overview. Tracking system-wide worker processes helps you investigate the possible cause of a system performance issue without unnecessary delays.

With this transaction, you can get a comprehensive overview of the work process load on all your active instances throughout the system. You can use the Global Work Process Overview screen to evaluate the following elements:

The ongoing state of each application server
The reason why an application server is not running
The status of the restarted server.
The CPU and its request time
Details of the logged-on user and the client to which they logged in
Details of the current report

Lock Entry Monitoring SM12

To monitor your lock entries, you must execute transaction SM12 and add a “*” in the User name field.

SAP provides users with a locking mechanism to prevent other users from changing the record they are currently working on. In certain situations, these locks are not lifted. Such circumstances can occur when users are disconnected due to a network issue before they can unlock them.

Then it’s important to remove the old locks to prevent changes or access to your records. Lock statistics can be used to monitor the locks set in your system.

MONITORING CPU Usage ST06

Performance monitoring in SAP Basis also helps you monitor CPU usage in your system. Ideally, CPU usage should be around 60% to 65%. If it exceeds this limit, you may need to check the following items:

Run operating system-level commands and verify which processes are consuming the most resources

Go to SM50 or SM66 to check for long-running jobs or long update queries that are running
Go to SM12 and check the lock entries
Go to SM13 and check the update active status
Checking the errors in SM21

Monitoring database backup logs DB12

This transaction will help you determine when the last successful backup for your system was performed. With it, you can check the backups done the day before and check that everything is running smoothly. The transaction allows you to view the redo log files and check whether the redo log backup was successful.

A word at the end

These were some of the most important aspects to consider when monitoring performance in SAP Basis. These transactions and reviews will help you ensure that your system runs smoothly and that your business applications deliver the desired results. Automated performance monitoring relieves your team members of spending more time and effort than necessary, allowing them to focus on core business processes.