Slow performance - best practices / known issues for Clarity

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Performance in one or more areas of Clarity is slow. What are Best Practices / List of Known issues to help alleviate any issues? What can help ensure our system is optimized to avoid issues?

Resolution

See the below links for known issues/best practices/optimizing tips. This may not be a complete list, so it's also recommended to search in our knowledge base for any other known issues.

Table of Contents

• Section 1: Knowledge Articles
  • Best Practices
  • Troubleshooting KBs
  • General Performance Issues
  • Processes / Jobs
    • Custom
    • Rate Matrix Specific
    • Time Slicing Job
  • Advanced Reporting
  • Log in Performance
  • Portlet/List Views
  • Projects/Ideas
    • Create
    • Tiles
    • Board
    • Saving
  • Microsoft Project
  • Timesheets
  • Per Period Metrics (Modern UX TSV)
  • GCP/PostgresSQL Specific KBs
  • MS SQL Server
• Section 2: Tech Docs links

Section 1: Knowledge Articles

Best Practices

• XOG use: Avoiding server slowdown and OutOfMemory
• AVP settings: Configure to improve performance
• Using Search in Clarity: Avoiding application overload / OutOfMemory errors
• MSSQL Server maintenance guidelines for optimal performance

Troubleshooting KBs

• Using Clarity Action Trace
• Manual heap dump for application hanging or slow performance
• Resource Planning portlets performance troubleshooting

General Performance Issues

• Unable to connect, white screen, or getting Unable to communicate error - Using Traceroute to resolve
• Slow Performance on updates made in application - due to DB level row locks / blocking sessions on the database.
• Slow performance/blank page when trying to login to Clarity
• Performance on Overview page with multiple large portlets added to the view
• Performance issues due to pool connection limit of 1000 being exceeded - This can cause issues with jobs, time slices, and general slowness.

Processes / Jobs

Custom

• Slow custom processes or jobs - BG performance Issues

Rate Matrix Specific

• Rate Matrix Extraction Job Performance
• Rate Matrix Extraction Job Parameters for Performance

Time Slicing Job

• Time Slicing job appears to be hanging - troubleshooting
• Time Slicing job slow performance - troubleshooting

Advanced Reporting

• Advanced Reporting: Known KBs related to slow performance

Log in Performance

• Slow log in to Clarity when large portlets are on home page

Portlet/List Views

• Resource Planning portlets performance troubleshooting
• Slow Performance on List View with more than 10-15 Columns
• Object List Page slow after adding a Calculated Attribute - (Defect fixed in 15.6.1)
• Portlet or list view performance slowness optimization
• AVP settings: Configure to improve performance

Projects/Ideas

Create

• New UX - Create project performance is slow on merge in ODF_ITEM_POSITIONS - DE55011 (Impacts 15.7.1, 15.8, 15.8.1 - fixed in 15.9)
• New UX - Create project performance is slow on merge in ODF_ITEM_POSITIONS - DE59337 (Impacts 15.9 and 15.9.1 - fixed in 15.9.2)

Tiles

• Project Tiles Project Manager search screen slow for non admins (DE61893 - Impacts 15.9.2)
• Project Tile selection is slow to display the contents in Modern UX (DE49702 - Impacts 15.5.1 - Fixed in 15.6)
• Modern UX - Performance issue - Project Tile page - (Impacts 15.8.1, no longer reproducible in 15.9.1)

Board

• No options in the Board view for Columns and Color by due to slow performance (DE60174) - (Impacts 15.8.1, 15.9, 15.9.1 - fixed in 15.9.2)

Saving

• Slowness Saving Projects and Ideas

Microsoft Project

• MSP Integration performance best practices 

Timesheets

• Performance Issue in Timesheet Grid in modern UX - (DE59958 - Impacts 15.9.1 and 15.9.2 - targeted to be fixed in 15.9.3)

Per Period Metrics (Modern UX TSV)

• Per Period Metrics performance - best practices to prevent

GCP/PostgresSQL Specific KBs

• Performance Issues when Launching Project Hierarchy Tab with Custom Attribute Configured - Postgres
• Jobs stuck in processing for Clarity PostgreSQL GCP (SAAS)
• Postgres General Performance issues in Clarity SaaS
• Performance for some users is very slow after the 15.9 upgrade

MS SQL Server

• MSSQL Server maintenance guidelines for optimal performance

Section 2: Tech Docs links

• View System Statistics and Log Data
• Governor Settings (Maximum Data Limits)
• Optimize Oracle 12c Performance
• Optimize Oracle 19c Performance
• Clarity PPM Architecture and Sizing Recommendations
• Tune Sun HotSpot JVMs
• Blog: CA PPM Application Housekeeping
• Database Performance Whitepapers

Additional Information

See also:

• Clarity frequently reported issues
• Known Clarity issues: Tips in using Self Service