Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Performance problem in PPM 9.1 SP2

SOLVED
Go to solution
Highlighted
Niraj Prabhu
Frequent Visitor

Performance problem in PPM 9.1 SP2

Hello,

 

I would like to know if anyone faced issues with the dashboard performance post upgrade to PPM 9.1 version. We upgraded from PPM 7.5 SP5 to PPM 9.1 SP2 and noticed that many dashboard pages with request list portlet are erroring out.

 

Let me know if you have any information on the performance tuning within PPM 9.1 that I can try.

 

Thanks,

Niraj

Niraj P.
16 REPLIES
Kerim KILIC
Frequent Visitor

Re: Performance problem in PPM 9.1 SP2

what is the oracle version? i faced performance issue with oracle 11.2.0.1, request list portlets and searches are all timing out, and got a fix from hp. but there is no performance issue with 11.2.0.2. If version 11.2.0.1, you can request fix from hp,(changes hints in the ootb queries), if you are on 11.2.0.2 check insallation quide for the oracle parameters hp suggest.

Niraj Prabhu
Frequent Visitor

Re: Performance problem in PPM 9.1 SP2

Hi

 

 

Niraj P.
Linda Hauck
Regular Collector

Re: Performance problem in PPM 9.1 SP2

No issues with performance so far at 9.12.

 

But there is a Hotfix we had to apply for problems with executing package lines in the Deployment Module.

Kerim KILIC
Frequent Visitor
Solution

Re: Performance problem in PPM 9.1 SP2

hi,

 

the case number is 4632227146, you can refer this one as reference. the fix changes ootb request list and search query hint from /*first 200 rows*/ to /*rule*/ like this.  you can realize performance improvement

Varun_PPM
Super Collector

Re: Performance problem in PPM 9.1 SP2

We had few performance issues after 9.12 upgrade.We had taken below steps.

 

1.Increased RAM.

2.Increased java heap size.

 

These were just preventive steps .we were able to resolve our performance issues by keeping watch on services running.After moving to 9.12 there were few errors coming from services node , that was the main reason of low performance.I would suggest try to fix any errors in server logs.

 

Niraj Prabhu
Frequent Visitor

Re: Performance problem in PPM 9.1 SP2

Varun,

 

Thanks for your reply. Yes I have already made changes in to JAVA_HEAP_SIZE, as it was one of the initial recommendations from HP. I could also delay or postpone some of the services to help the environment concerntrate on user traffic. As of now, these changes have not improved the environment performance, but these are strong recommendations.

 

Regards,

Niraj

Niraj P.
Niraj Prabhu
Frequent Visitor

Re: Performance problem in PPM 9.1 SP2

Kerim,

 

Thanks for the case number, I have reported this to HP, and have a strong vibes that this fix would help us improve the performance. I will keep everyone posted, as soon as I hear back from HP.

 

Regards,

Niraj

Niraj P.
Niraj Prabhu
Frequent Visitor

Re: Performance problem in PPM 9.1 SP2

Linda,

 

Thanks for your reply.

 

Can you provide your case number while following up with HP on the performance issue? I am sure it would be worth for HP to look into your case, in order to determine, if the fix provided to your environment is relevant as fix for our performance issue.

 

Regards,

Niraj

Niraj P.
Kerim KILIC
Frequent Visitor

Re: Performance problem in PPM 9.1 SP2

hi,

 

preparing fix for your organization will take time, if you are in a hurry, there is a oracle parameter optimizer_features_enabled that also will help you. but use this as a temporary solution.

mcwang
Super Collector

Re: Performance problem in PPM 9.1 SP2

Check the server.conf or in the admin console setting for PORTLET_EXEC_TIMEOUT make sure it's set to a reasonable number, ours is set to 120 secs.

Fatih_Turkoglu
Acclaimed Contributor

Re: Performance problem in PPM 9.1 SP2

Hi, We are also coming across with Performance issues in pages. Dashboard queries take too much time. PPM users  have complaint about it.

 

Is there any solution you have found for PPM 9.12  performance ?

Jim Esler
Honored Contributor

Re: Performance problem in PPM 9.1 SP2

There have been several times at various levels of PPM and Oracle that we have been able to address database performance issues by increasing the SGA Target setting on the database. Recommended values for this parameter were included in the Oracle ADDM report.

cotocald
Regular Collector

Re: Performance problem in PPM 9.1 SP2

Guys, 

 

Just some really usefull steps to improve performance:

 

