CPU UTILIZATION ISSUE

[Former Member]

hai ,

we have sql server 2000 with sap 4.7 and my db size is nearly 400GB.

at peak load my server CPU utlization is very low ,nearly 10-20% .

I have gone through sql parameters and sap parameters with reference to SAP notes ,but even after some changes in SAP parameters i have same issues .

suggest if some more changes needed

regards

jase

[Former Member]

Hey Jase,

It very common to db server to be in a low CPU utilization,

this is due to the fact that I/O is slower than CPU,

and most of the DB actions are I/O and not CPU.

If you want to improve the performance,

you should first check where is the bottleneck,

if it in the application server or DB server.

(in case of ABAP server, you can use SE30)

Performance tunning in application server can be chaining the code, increasing the

buffers sizes and etc.

DB server, can be improved by new indexes, changes of buffers and etc