Converse agora com nosso suporte
Chat com o suporte

Spotlight on DB2 6.9.3 - Getting Started Guide

Index & Data Write Rate graph

The Index & Data Write Rate graph depicts rates for writing new and changed data and index pages from the buffer pool to the database over consecutive monitoring intervals. These rates are based on the number of pages written per second. The graph contains the following series:

  • Data —Plots the rate at which data pages are written from the buffer pools to the database.

  • Index —Plots the rate at which index pages are written from the buffer pools to the database.

  • D Sync —Plots the rate of synchronous data writes. These types of writes block further execution of the query until they are completed. A high synchronous data write rate can degrade performance.

  • I Sync —Plots the rate of synchronous index writes. These types of writes block further execution of the query until they are completed. A high synchronous index write rate can degrade performance.

For related statistical information

The Statistics tab shows the buffer pool read and write counts used to generate this graph. The names for these statistics begin with either Buffer Pool or I/O. These statistics are derived from the POOL data elements that the DB2 snapshot monitor captures.

 

Documentos relacionados

The document was helpful.

Selecione a classificação

I easily found the information I needed.

Selecione a classificação