Project and Portfolio Management Practitioners Forum
cancel

PPM 9.14 performance issues related to views such as knta_users_v?

Highlighted
chintan_bhuva
New Member.

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
Respected Contributor.

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
Honored Contributor.

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
Outstanding Contributor.

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.