Skip to Content
avatar image
Former Member

CPU UTILIZATION ISSUE

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Aug 24, 2007 at 09:54 AM

    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

    Add comment
    10|10000 characters needed characters exceeded