Chat now with support
Chat with Support

Spotlight on SAP ASE 2.12 - Release Notes

Tablespace Analysis drilldown I/O Times tab

The I/O Times tab on the Tablespace Analysis drilldown contains graphs that let you visually monitor average I/O times and buffer pool hit ratios for a tablespace. The four graphs track the following:  

  • Average amount of time spent on direct I/O.

  • Average amount of time spent on asynchronous I/O.

  • Average amount of time spent on physical I/O.

  • Buffer pool hit ratios.

All four graphs use counter data to show statistics as they change over time. This allows you to see when average I/O times are high and buffer pool hit ratios are low for a tablespace.      

Consistently high I/O times can be a symptom of I/O conflict. Consistently low hit ratios can be a sign that a buffer pool is not operating efficiently. Both problems degrade performance. To identify applications that are contributing to I/O conflict, work from the Client Application Analysis drilldown. To investigate buffer pool conditions, work from the Buffer Pool Analysis drilldown.

Graphs in the I/O Times tab

Click the links below to see descriptions of each graph in the I/O Times tab:

Average Direct I/O Times

Average Async I/O Times

Average Physical I/O Times

Read BP Hit Ratios

Functions for graphs

As you view graphs in the I/O Times tab, you can click icons in graph toolbars to:

Copy graph details to the clipboard

Change the graph view

Filter a graph

Maximize or restore a graph

Pan over a zoomed graph

Zoom a graph



Related topics


Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating