Script:To find the swapping/Paging

#! /bin/bash

#

# Page on Page on swap.sh: Shows the swap usage of each process

# Author: 

swap_total=0

for i in /proc/[0-9]*; do

pid=$(echo $i | sed -e 's/\/proc\///g')

swap_pid=$(cat /proc/$pid/smaps |

awk 'BEGIN{total=0}/^Swap:/{total+=$2}END{print total}')

if [ "$swap_pid" -gt 0 ]; then

name=$(cat /proc/$pid/status | grep ^Name: |

awk '{print $2}')

echo "${name} (${pid}) ${swap_pid} kB"

let swap_total+=$swap_pid

fi

done

echo

echo "Total: ${swap_total} kB"

From <https://www.quora.com/How-can-I-determine-which-process-is-contributing-to-paging-on-Linux> 

Difference between IOPS and Throughput

This is the analogy I came up with when talking about Throughput and IOPS.

Think of it as :

You have 4 buckets (Disk blocks) of the same size that you want to fill or empty water.
You'll be using a jug to transfer the water into the buckets. Now your question will be :

At a given time (per second), how many jugs of water can you pour(write) or withdraw (read)? This is IOPS

At a given time (per second) what's the amount(bit, kb, mb, ect) of water the jug can transfer into/out of the bucket continuously? This is throughput.

Additionally, there is a delay in the process of you pouring and or withdrawing the water. This is Latency.

There's 3 things to consider when talking about IOPS and Throughput.
Size (file size/ block size)

Patterns (Random/Sequential)

Mix (Read/Write) percentage

Let's consider as the sample the 3000 IOPS and SQL database engine, the block size in terms of db engine is called the page size and for SQL Server it's equal to 8 KB. If you wish to calculate the actual throughput, if the IOPS defined, you will end up with the formula below:

throughput = [IOPS] * [block size] = 3000 * 8 = 24 000 KB/s = 24 MB/s


Source : https://stackoverflow.com/questions/15759571/iops-versus-throughput#:~:text=4%20Answers&text=IOPS%20measures%20the%20number%20of,have%20about%20the%20same%20size.

SAP application server to database server latency Checks

SAP application server to database server latency can be tested with 

ABAP report /SSA/CAT -> ABAPMeter

Downtime Optimization – Get insights using the new TDO app

https://blogs.sap.com/2020/09/16/downtime-optimization-get-insights-using-the-new-tdo-app/

How to get this app?

There are two ways entering the app:
Using the SAP ONE Support Launchpad
Using the direct link: https://launchpad.support.sap.com/#/downtimeoptimization