Hit Ratio less than 95%

[Former Member]

Hi,

Hope you are doing well.

My server is too slow, I tried to tune some parameters but still its same. The Hit Ratio is not at all more than 95%, please suggest me the best way to increase hit Ratio or which parameter i need to tune.

Here are the details

Buffer HitRatio

Nametab (NTAB)

Table definition 69,38

Field definition 58,49

Short NTAB 51,48

Initial records 4,64

program 85,46

CUA 88,54

Screen 93,32

Calendar 100,00

OTR 100,00

Tables

Generic Key 98,39

Single record 64,20

Export/import 22,64

Exp./ Imp. SHM 100,00

Waiting for your response

Thanks

Rhishabh

[Former Member]

Hi,

This happen for two case

1.Data buffer size is small.

2. Expensive SQL.

At first you run the total DB stat if performance increased, then ok, other wish increase all buffer size to changing profile parameters.

Suman

[andreas_herzog]

any other parameters like operating system, amount of RAM, extended memory etc. would be nice

sap version? database? how long has the system been up?

GreetZ, AH

[Former Member]

Details FYI

SAP version - 700 IDES ECC 6.0 on Window server 2003 (32 Bit) with SQl Server 2005, RAM: 6 GB & Just restarted the server.

And cleared Swap from NTAB - Field Defination, Program & Table - Single record.

Thanks

- Rhishabh

[Former Member]

Pls let me know the # of swaps in ur system .

If the ratio of this number to the number of requests is very high, this indicates that the configuration of the buffer is too small

[former_member204746]

ECC 6.0 on 32-bit OS is not recommended.