Rego Service: Performance Management
System capacity wasn’t adequate for load requirements, the client maintained redundant allocation data, and users experienced long display load times on the Project List Page.
90 GB MSSQL Database
500 Active Users
14,000 Active Projects
Technical Details and Rego Solution: Redundant Instance Rights
Whenever items are bulk loaded an instance right is created. This is typically redundant because the user for the bulk load operation will have global rights. With Rego’s assistance these instance rights were safely removed.
Adding security checks that occur throughout the application will make the system more efficient and help with general performance.
Rego conducted an audit and query of the main CA PPM permission table to determine if there are candidates for purging instance rights rows. Typically when there is 15 to 20% of total rows, Rego recommends a clean up. This cleanup can occur through the front end. If there are multiple millions of rows this may hang the front end and not complete. Rego can construct a delete statement which will remove the redundant instance rights in batches. The delete can be scripted as a CA PPM job as well.
Technical Details and Rego Solution: Project List Page
Attribute value protection was configured to the slowest option for the project list page. Which adds overhead to rendering the page. Depending on the complexity of display conditions used on project properties pages the option can have a cascading negative performance effect on the list page or any Portlet built off of the project object data provider.
For every row on the list attribute value protection will have to evaluate the display condition which can add a significant amount of time. A secure subpage evaluates once to see if the user has access to those items.
Rego’s recommendation is to use secure subpages to lockdown fields for editing or viewing on properties pages and set attribute value protection to utilize secure subpages and ignore display conditions.
Technical Details and Rego Solution: Timeslice Configuration
When counting the total amount of time slice data Rego determined that daily allocation data accounted for 70% of all time slice rows. Rego reconfigured all time slices to a more realistic range and dramatically reduced the total number of rows.
Rego technicians uncovered a significantly undersized system, as well as background processes generating 10 million+ rows of redundant, orphan access rights. Examining average click and display times, Rego discovered a 4-second display rate on the Project List page which signaled inappropriate conditions and had a cascading effect on list page performance. Rego also discovered three-years-worth of unnecessarily maintained, redundant allocation data and advised the customer to contract for appropriate system capacity and clean redundant, orphan rights.
By removing display configurations and optimizing the page, Rego improved Project List responsiveness to 2.5 seconds. Rego also eliminated unneeded processing and improved system performance by altering time splice tables and background jobs.