Skip to end of metadata
Go to start of metadata

Use

Avg log write time (log_writer_task) <duration> ms, <number_of> writes, <number_of> pages

Avg log write time (dev_thread) <duration> ms, <number_of> writes, <number_of> pages 

Explanation

The physical writing of log entries takes too long. There is the risk of a bottleneck.

User Response

Check the read and write operations in the disk area or device on which the log volumes are located. If possible, only the log entries should be made here, and no other read or write operations. In certain circumstances, you may need to move the log volumes to a quicker device.

More Information

Relevant  DB-Analyzer Files
Helpful with ...
DBAN_LOGGING.csvProvides information about log write times. 
SAP Note
Helpful with ...
  
Expert Sessions (Link to trainings)
Content / Helpful with ...
Session 10: SAP MaxDB LoggingProvides detailed information about the MaxDB logging concept.
Documentation (links)
Helpful with ...

Concepts of the Database System

How Databases Log Data Changes
<übernommen>

 

 

  • No labels