• When did your client start noticing this performance degradation?
• Where do you see the delay? Logging in? PPM normal use? In a specific module or across all the application?
• Can you time up these delays and let me know how much time does PPM spends on these actions? Please compare with normal results as per your findings.
• Have you tried an index rebuild? If not, please engage your DBA on this and do it.
• What is the CPU capacity and the available RAM memory on the DB server?
• I suggest upgrading to PPM 9.12, it has big change compared to PPM 8.0 and we have solved some performance issues in PPM 9.12. Even if we solve the performance issue in 8.0, it does not mean that PPM has no performance after the customer has upgraded to PPM 9.12. Hence I suggest upgrading to PPM 9.12 first, and then we can provide performance tuning if PPM has performance issues. Perhaps the performance issue disappears after PPM is upgraded to 9.12.
• Please provide the Oracle AWR report.
• Oracle Version?
• Please take a look at the "Improving Advanced Searches" section in the Installation and Admin guide, this will also allow us to improve the system performance:
PPM Center users can search for requests based on custom fields defined in request types, request header types, and user data. Users can perform advanced searches to locate requests based on information that is defined as critical to business processes. As the number of requests logged increases, users performing advanced searches can experience slower performance. To improve performance during advanced searches, use the following guidelines:
* Specify additional request header fields in the advanced searches. Header fields are automatically indexed by PPM Center, and therefore yield faster returns.
* Add indexes to a limited number of detail fields, preferably fields that are commonly used in advanced searches. Take care not to add too many indexes, since this can affect the performance of inserts and updates to the database.
* Set the DEFAULT_REQUEST_SEARCH_ORDER_BY_ID server configuration parameter value to true to remove the sort order column on a request search. Record sorting slows performance.
* Change the value set for the REQUEST_SEARCH_RESULTS_MAX_ROWS server configuration parameter to restrict the maximum number of records retrieved.
* For portlet search queries, lower the value set for the PORTLET_MAX_ROWS_RETURNED server configuration parameter. For most portlets, 20 to 50 records is adequate. The default is 200.

• Another potential option to try in the Installation and Admin guide:
SORT_ELIMINATION_COST_RATIO
For certain restrictive (with good filters specified) and limited (returns few records) searches, PPM Center uses the FIRST_ROWS_N optimization mode. If a search such as this also uses SORT on one or more fields returned by the search, Oracle uses the INDEX on the sorted columns under the FIRST_ROW_N optimization, even if other indexes on supplied filters may yield to a better execution plan for a SQL statement. This often leads to a less desirable INDEX FULL SCAN on the index on sorted column.
Recommended Setting: Set the parameter value to 5. This directs Oracle to consider an execution plan with ORDER BY sort elimination, as long as the plan is no more expensive than five times the cost of the best-known plan (that uses sort).

• Also increasing the CPU power as recommended might help - have you checked the CPU usage on the PPM and database machines to see if they are currently overloaded. If the machines are not maxed out, increasing the CPUs is unlikely to have any effect.

-- Remember to give Kudos to answers! (click the KUDOS star)
AlexSavencu
Honored Contributor

Re: Performance problem in PPM 9.1 SP2

Guys,

First of all investigate together with your oracle admin, especially if you also upgraded the oracle server to a newer version. You can also do the basic steps, such as index rebuild and statistics gathering. Another thing to check: the cursor sharing must be set to similar!

In one of our implementations, we performed the following after investigating several awr reports from both production and non production environments:

--remember to kudos people who helped solve your problem
AlexSavencu
Honored Contributor

Re: Performance problem in PPM 9.1 SP2

Guys,

First of all investigate together with your oracle admin, especially if you also upgraded the oracle server to a newer version. You can also do the basic steps, such as index rebuild and statistics gathering. Another thing to check: the cursor sharing must be set to similar!

In one of our implementations, we performed the following after investigating several awr reports from both production and non production environments:
1. Created a separate tablespace for the large indexes and moved all large indexes there;
2. Created a separate tablespace for the largest and most frequently updated tables and moved them there.
3. For the most intensive queries, we implemented custom indexes and, where applicable, we also created views to cache data, thus making use of the cursor sharing policy set to similar.

Hope the above helps.

Cheers
Alex

--remember to kudos people who helped solve your problem
jerome.vovard
Regular Collector

Re: Performance problem in PPM 9.1 SP2

Hi All,

Do you know how to rebuild index? in which table?

How to get the list of intensive PPM tables?

 

//Add this to "OnDomLoad" event