EditAttachPrintable
r2 - 2013-07-18 - 15:22:26 - JorgeAlbertoDiazYou are here: TWiki >  Deployment Web > SmarterServerDataDictionary > CLMServerMonitoringDBStatementMonitor

Smarter Server - Database Statement Monitor

Authors: JorgeAlbertoDiaz
Build basis: Collaborative Lifecycle Management 4.0.4

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
AverageResponseTime long Yes 0 Average response time from all the DB statements
Count long Yes 0 Counter of all monitored operations
Duration long Yes 0 Total duration of DB statements processing operations
Enabled boolean Yes false Whether this monitor is enabled. Default is disabled so no performance monitoring of DB statements is performed
MaximumResponseTime long Yes 0 Maximum response time from all the DB statements operations
MinimumResponseTime long Yes 0 Minimum response time from all the DB statements operations
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
TimeSinceLastReset long No 0 Total time since the last statistics reset

Note the attributes related with time statistics are expressed in miliseconds

Monitor Operations

JMX Operation Signature Return Type Description
dismissAllProblems() void When called, all the problems tracked by this monitor are dismissed
reset() void When called, resets the statistics of the monitor

Child MBeans

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

DB Statement objects

An instance of a monitored DB statement object in Prepare or Execute phase. A different JMX object is created for the Prepare and Execute phases of the statement processing.

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

JMX Attribute JMX Type Is Writeable? Default Value Description
AverageResponseTime long Yes 0 Average response time spent processing this statement
Count long Yes 0 Counter of monitored operations
Duration long Yes 0 Total duration of the processing operations for this statement
MaximumResponseTime long Yes 0 Maximum response time that took to process this statement
MinimumResponseTime long Yes 0 Minimum response time that took to process this statement
SQL java.lang.String No SQL statement SQL statement. It matches the value of "name" of the JMX Object name of this statement instance removing scaping characters
TimeSinceLastReset long No 0 Total time since the last statistics reset

Note the attributes related with time statistics are expressed in miliseconds

Operations

JMX Operation Signature Return Type Description
reset() void When called, resets the statistics of this monitored statement



External links:

Additional contributors: TWikiUser, TWikiUser

Edit | Attach | Printable | Raw View | Backlinks: Web, All Webs | History: r6 | r4 < r3 < r2 < r1 | More topic actions...
 
This site is powered by the TWiki collaboration platformCopyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Contributions are governed by our Terms of Use. Please read the following disclaimer.
Ideas, requests, problems regarding the Deployment wiki? Create a new task in the RTC Deployment wiki project