Smarter Server - Database Statement Monitor

The DB Statement Monitor is responsible for gathering performance information of the creation and processing of database statements.

JMX Interface Name: com.ibm.team.server.monitoring.management.MonitorRollupMBean
JMX Object Name: team.server.<application public URI context>@<port>:type=DB Statement
JMX Object Name Example: team.server./jts@9443:type=DB Statement

A JMX object of this "type" will be created for each statement and each SQL statement processing phase: Prepare or Execute.

• DB Statement Monitor JMX Object Name: team.server.<application public URI context>@<port>:type=DB Statement
  
• DB Statement JMX Object Name: team.server.<application public URI context>@<port>:type=DB Statement,phase=(Prepare | Execute),name=<statement>
  

The DB Statement Monitor performance metrics information gathered in its attributes is a rolled up of the performance information from all the individual monitored database statements. Visually, the DB Statement Monitor objects structure is like the following:

   team.server./<URL>@<port>:type=Cache
          |
          |
          |----Prepare
          |             |
          |             |
          |             ---- team.server./<URL>@<port>:type=DB Statement,phase=Prepare,name="<statement>"
          |                      ...    
          |----Execute
                        |
                        |
                        ---- team.server./<URL>@<port>:type=DB Statement,phase=Execute,name="<statement>"
                        ...      

Monitor Attributes

Following are the attributes exposed by the DB Statement Monitor

JMX Attribute	JMX Type	Is Writeable?	Default Value	Description
TimeSinceLastReset	long	No	0	Total time since the last statistics reset
Threshold	java.lang.Long	Yes	0	Defines the maximum allowed time for a DB statement to be processed. If this time is exceeded a problem will be generated
MinimumResponseTime	long	Yes	0	Minimum response time from all the DB statements operations
MaximumResponseTime	long	Yes	0	Maximum response time from all the DB statements operations
Enabled	boolean	Yes	false	Whether this monitor is enabled. Default is disabled so no performance monitoring of DB statements is performed
Duration	long	Yes	0	Total duration of DB statements processing operations
Count	long	Yes	0	Counter of all monitored operations
AverageResponseTime	long	Yes	0	Average response time from all the DB statements

Note the attributes related with time statistics are expressed in miliseconds

Monitor Operations

Child MBeans

This section gathers information regarding MBeans that are contained within this monitor

DB Statement objects

JMX Interface Name: com.ibm.team.server.monitoring.jmx.beans.sql.SQLStatementRollupMBean
JMX Object Name: team.server.<application public URI context>@<port>:type=DB Statement,phase=(Prepare | Execute),name=<>
JMX Object Name Example 1 (DB Statement Prepare phase): team.server./ccm@9443:type=DB Statement,phase=Prepare,name="select t1.ITEM_ID, t1.STATE_ID from FRIENDS.FRIEND t1"
JMX Object Name Example 2 (DB Statement Execute phase): team.server./ccm@9443:type=DB Statement,phase=Execute,name="select t1.ITEM_ID, t1.STATE_ID from FRIENDS.FRIEND t1"

Attributes

Note the attributes related with time statistics are expressed in miliseconds

Operations

External links:

• IBM

Additional contributors: TWikiUser, TWikiUser