Using the Open SQL Statistics

Prerequisites

You are in Start of the navigation pathTroubleshooting Next navigation step Database Next navigation step Open SQL Monitors Next navigation step Open SQL StatisticsEnd of the navigation path of SAP NetWeaver Administrator.

Context

The SQL Statistics monitor displays accumulated statistics about JDBC methods executed on each DataSource. The statistics include the number of executions, the elapsed time for execution, and the number of affected rows, if possible. Additionally, some average values for the elapsed time and the affected rows are displayed.

Procedure

  • You can switch on or off the Open SQL statistics by choosing Switch On or Switch Off , respectively.
  • To view method execution details for a particular DataSource, select the DataSource in the Available SQL Statistics area. The SQL Statistics Details about the DataSource area opens.

    • To view database access statistics about queries, choose the Queries tab. For each SQL statement, statistical details about Prepare , executeQuery and next calls are displayed.

    • To view details about the executed DML statements regarding Prepare , executeUpdate and executeBatch calls, choose the DMLs tab.