Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

RQM Performance issues during reporting

Questions
Tags
Users
Badges
Kunal N
(87●28●62) Oct 30 '17, 1:01 p.m.

 Hi All,


We have customized reports and dashboards in RQM, Earlier the dashboards and queries would reflect data within 1- 2 mins However since last few days we are experience performace issues with RQM. Queries on RQM are taking long time to retrieve data, it takes now around 4-5 minutes to fetch data. Same data earlier it used to take 1-2 mins.


Thank you,
Kunal
 

0 votes

Comments
Donald Nong
Oct 30 '17, 7:12 p.m.
You did not ask a question at all. If you ask for the "reason" behind the behavior that you observed, then your statement is not clear enough. When you say "4-5 minutes", does it mean that it takes the particular query 4-5 minutes to return results, or the query result has a 4-5 minutes "gap" between the up-to-date data? Note that it is very unlikely you can resolve a performance issue on this forum due to its complexity.

1 vote

Kunal N
Nov 01 '17, 8:04 a.m.
 Hi Donald, It is taking 4-5 minutes to return results for a particular query. Earlier same query used to take 1-2 minutes to fetch data. The amount of data fetched is same. What are all the reasons that may impact the performance. Thanks, Kunal

2 answers
5,422 views
0 votes

Accepted answer

Permanent link
Paul Slauenwhite
FORUM MODERATOR / JAZZ DEVELOPER (8.4k●1●2) Dec 01 '17, 7:58 a.m.

Consider opening a PMR for this performance issue (see How to open a PMR (external users)).

Kunal N selected this answer as the correct answer

0 votes

One other answer

Permanent link
Donald Nong
(14.5k●6●14) Nov 02 '17, 1:35 a.m.

Without any data, it will be very difficult to say. Just for argument's sake, I can say it's probably the CPU frequency has been capped to 500MHz from the original 2.5GHz. I can come up with other bizarre "reasons" but apparently it will not help you a bit.

You should at least have some basic performance monitoring in place, so that you can see where the bottleneck may be. Open a ticket with IBM Support if you have to, but please note that performance tuning is actually not in the support scope.

0 votes

Your answer

Register or log in to post your answer.

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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,144
× 7,622

Question asked: Oct 30 '17, 1:01 p.m.

Question was seen: 5,422 times

Last updated: Dec 01 '17, 7:58 a.m.

Confirmation Cancel Confirm