How to use dpmon tool - to monitor work process status @OS

 Dpmon - Dispatcher monitoring 

Dpmon tool is use to check the status of  work process or dispatcher queue @ operating system level without login to SAP GUI.

use cases:

1. To get the status of work process @ OS level, when the SAP GUI login is not possible.

Practical steps:

1.login to putty session using <sid>adm user.

2.To list down the available profiles, issue command- cdpro or (/sapmnt/<SID>/profile)

3.follow by command - ls

4.dpmon pf=<use_the_profile_used_for_application_server> - results shows dispatcher queue statistics.

5.type 'm' to display all the menu available for the dpmon.

6.type 'I' to display work process overview.

7.step 4,5,6 can be replace with command - dpmon m i

8.if all the work process are full take the PID of the work process and kill the process id with command- kill -9 <PID>

I/O - (input/output) monitoring in AWS EC2

what is IO?

 i/o (input /output) is the concept of writing or reading from the disk.

It is measured in the following aspect:

• Latency
• Random I/O performance (random read /writes)
• Sequential read or write performance
• IOPS ( IO operations per second)

When is IO used ?

Any time the application will read and write to the disk, IO will be used.
At startup,the OS (Operating System) will read the disk to load settings.

You can use the "iostat" command to find the current amount of IO being used.

Note: Your Application is a database (MySQL,SAP HANA,etc...)

• Every time a query (SQL) happens, the database needs to read the disk.
• Any time data needs to be inserted, the database needs to write to the disk.
• Databases need to serve thousands of concurrent queries very fast
• Disk needs to be extremely reliable.

The IO is key for the application.Good IO performance is crucial to ensure the database always performs.

For details monitoring of IO in AWS EC2:

1. Navigate the Running EC2 instance page( services -->in compute section -->EC2 --> Running EC2 instance.)
2. Select the EC2 instance.
3. Navigate to Description tab as shown below.

           

4.Click on root device -->EBS id.

5.you can found the iops information in the highlighted part of the screen.

 

6.for historical & graphical representation.
   Go to monitoring tab.

   

6. if the time spent idle is zero then IO need to optimize for the system.