database cache hit ratio is very low is about 11%

[former_member214873]

Dear all,

Our SAP ERP development server is on sap distributed environment in

vmware esxi environment.

centeral instance information

AEOM1SAP08(172.16.1.87)

RAM : 4 GB

CPU : 4 core processors 2.93 Ghz, 2.93 Ghz

SWAP : 25 GB

database server information

AEOM1SAP04(172.16.1.83)

RAM : 20 GB

CPU : 8 core processors 2.93 Ghz, 2.93 Ghz

swap :40 GB

database server consist of three database instance

AED sap erp development server(database buffer pool memory 8GB)

EDE sap enterprise portal server (database buffer pool memory 8 GB )

AES sap solution manager server (the database currently stopped )

RAM : 11 GB utillization of database server about 20 GB

In st04 transaction memory parameters

physical size of memory --> 20 GB

current database memory --> 8GB

database cahe memory --> 5 GB and Hitratio:11%

proc cache memory --> 1.5 GB and Hitratio 98%

SQL memory setting --> FIXED

and the warning are coming as follows

latch wait time per request(ms) execeeds 20 milliseconds

wait time per log write(ms) execeeds 10 milliseconds

check the IO performance of the database server

and In SM12 large of tables are locking and is running very slow users

are not able perform their work in development server

below iam attaced required information

thanks and regards

sudheerk

7382383262

[former_member189546]

Hello,

Please check

Note #987961 FAQ: SQL Server I/O performance

regards,

John Feely