[
https://issues.apache.org/jira/browse/TRAFODION-2420?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16222625#comment-16222625
]
ASF GitHub Bot commented on TRAFODION-2420:
-------------------------------------------
GitHub user selvaganesang opened a pull request:
https://github.com/apache/incubator-trafodion/pull/1279
[TRAFODION-2420] RMS Enhancements
Refactored the ESP memory management so that all the SQL memory both
heap and space objects are accounted correctly in RMS
With this change, the total SQL memory used by all processes involved
in the query is represented in the counter "SQL Heap WM"
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/selvaganesang/incubator-trafodion
trafodion-2420_9
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/1279.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #1279
----
commit 32aaad0cbc7a3ba7cd590cfb689a94573750805b
Author: selvaganesang <[email protected]>
Date: 2017-10-27T15:41:26Z
[TRAFODION-2420] RMS Enhancements
Refactored the ESP memory management so that all the SQL memory both
heap and space objects are accounted correctly in RMS
With this change, the total SQL memory used by all processes involved
in the query is represented in the counter "SQL Heap WM"
----
> RMS enhancements
> ----------------
>
> Key: TRAFODION-2420
> URL: https://issues.apache.org/jira/browse/TRAFODION-2420
> Project: Apache Trafodion
> Issue Type: New Feature
> Components: sql-general
> Affects Versions: 2.1-incubating
> Reporter: Selvaganesan Govindarajan
> Assignee: Selvaganesan Govindarajan
> Fix For: 2.2-incubating
>
>
> Improve RMS to provide the following features/capabilities:
> 1. Currently RMS can list queries that consumed cpu time between two time
> points. However, the calls to storage engine like hbase, hdfs etc are
> blocking and these blocked APIs will not allow the Trafodion SQL engine
> scheduler to detect the cpu time spent during the time the call was blocked.
> Introduce a feature called SE offender (storage engine offender) to list the
> queries that are blocked in storage engine more than a certain duration.
> 2. Remove counters that are no longer updated or needed
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
