Skip to main content

DB And CPU Count

  1. The first graph in the top section of the workload graphs page.
  2. The graph plots two important metrics as the name suggests.
    1. DB Time - The amount of time all of the databases spent executing queries.
      1. This includes queries spent time on CPU.
      2. Time spent waiting to read from / write to client connections.
      3. Time spent waiting to read / write data to disk blocks.
      4. Time spent on waiting to acquire locks, etc.
  3. CPU Time - The amount of time queries run on the CPU.
  4. If the DB time is high, while the CPU time is low, it means, queries are spending time on either I/O or waiting for locks. Either case, take a fresh look at the queries to reduce DB time.
  5. If the CPU time is high, it means the queries are taking longer to execute.
    1. In this case you may need to improve the queries
    2. Or you are running low on CPU resource, consider increasing the CPU core count.

Source