r1 - 2018-07-19 - 09:12:00 - RichardWattsYou are here: TWiki >  Deployment Web > DeploymentMonitoring > CLM605MXBeans > Common605Beans > SQLActivityMetricsTask

SQLActivityMetricsTask todo.png

Build basis: 6.0.5


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


Syntax


com.ibm.team.foundation.sqlactivity:name=<<contextRoot>>, 
  type=sqlActivityMetrics, 
  id=* 


Frequency: 60 Minutes



Attributes


Attribute Description Type
sqlActivityInterval The interval in milliseconds used for capturing the sql activity in this bean Long
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


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


Syntax


com.ibm.team.foundation.sqlactivity:name=<<contextRoot>>, 
  type=sqlActivitySummaryMetrics, 
  sqlStmtType=* 


Frequency: 60 Minutes



Attributes


Attribute Description Type
sqlActivityInterval The interval in milliseconds used for capturing the sql activity in this bean Long
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



Related topics: Common Managed Beans

Edit | Attach | Printable | Raw View | Backlinks: Web, All Webs | History: 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