Procedure Cache Hit Ratio for database

What is it?
The hit ratio is a mean value that gives a snapshot of a short period of time before the analysis. This value should always be above 95%, even during periods of heavy workload. If the hit ratio is significantly below 95%, the data cache could be too small.


To check the hit ratio:
1. Execute ST04
0007-dbhitratio-001


2. If the hit ratio is below 95%, you will have to increase it.

Popular posts from this blog

HOW TO SAP - Create RFC TCPIP connection and Register Server Program with RFCEXEC

Step by step to create new job using SM36

HOW TO SAP - SAP Web dispatcher Installation