Tchater maintenant avec le support
Tchattez avec un ingénieur du support

Spotlight on SAP ASE 2.11 - 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

Open Objects I/O sub-page

Open Objects I/O sub-page*

The Open Objects I/O sub-page displays a grid that shows a listing of each object on the selected database (selected on the Databases grid) that is either open, or has been open, and related I/O activity.

Objects are only removed from the list if the configured number of "open objects" is exceeded. Then they are aged out to make room for newly opened objects.

The following table defines the columns on the Open Objects I/O for Database grid:

Column

Definition

Object Name

Name of the object. Each name can be expanded to show which objects belong to a table. 

Logical Reads

Total number of buffers read

Physical Reads

Number of buffers read from disk

APF Reads

Number of Asynchronous Pre-Fetch buffers read

Pages Read

Total number of pages read

Physical Writes

Total number of buffers written to disk

Pages Written

Total number of pages written to disk

Rows Inserted

Number of rows inserted

Rows Deleted

Number of rows deleted

Rows Updated

Number of rows updated

*The Open Objects I/O sub-page only displays in Adaptive Server versions 12.5.0.3 or later.

 

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation