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

PPM 9.14 performance issues related to views such as knta_users_v?

Highlighted
chintan_bhuva
Acclaimed Contributor

PPM 9.14 performance issues related to views such as knta_users_v?

Hi,

 

It's been almost 3 month since we upgraded to PPM 9.14 , and have been performance issues since then.

 

We kept digging in to figure out what was causing this and realized there were many factors. 

 

One of which is that the view 'knta_users_v' takes a lot of time in responding.  Is anyone else facing the same issue?

 

Thanks,

Chintan

3 REPLIES
ieroglif
Super Collector

Re: PPM 9.14 performance issues related to views such as client_users_v?

As option, try to monitor active sessions via DB client.

Best Regards,
Ieroglif.
TurboMan
Member

Re: PPM 9.14 performance issues related to views such as knta_users_v?

Another option is,

 

to build stats as

./kBuildStats.sh

 

In PPM Installation Admin guide 910 on Page: 483

says

"This information can be very important in improving
the overall performance of PPM Center."

 

 

Etienne_Canaud
HPE Expert

Re: PPM 9.14 performance issues related to views such as knta_users_v?

HI Chintan,

 

Do you have the information as to what component is querying the view KNTA_USERS_V? Is it an out-of-the-box PPM Portlet or a PPM page (if yes, which ones), or is it a custom portlet you created to retrieve users information?

 

Also, how many users do you have in the system?

 

Thanks,

Etienne.

//Add this to "OnDomLoad" event