Chat now with support
Chat with Support

Spotlight on SAP ASE 2.12 - User Guide

Spotlight on SAP ASE
Background Information Desktop Features Connect to SAP ASE Spotlight® on SAP ASE Drilldowns Spotlight® on SAP ASE Alarms Glossary
Spotlight Basics
Spotlight Connections Monitor Spotlight Connections Alarms Charts, Grids And Home Page Components View | Options Troubleshooting
Spotlight History Spotlight on Windows
Connect to Windows Systems Background Information Home Page Alarms Drilldowns View | Options Troubleshooting
Spotlight on Unix About us Third-party contributions Copyright

Buffer Pool Analysis drilldown I/O Times tab

The I/O Times tab on the Buffer Pool Analysis drilldown contains graphs that let you visually monitor average I/O times and buffer pool hit ratios for a buffer pool. 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 buffer pool.      

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 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 Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating