<div id="header-title" style="padding: 10px 15px; border-width:1px; border-style:solid; border-color:#FFD28C; background-image: url(<nop>https://jazz.net/wiki/pub/Deployment/WebPreferences/TLASE.jpg); background-size: cover; font-size:120%"> ---+!! !SQLActivityMetricsTask <img src="https://jazz.net/wiki/pub/Deployment/WebPreferences/todo.png" alt="todo.png" width="50" height="50" align="right"> Build basis: 6.0.5 %ENDCOLOR%</div></sticky> #TopPage <!-- Page contents top of page on right hand side in box --> <sticky><div style="float:right; border-width:1px; border-style:solid; border-color:#DFDFDF; background-color:#F6F6F6; margin:0 0 15px 15px; padding: 0 15px 0 15px;"> %TOC{title="Managed Beans"}% </div></sticky> <sticky><div style="margin:15px;"></sticky> <br> ---+ SQL Activity This provides the SQL activity during the specified interval as a MBean. This is useful to understand the standard patterns of SQL activity in a production system. This is useful to track the counts and average response times for many SQL queries. Helps to understand the high runners and optimize them. Also helps to drive data partitioning decisions and preserve the query response time. ---+++!! Advanced Property You enable this bean by setting *Enable SQL Activity Metrics MBean* to *true* ---+++!! Object Name <verbatim> com.ibm.team.foundation.sqlactivity:name=<<contextRoot>>, type=sqlActivityMetrics, id=* </verbatim> ---+++!! Default Frequency for Publishing 60 Minutes ---+++!! Attributes %TABLE{ sort="on" tableborder="1" cellpadding="3" cellspacing="3" headerbg="#D5CCB1" headercolor="#666666" databg="#FAF0D4, #F3DFA8" headerrows="1" footerrows="1" }% | *Attribute* | *Description* | *Type* | | creationTimeStamp | This is the time when the MBean was updated with a snapshot of the relevant data | Timestamp | | host | This is the host name where the CLM application is running | String | | port | This is the port number where the CLM application is accessible on the host. The value is -1 if the port is not set. | int | | contextRoot | This is the application root context for the CLM application | String | | nodeId | This is the application node id in case the CLM application is clustered | String | | Domain | This is the namespace for the application under which the MBean data is published | String | | sqlHash | This is unique hashcode for this specific SQL statement | String | | sqlStmt | This is the SQL statement | String | | sqlMinTime | The smallest execution time (in ms) for all instances of this statement | Integer | | sqlMaxTime | The largest execution time (in ms) for all instances of this statement | Integer | | sqlTotalTime | The total sum execution time (in ms) for all instances of this statement | Integer | | sqlTotalCount | The number of times this statement was executed | Integer | | sqlAverageTime | The average execution time (in ms) for all instances of this statement | Float | | sqlLastExecutedTimestamp | The time this statement was last executed | Date | | sqlStmtType | The type of transaction. Values are read, write or other | String | | sqlActivityInterval | The interval in milliseconds used for capturing the sql activity in this bean | Long | <br> [[#TopPage][Back to top]] <hr> ---+ SQL Activity Summary This provides the summary SQL activity during the specified interval as a MBean. This is useful to understand the standard patterns of SQL activity in a production system. This is useful to track the counts and average response times for many SQL queries by type. Helps to understand the high runners and optimize them. Also helps to drive data partitioning decisions and preserve the query response time. ---+++!! Advanced Property You enable this bean by setting *Enable SQL Activity Metrics MBean* to *true* ---+++!! Object Name <verbatim> com.ibm.team.foundation.sqlactivity:name=<<contextRoot>>, type=sqlActivitySummaryMetrics, sqlStmtType=* </verbatim> ---+++!! Default Frequency for Publishing 60 Minutes ---+++!! Attributes %TABLE{ sort="on" tableborder="1" cellpadding="3" cellspacing="3" headerbg="#D5CCB1" headercolor="#666666" databg="#FAF0D4, #F3DFA8" headerrows="1" footerrows="1" }% | *Attribute* | *Description* | *Type* | | creationTimeStamp | This is the time when the MBean was updated with a snapshot of the relevant data | Timestamp | | host | This is the host name where the CLM application is running | String | | port | This is the port number where the CLM application is accessible on the host. The value is -1 if the port is not set. | int | | contextRoot | This is the application root context for the CLM application | String | | nodeId | This is the application node id in case the CLM application is clustered | String | | Domain | This is the namespace for the application under which the MBean data is published | String | | sqlTotalTime | The total sum execution time (in ms) for all sql statements of this type | Integer | | sqlTotalCount | The number of times this type of statement was executed | Integer | | sqlAverageTime | The average execution time (in ms) for all sql statements of this type | Double | | sqlStmtTime | The type of statement. Values are read, write or other | String | | sqlActivityInterval | The interval in milliseconds used for capturing the sql activity in this bean | Long | <br> [[#TopPage][Back to top]] <hr> ---+++++!! Related topics: [[Common605Beans][Common Managed Beans]] <sticky></div></sticky>
This topic: Deployment
>
WebHome
>
DeploymentMonitoring
>
CLM605MXBeans
>
Common605Beans
>
SQLActivityMetricsTask
History: r3 - 2018-09-20 - 15:31:16 - Main.syeshin
Copyright © by IBM and non-IBM 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
.
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more
here
.