Oracle and MS SQL Database Performance Whitepapers

This page presents the database performance load testing and analysis whitepaper for Oracle and Microsoft SQL environments of cappm 15.4. Previously available in earlier releases as two separate PDFs, the whitepapers are now combined on one convenient page.
ccppmop154
This page presents the database performance load testing and analysis whitepaper for Oracle and Microsoft SQL environments of 
Clarity PPM
 15.4. Previously available in earlier releases as two separate PDFs, the whitepapers are now combined on one convenient page.
 
 
3
 
 
 
Disclaimer
: This document is not meant as a sizing guide or as a recommendation guide. Instead, it portrays possible user loads given a particular CA PPM configuration. We understand that customer requirements and environments differ. The CA PPM functionality that is exercised during these performance load tests may or may not match the functionality that individual companies deploy. CA does not recommend that customers acquire hardware based on this document. Instead, seek the sizing expertise of our technical pre‐sales and professional services personnel. The test environments outlined in this document do not consider reporting, process engine, and background service or failover requirements.
This document is for your informational purposes only. CA assumes no responsibility for the accuracy or completeness of the information. To the extent permitted by applicable law, CA provides this document “as is” without warranty of any kind, including, without limitation, any implied warranties of merchantability, fitness for a particular purpose, or non-infringement. In no event will CA be liable for any loss or damage, direct or indirect, from the use of this document, including, without limitation, lost profits, business interruption, goodwill or lost data, even if CA is expressly advised in advance of the possibility of such damages.
MS SQL is a trademark or registered trademark of Microsoft Corporation in the United States and/or other countries.
Executive Summary
To establish and publish performance benchmarks, CA conducted a series of tests for 
Clarity PPM
 Release 15.4 in a clustered Linux environment. The following high-level enhancements were made to the test infrastructure:
  • To simulate real-world activity, user concurrency was increased from 1,000 users to 2,000 users. Existing customer application logs were analyzed to ensure test throughput (number of actions performed) is on par with peak load for 2,000 concurrent users.
  • In addition to the UI actions performed, a background process was run in volume during the test. The process exported an updated project using the XML Open Gateway (XOG) and ran approximately 600 times per hour.
The test objectives were to:
  • Demonstrate the ability of the product to serve a large‐sized user base (20,000 users) on Intel‐based hardware using either of the following databases:
    • Oracle 12c (12.2.0.1.0) and Apache Tomcat version 8.5.23 application servers on a Linux clustered environment.
    • SQL Server 2014 EE 64-bit SP2 CU10 (12.0.5571.0) and Apache Tomcat version 8.5.23 application servers.
  • Establish performance benchmarks under load using a core set of application functionality on Intel‐based hardware and a Linux environment.
Performance Test Methodology
The load tests use a mixture of inquiry and update actions to simulate end‐user interaction with the product. The tests used 2,000 virtual users to simulate a peak usage period for a total user population of 20,000 registered users. Wait times ranged from 3 through 45 seconds, depending on the type of action. The performance test is measured for 180 minutes, including a ramp‐up time of about 50 minutes. The tests used a single database server with four application servers and with two background instance on two of the application servers, all running on physical servers. The actual experience for you as a customer depends on how your hardware is set up, how many modules are deployed, how the user actions are distributed among the population, and the access rights that are granted to your users.
: Testing at a 10% concurrency rate, 2,000 virtual users represent 20,000 registered users (2,000/.10=20,000). The 10% concurrency rate is typical for peak usage times.
Performance Test Results
Two Quad Core X3430 2.40GHz Xeon servers, each running one 15.4 application instance, can support a simulated load for 20,000 registered users (2,000 simultaneous virtual users) with Oracle or Microsoft SQL Server.
Results are drawn from the 2,000 virtual user 2.0 hour load tests. 
Summary of Test Results
Oracle
MSSQL
Average Transaction Response Time (in seconds)
0.65
0.97
Average Hits per second
33.21
33.03
Average Database Server CPU Utilization
47.10 %
22.20 %
Average Application Server 1 CPU Utilization
47.09 %
50.22 %
Average Application and Background Server 2 CPU Utilization
56.16 %
56.26 %
Average Application Server 3 CPU Utilization
 48.91 %
 48.48 %
Average Application and Background Server 4 CPU Utilization
54.19 %
59.11 %
Performance Test Conclusion
After comparing the average response times for the same functionality between 15.4 and the previous release, 15.4 performs equally or better than previous releases.
Oracle
CA PPM Release 15.4 (15.4.0.270) performs similar to CA PPM Release 15.3 (15.3.0.200) on similar hardware comparing the same counters.
MS SQL
CA PPM Release 15.4 (15.4.0.270) performs similar to CA PPM Release 15.3 (15.3.0.200) on similar hardware comparing the same counters.
: We have migrated our performance testing tool from HP LoadRunner to CA BlazeMeter. The current performance numbers are comparable with earlier releases and represent our new baseline for upcoming releases.
Database Performance Comparison by Release
Comparison by Functional Area
The following table shows the average response times by the major functional areas:
Functional Area
15.3.0 MSSQL
15.4.0 MSSQL
15.3.0 Oracle
15.4.0 Oracle
Project Management
1.24 
1.27 
0.90
0.99
Resource Management
1.92 
2.29 
1.38
1.61
Financial Management
1.59 
1.49 
1.55
1.42
General Navigation
0.52 
0.54 
0.43
0.45
Timesheets
0.44 
0.64 
0.30
0.33
Portfolios
0.53 
0.57 
0.37
0.33
All Timers
0.97 
0.97 
0.79
0.65
: The 
All Timers
 row represents the response time averages of all timers and not the average of the individual functional area averages. 15.3.0 numbers are from LoadRunner tool and 15.4.0 numbers are using new BlazeMeter tool.
Comparison by Response Time
The following charts compare the response times for the two releases (shorter bars are better):
Oracle
  Oracle_HD_FuncArea_Graph.PNG  
MSSQL
  MSSQL_HD_FuncArea_Graph.PNG  
Database Performance Test Environment
Load tests with 2,000 concurrent users were run. All tests were written and executed using HP LoadRunner 12.1. Each virtual user simulates one real user actively and repeatedly clicking through a given scenario. Wait times reflect only interaction delays (for example, completing a form before clicking Submit), not idleness and task interruption. The background server ran all jobs, reports, and processes to completion prior to the start of the performance test.
For the load tests, we used two application servers and one background server, each on their own hardware server:
CA PPM Database Performance Test Environment
CA PPM Database Performance Test Environment
Application and Background server software:
  • OS: RHEL 7.1
  • Java: 64-bit JDK 8u152
  • App: Tomcat 8.5.23
Application server JVM memory parameters:
  • Xms1024m
  • Xmx4096m
Oracle database server software:
  • OS: RHEL 6.5
  • DB: Oracle 12.2.0.1.0 (with 'optimizer_features_enable' value '12.1.0.2' string type)
MS SQL Server software:
  • OS: Windows Server 2012 Standard
  • DB: SQL Server 2014 EE 64-bit SP2 CU10 (12.0.5571.0)
Application & Background server hardware:
  • CPU: Quad Core X3430 2.40 GHz Xeon
  • RAM: 8 GB
Database server hardware:
  • CPU (Oracle): 32 Core E5-2640 2.0 GHz Intel Xeon
  • CPU (MSSQL): Octa Core E5-2640 v2 2.0 GHz Intel Xeon (2 processors)
  • RAM: 128 GB (64 GB for Oracle; 64 GB for MS SQL Server)
MS SQL Parameters:
  • System Memory: 128 GB
  • Processors: 32
  • Min Server Memory: 0
  • Max Server Memory: 100 GB
  • Max Worker threads: 0
  • Cost Threshold for Parallelism: 5
  • Max Degree of Parallelism: 1
  • Connection Timeout: 15
  • Max Number of Concurrent Connections: 0 (unlimited)
Database Size Details
Oracle
 
Projects
Resources
Teams
Assignments
Tasks
DB Size
15,483
 36,783
406,779
5,031,908
1,158,921
30 GB
MS SQL
Projects 
Resources
Teams 
Assignments 
Tasks 
DB Size
7,278
 14,691
188,421
 4,540,696
887,389
16 GB
Database Performance Graphs
App and Background Server CPU Utilization (Oracle)
  Oracle_HD_CPU_Graph.PNG  
App and Background Server CPU Utilization (MSSQL)
  MSSQL_HD_CPU_Graph.PNG  
DB Server CPU Utilization (MSSQL)
The following graph displays the sum of CPU utilization over all CPUs (not the average).
  MSSQL_HD_DB_CPU_Graph.PNG  
Heap Usage
The following graphs show the JVM heap usage during and after the load test for the application servers as well as the BG server.
Oracle
  Oracle_GC_Graph.png  
MSSQL
  MSSQL_GC_Graph.png  
Database Performance Use Cases
The same use cases apply to both Oracle and MS SQL environments. Each functional area consists of the following use cases:
Use
Case
Project
Management
Resource
Management
Financial
Management
General
Navigation
Timesheets
and Approvals
Portfolio
Management
1
X
 
 
 
 
 
2
X
 
 
 
 
 
3
 
 
X
 
 
 
4
X
 
 
 
 
 
5
X
 
 
 
 
 
6
X
 
 
 
 
 
7
X
 
 
 
 
 
8
X
 
 
 
 
 
9
 
 
 
 
 
 
10
 
 
 
X
 
 
11
 
X
 
 
 
 
12
 
 
 
 
X
 
13
 
X
 
 
 
 
14
 
X
 
 
 
 
15
 
 
 
X
 
 
16
 
 
X
 
 
 
17
 
 
 
 
 
 
18
 
 
 
X
 
 
19
 
 
 
 
X
 
20
 
 
 
 
 
 
21
 
 
 
 
 
X
Use Cases: Detailed Steps
 
 
5
 
5
 
 
 
Use Case 1: Create Projects
  1. Open PPM Login page. Wait 10 seconds.
  2. Log in to the application with user having Project create access rights. Wait 5 seconds.
  3. Click on Home -> Portfolio Management -> Projects link. Wait 10 seconds.
  4. Click New button on Project list page. Wait 20 seconds.
  5. Enter the all required fields to create project and click on Save button. Wait 10 seconds.
  6. Click on Team tab. Wait 10 seconds.
  7. Click on Add button to add resources to project. Wait 15 seconds.
  8. Filter for a Dev role resource to add to this project. Wait 15 seconds.
  9. Click on Add and Select More button to add Dev resources to project. Wait 10 seconds.
  10. Filter for a QA role resource to add to this project. Wait 15 seconds.
  11. Click on Add and Select More button to add QA resources to project. Wait 10 seconds.
  12. Filter for a Lead/Manager role resource to add to this project. Wait 15 seconds.
  13. Click on Add and Select More button to add Lead/Manager resources to project. Wait 10 seconds.
  14. Click on Task tab. Wait 5 seconds.
  15. Click on Gantt link from drop-down of Task tab to open the Gantt Editing Session. Wait 5 seconds.
  16. Click on Add Existing Subproject icon on Gantt page. Wait 5 seconds.
  17. Filter a Project (which is having 3 tasks) to add as a Subproject for created project. Wait 10 seconds.
  18. Select the filtered project and click on Add button to add as a subproject. Wait 10 seconds.
  19. Open the Subproject which is added, this opens a new Gantt editing window. Wait 10 seconds.
  20. Click on Add Existing Subproject icon on Subproject Gantt page. Wait 10 seconds.
  21. Filter a Project (which is having 3 tasks) to add as a Subproject. Wait 10 seconds.
  22. Select the filtered project and click on Add button to add as a subproject. Wait 10 seconds.
  23. Open the Subproject which is added to existing subproject, this opens a new Gantt editing window. Wait 10 seconds.
  24. Change one of the tasks by editing the start and finish dates. Click on Save button. Wait 55 seconds over 4 requests.
  25. Close the Gantt window. Wait 10 seconds.
  26. Refresh the parent Gantt window. Wait 10 seconds.
  27. Close this Gantt window. Wait 10 seconds.
  28. Refresh the master project Gantt window. Wait 10 seconds.
  29. Click on Expand All - verify that the changed task dates are displayed correctly. Wait 9 seconds.
  30. Close the Gantt editing window. Wait 10 seconds.
  31. Log out.
Use Case 2: PM Projects
  1. Go to Homepage. Wait 10 seconds.
  2. Log in to the application. Wait 5 seconds.
  3. View Project List. Wait 5 seconds.
  4. Open an existing Project. Wait 5 seconds.
  5. Access Project Dashboard tab with OOTB portlets. Wait 5 seconds.
  6. Access Project Properties and Project Team tabs Wait 15 seconds over 2 requests
  7. Use "Set Allocation" object action to update 15 selected team members to have 50% allocation. Wait 20 seconds over 2 requests.
  8. Use object action for "Commit Planned Allocation" to hard book selected team members. Wait 10 seconds over 2 requests.
  9. Log out.
Use Case 3: PM Financial Planning (View and Edit Cost Plan)
  1. View Cost Plan list page with 500 rows of cost plans. Wait 60 seconds divided over 6 requests.
  2. Open the detail of an existing Cost Plan. Wait 10 seconds.
  3. Update cost plan by repopulating and adding 4 additional detail rows. Wait 60 seconds divided over 6 requests.
  4. (Auto-addition of 3 rows by re-populate and manual addition of 1 row. Repeat for both re-populate types). Wait 120 seconds divided over 12 requests.
  5. View Benefit Plan list page (15 Benefit plans). Wait 50 seconds over 5 requests.
Use Case 3a: PM Financial Planning (Cost Plan 2)
  1. Create Cost Plan (Two grouping attributes) and add a cost plan detail row. Wait 235 seconds over 24 requests.
Use Case 3b: PM Financial Planning (Cost Plan 3)
  1. Create Cost Plan from Investment Team (Project duration 1 year, # of team members – 15, FTP type - Monthly). Wait 27 seconds over 20 requests
Use Case 3c: PM Financial Planning (Cost Plan 4)
  1. Create Cost Plan from Task Assignments (Project duration 1 year, # of task assignments – 15, FTP type - Monthly) and open Benefit Plans page. Wait 90 seconds over 14 requests.
Use Case 3d: PM Financial Planning (Cost Plan 5)
  1. Log in. Wait 5 seconds.
  2. Click on Projects link. Wait 5 seconds
  3. Expand the Projects filter. Wait 5 seconds
  4. Filter for Project. Wait 5 seconds
  5. Open Project. Wait 5 seconds
  6. Click on Financial Plans tab. Wait 5 seconds
  7. Click on New Cost Plan from Investment Team. Wait 5 seconds
  8. Select Grouping Attributes. Wait 5 seconds
  9. Click Save for new Cost Plan from Investment Team. Wait 5 seconds
  10. Go to Cost Plan Detail 1. Wait 5 seconds
  11. Click Return for Cost Plan Detail 1. Wait 5 seconds
  12. Click New Cost Plan from Task Assignments. Wait 5 seconds
  13. Select Grouping Attributes 2. Wait 5 seconds
  14. Click Save for New Cost Plan from Task Assignments. Wait 5 seconds
  15. Go to Cost Plan Detail 2. Wait 5 seconds
  16. Click Return for Cost Plan Detail 2. Wait 5 seconds
  17. Filter for New Cost Plan 1. Wait 5 seconds
  18. Open New Cost Plan 1. Wait 5 seconds
  19. Select Populate from Task Assignments. Wait 5 seconds
  20. Click Return for Cost Plan 3. Wait 5 seconds
  21. Filter for New Cost Plan 2. Wait 5 seconds
  22. Open New Cost Plan 2. Wait 5 seconds
  23. Click Populate From Investment Team. Wait 5 seconds
  24. Click Return for Cost Plan 4. Wait 5 seconds
  25. Click Project Properties. Wait 5 seconds
  26. Click Return for Projects. Wait 5 seconds
  27. Log out of the application.
Use Case 4: Create Project from Template
  1. Open PPM Login page. Wait 10 seconds.
  2. Log in to the application with user having Project create access rights. Wait 5 seconds.
  3. Click on Home -> Portfolio Management -> Projects link. Wait 10 seconds.
  4. Click on New from Template button. Wait 5 seconds.
  5. Click on Filter Project Icon(+) button. Wait 10 seconds.
  6. Filter for Project template(We are using three different templates for each iteration – First Project with 15 resources & ~80 tasks, Second project with 50 resources & 264 tasks and third project with 15 resources & 120 tasks). Wait 10 seconds.
  7. Select template and click on Next button. Wait 10 seconds.
  8. Enter all required fields to create a project and Click on Save button. Wait 5 seconds.
  9. Log out
Use Case 5: Gantt Toolbar
  1. Open PPM Login page. Wait 10 seconds.
  2. Log in to the application with user have Project create access rights. Wait 5 seconds.
  3. Click on Home -> Portfolio Management -> Project link. Wait 10 seconds.
  4. Click on the Filter project (+) icon. Wait 5 seconds.
  5. Filter for a project(with a min of 2000+ tasks associated to it). Wait 5 seconds.
  6. Click on filtered Project link to open project properties page. Wait 5 seconds.
  7. Click on Task tab. Wait 5 seconds.
  8. Click on Gantt link under Tasks tab. Wait 5 seconds.
  9. Click on Create New Task Icon on Gantt page. Wait 10 seconds.
  10. Enter the task name as task – I & fill other required fields to create task with and click on Submit and Create New button. Wait 10 seconds.
  11. Enter the task name as task – II & fill other required fields to create task with and click on Submit and Create New button. Wait 10 seconds.
  12. Enter the task name as task – III & fill other required fields to create task with and click on Submit and Create New button. Wait 10 seconds.
  13. Enter the task name as task – IV & fill other required fields to create task with and click on Submit and Create New button. Wait 10 seconds
  14. Enter the task name as task – V & fill other required fields to create task with and click on Submit and Create New button. Wait 10 seconds
  15. Enter the task name as task – VI & fill other required fields to create task with and click on Submit and Create New button. Wait 10 seconds
  16. Enter the task name as task – VII & fill other required fields to create task with and click on Submit and Create New button. Wait 10 seconds
  17. Enter the task name as task – VIII & fill other required fields to create task with and click on Submit and Create New button. Wait 10 seconds
  18. Enter the task name as task – IX & fill other required fields to create task with and click on Submit and Create New button. Wait 10 seconds
  19. Enter the task name as task – X & fill other required fields to create task with and click on Save button. Wait 10 seconds
  20. Click on filter Icon, enter the task name as ‘task’ and click on Filter button. Verify above tasks are available under search results. Wait 6 seconds
  21. Click on Copy Task from Template Icon on Gantt page. Wait 10 seconds
  22. Click on Filter Project Icon(+). Wait 5 seconds
  23. Filter for a project(with a min of 15+ resource and 80+ tasks associated to it). Wait 5 seconds
  24. Select the filtered project and click on Next button. Wait 5 seconds
  25. Click on + button to expand tasks. Wait 6 seconds
  26. Select the tasks and click on Copy button to copy tasks from template. Wait 6 seconds
  27. Click on Add Existing SubProject Icon on Gantt page. Wait 6 seconds
  28. Click on Filter Project Icon(+). Wait 10 seconds
  29. Filter for a project with a minimum of 15 resources and 80 tasks. Wait 5 seconds
  30. Select the filtered project and click on Add button to add subproject. Wait 5 seconds
  31. Click on Create New Project icon on Gantt page. Wait 15 seconds
  32. Enter the required fields to create project and click on Save and Return button. Wait 5 seconds
  33. Filter for the create project. Wait 5 seconds
  34. Select the filtered project and click on Assign Resources icon. Wait 5 seconds
  35. Filter a dev role Resource. Wait 37 seconds
  36. Select the filtered resource and Click on Assign button. Wait 10 seconds
  37. On Gantt page, select 3 tasks and click on Indent icon. Wait 5 seconds
  38. Click on expand button(+) of task having three indent tasks. Wait 5 seconds
  39. Select 2 tasks and click on Indent icon. Wait 5 seconds
  40. Click on expand button(+) of task having two indent tasks. Wait 5 seconds
  41. Select one task and click on Indent icon. Wait 10 seconds
  42. Click on expand button(+) of task having one indent task. Wait 10 seconds
  43. Select three top level tasks and Click on Indent icon. Wait 10 seconds
  44. Click on expand button(+) of task having three indent tasks. Wait 5 seconds
  45. Select above three indent tasks and click on Outdent tasks. Wait 5 seconds
  46. Select a task and click on Move task icon on Gantt page. Wait 5 seconds
  47. Click on Insert Before or Insert After buttons to move task to a particular place. Wait 5 seconds
  48. Select three tasks and click on Link icon. Wait 10 seconds
  49. Select same three tasks which are link and click on Unlink icon. Wait 10 seconds
  50. Click on start date or finish date of task. Wait 5 seconds
  51. Edit start date or finish date of Task – I. Wait 10 seconds
  52. Edit start date or finish date of Task – II. Wait 10 seconds
  53. Edit start date or finish date of Task – III. Wait 10 seconds
  54. Edit start date or finish date of Task – IV. Wait 10 seconds
  55. Edit start date or finish date of Task – V. Wait 5 seconds
  56. Click on Save icon to save above changes for dates. Wait 5 seconds
  57. On Gantt page, click Create Baseline icon. Wait 10 seconds
  58. Enter the required fields to create baseline and click on Save button. Wait 10 seconds
  59. Select five tasks and click on Update Task Baseline icon. Wait 10 seconds
  60. Click on Yes button to confirm update task baseline for tasks. Wait 10 seconds
  61. Select ten tasks and click on Delete (x) icon. Wait 10 seconds
  62. Select three tasks and click on Delete (x) icon. Wait 5 seconds
  63. Click on filter icon and click on Show all button to show all 2000+ tasks. Wait 5 seconds
  64. Click on Expand all(+) icon. Wait 5 seconds
  65. Click on Collapse all(-) icon. Wait 5 seconds
  66. Log out..
Use Case 6: Gantt WBS List
  1. Open PPM Login page. Wait 5 seconds.
  2. Log in to the application with user have Project create access rights. Wait 5 seconds.
  3. Click on Home -> Portfolio Management -> Project link. Wait 5 seconds.
  4. Click on the Filter project(+) icon. Wait 5 seconds.
  5. Filter for a project(with a min of 2000+ tasks associated to it). Wait 5 seconds.
  6. Click on filtered Project link to open project properties page. Wait 5 seconds.
  7. Click on Task tab. Wait 5 seconds.
  8. Click on Gantt link under Tasks tab. Wait 5 seconds.
  9. Select first task & click on Start date on Gantt page. Wait 5 seconds.
  10. Edit Start date & finish date of first task. Wait 5 seconds.
  11. Click on Save button to save dates for first task. Wait 5 seconds.
  12. Edit start date & finish date of first task (Row no 1). Wait 5 seconds.
  13. Edit start date & finish date of second task (Row no 2). Wait 5 seconds.
  14. Edit start date & finish date of third task (Row no 3). Wait 5 seconds.
  15. Edit start date & finish date of forth task (Row no 4). Wait 5 seconds.
  16. Edit start date & finish date of fifth task (Row no 5). Wait 5 seconds.
  17. Edit start date & finish date of sixth task (Row no 6). Wait 5 seconds.
  18. Edit start date & finish date of seventh task (Row no 7). Wait 5 seconds.
  19. Edit start date & finish date of eight task (Row no 8). Wait 5 seconds.
  20. Edit start date & finish date of ninth task (Row no 9). Wait 5 seconds.
  21. Edit start date & finish date of tenth task (Row no 10). Wait 5 seconds.
  22. Edit start date & finish date of eleventh first task (Row no 11). Wait 5 seconds.
  23. Edit start date & finish date of twelfth task (Row no 12). Wait 5 seconds.
  24. Edit start date & finish date of thirteenth task (Row no 13). Wait 5 seconds.
  25. Edit start date & finish date of fourteenth task (Row no 14). Wait 5 seconds.
  26. Edit start date & finish date of fifteenth task (Row no 15). Wait 5 seconds.
  27. Edit start date & finish date of sixteenth task (Row no 16). Wait 5 seconds.
  28. Edit start date & finish date of seventeenth task (Row no 17). Wait 5 seconds.
  29. Edit start date & finish date of eighteenth task (Row no 18). Wait 5 seconds.
  30. Edit start date & finish date of nineteenth task (Row no 19). Wait 5 seconds.
  31. Edit start date & finish date of twentieth task (Row no 20). Wait 5 seconds.
  32. Click on Save button to save all twenty changes & check the time taken for saving. Wait 5 seconds.
  33. Select a task and Click on Insert key/button on keyboard, a new row will be inserted under tasks to edit. Wait 5 seconds.
  34. Enter task name, start date & finish date. Wait 5 seconds.
  35. Click on Save button on Gantt page. Wait 5 seconds.
  36. Select a task, drag and drop into a new position (from top to bottom of the page). Wait 5 seconds.
  37. Select a task, drag and drop into a new position(causing the list to scroll). Wait 5 seconds.
  38. Click on scroll up to go starting point of task. Wait 5 seconds.
  39. Scroll down through the page to fetch next 100 records – I. Wait 5 seconds.
  40. Scroll down through the page to fetch next 100 records – II Wait 5 seconds.
  41. Scroll down through the page to fetch next 100 records – III Wait 5 seconds.
  42. Scroll down through the page to fetch next 100 records – IV Wait 5 seconds.
  43. Scroll down through the page to fetch next 100 records – V Wait 5 seconds.
  44. Scroll down through the page to fetch next 100 records – VI Wait 5 seconds.
  45. Scroll down through the page to fetch next 100 records – VII Wait 5 seconds.
  46. Scroll down through the page to fetch next 100 records – VIII Wait 5 seconds.
  47. Scroll down through the page to fetch next 100 records – IX Wait 5 seconds.
  48. Scroll down through the page to fetch next 100 records – X Wait 5 seconds.
  49. Scroll down through the page to fetch next 100 records – XI Wait 5 seconds.
  50. Scroll down through the page to fetch next 100 records – XII Wait 5 seconds.
  51. Scroll down through the page to fetch next 100 records – XIII. Wait 5 seconds.
  52. Scroll down through the page to fetch next 100 records – XIV. Wait 5 seconds.
  53. Scroll down through the page to fetch next 100 records – XV. Wait 5 seconds.
  54. Scroll down through the page to fetch next 100 records – XVI. Wait 5 seconds.
  55. Scroll down through the page to fetch next 100 records – XVII. Wait 5 seconds.
  56. Scroll down through the page to fetch next 100 records – XVIII. Wait 5 seconds.
  57. Scroll down through the page to fetch next 100 records – XIX. Wait 5 seconds.
  58. Click on Filter icon, enter the task name(which is having 4 levels of nested tasks) and click on Filter button. Wait 5 seconds.
  59. Click on the Expand(+) button of 4 level of nested task which is filtered. Wait 5 seconds.
  60. Click on the Expand(+) button for next 3 level of nested task. Wait 5 seconds.
  61. Click on the Expand(+) button for next 2 level of nested task. Wait 5 seconds.
  62. Click on the Expand(+) button for next 1 level of nested task. Wait 5 seconds.
  63. Click on Filter(+) icon, enter the task name(which is not having any resources assigned to it) and click on Filter button. Wait 5 seconds.
  64. Select the task and click on the resources field. Wait 5 seconds.
  65. Inline edit, enter resource name with dev role resource and select the resource to add to task. Wait 5 seconds.
  66. Inline edit, enter resource name with qa role resource and select the resource to add to task. Wait 5 seconds.
  67. Inline edit, enter resource name with lead role resource and select the resource to add to task. Wait 5 seconds.
  68. Click on the Save button to assign resources to task. Wait 5 seconds.
  69. Click on Filter icon, select the check box for ‘List View’ and click on Filter button. Wait 5 seconds.
  70. Click on Filter icon, enter the resource name under Assigned to Resources field and click on Filter button. Wait 5 seconds.
  71. Click on Filter (+) icon, enter the subproject name under Task name field and click on Filter button. Wait 5 seconds.
  72. Open Subproject which is filtered above, this opens a separate Gantt editing session. Wait 5 seconds.
  73. Click on the task start date field. Wait 5 seconds.
  74. Edit Start date of the task. Wait 5 seconds.
  75. Edit Finish date of the task. Wait 5 seconds.
  76. Click on Save button to save start & finish dates of task. Wait 5 seconds.
  77. Close the subproject Gantt window. Wait 5 seconds.
  78. Click on Refresh icon of master project. Wait 5 seconds.
  79. Click on Expand (+) button of Subproject to check the dates of task. Wait 5 seconds.
  80. Close Gantt window and Log out.
Use Case 7: Interactive Gantt Chart
  1. Open PPM Login page. Wait 5 seconds.
  2. Log in to the application with user having Project management access rights. Wait 5 seconds.
  3. Click on Home -> Portfolio Management -> Project link. Wait 5 seconds.
  4. Filter for a project(with a min of 10+ tasks associated to it) Wait 5 seconds.
  5. Click on Project link to open project properties page Wait 5 seconds.
  6. Click on Task tab. Wait 17 seconds.
  7. Click on Gantt link under Tasks tab. Wait 5 seconds.
  8. On Gantt page, under Timescale section locate finish date of Gantt task bar. Wait 26 seconds.
  9. Use Gantt task bar (drag to change), change finish date. Wait 5 seconds.
  10. Click on save button. Wait 27 seconds.
  11. Use Gantt task bar (drag to change) change start date. Wait 23 seconds.
  12. Click on save button. Wait 36 seconds.
  13. Use Gantt task bar (drag to change) move entire task to later dates. Wait 23 seconds.
  14. Click on save button. Wait 5 seconds.
  15. Change timescale value(Random selection for each iteration to Days, Weeks, Month, Quarters &Years) on the Gantt chart using the toolbar widget. Wait 32 seconds.
  16. Move Gantt time periods forward one column by clicking on Next Period(>) Icon. Wait 28 seconds.
  17. Move Gantt timescale forward one set of time periods by clicking on Next 12 Periods(>>) Icon. Wait 5 seconds.
  18. Click on Save button to save the changes. Wait 42 seconds.
  19. Link two tasks using drag and drop for Finish date of first task to Start date of second task, this would create a dependency. Wait 29 seconds.
  20. Link two tasks using drag and drop for Start date of first task to Start date of second task, this would create a dependency. Wait 21 seconds.
  21. Unlink above two tasks dependencies by selecting the tasks and click on unlink button. Wait 27 seconds.
  22. Log out.
Use Case 8: Auto-Schedule
  1. Open PPM Login page. Wait 5 seconds.
  2. Log in to the application with user having Project management access rights. Wait 5 seconds.
  3. Click on Home -> Portfolio Management -> Project link. Wait 5 seconds.
  4. Filter for a project(with a min of 15 resources & 50+ tasks associated to it). Wait 5 seconds.
  5. Click on Project link to open project properties page. Wait 5 seconds.
  6. Click on Unlock project button, if project is locked. Wait 5 seconds.
  7. Click on Task tab. Wait 5 seconds.
  8. Click on Gantt link under Tasks tab. Wait 5 seconds.
  9. Click on Autoschedule with Options -> Create Tentative Schedule. Wait 15 seconds.
  10. Edit Start date and Finish date. Wait 5 seconds.
  11. Click on Submit button. Wait 15 seconds.
  12. Click on Autoschedule with Options -> Publish tentative schedule. Wait 5 seconds.
  13. Click on Yes button to publish tentative schedule. Wait 5 seconds.
  14. Click on Autoschedule with Options icon Wait 5 seconds.
  15. Click on ‘Autoschedule’ button. Wait 5 seconds.
  16. Click on Autoschedule with Options -> Delete Tentative Schedule Wait 5 seconds.
  17. Click on Yes button to Delete tentative schedule Wait 10 seconds.
  18. Log out.
Use Case 10: General UI Behavior
  1. Page refresh on Project List page that configured to list 50 projects per page. Wait 70 seconds over 6 requests.
  2. Drill-down on a project, and click on the Team tab and Detail subtab. Wait 28 seconds over 3 requests.
  3. Add a new TSV column in Detail page Wait 83 seconds over 7 requests.
  4. Replace Assignment Roles. Wait 20 seconds over 2 requests.
  5. Select a Capacity Planning scenario from the “Team” tab Wait 40 seconds over 2 requests.
  6. Edit team member start date, team member finish date and allocation for at least 5 team members in this scenario and then click Save. Wait 42 seconds over 6 requests.
  7. Switch back to Plan of Record. Wait 10 seconds.
Use Case 11: PM Resource Management: Working with resources
  1. Open PPM Login page. Wait 10 seconds.
  2. Log in to the application with user having Resource management access rights. Wait 5 seconds.
  3. Click on Home -> Resource Management -> Resource link, to view the Resource List page. Wait 5 seconds
  4. Filter a resource which is allocated to at least 25 Projects. Wait 5 seconds.
  5. Click on the Resource Link, this will navigate to Resource properties page. Wait 10 seconds.
  6. Click on the Resource Allocations tab and view data on the Summary page. Wait 5 seconds.
  7. Click on Next Page Icon to go to Page 2 (assumes rows per page is set to 20). Wait 5 seconds.
  8. Click on Previous Page Icon to come back to Page 1. Wait 10 seconds.
  9. Click on Allocations - Detail page (this one has a TSV on it). Wait 10 seconds.
  10. Click on Next Periods (>) button under Allocation by Period section; advance time periods forward one set of periods. Wait 5 seconds.
  11. Click on Home -> Resource Management -> Resource Planning link. Wait 10 seconds.
  12. Click on Resource Planning -> Allocations tab. Wait 5 seconds.
  13. Click on Resource Planning -> Investments tab. Wait 5 seconds.
  14. Click on Resource Planning -> Capacity tab. Wait 5 seconds.
  15. Log out.
Use Case 12: Timesheets
  1. Open PPM Login page. Wait 10 seconds.
  2. Log in to the application with user having Timesheet submit access rights. Wait 3 seconds.
  3. Click on Home -> Personal -> Timesheet link. Wait 10 seconds.
  4. Filter Timesheet for same user & with a specific time period like start date - 1/1/20xx and end date - 1/7/20xx. (Pre-condition – User should have 2 or more tasks associated to a project and also Timesheet should be in Returned state, to modify, add/delete tasks, Submit/Return Timesheet). Wait 3 seconds.
  5. Click on Timesheet icon this will open timesheet page with time entry details for editing. Wait 3 seconds.
  6. Click on ‘Populate’ button, this would try to re-populate timesheet page asking for a confirmation. Wait 3 seconds.
  7. Confirm repopulate, click Yes button. Wait 5 seconds.
  8. Select and delete time entries of a task from timesheet page; this would navigate to next page for a confirmation to delete. Wait 3 seconds.
  9. Confirm Delete by clicking the Yes button. Wait 3 seconds.
  10. Click on Add Task button to show tasks available for this resource for time entry. Wait 5 seconds.
  11. Select the task which was deleted in a previous step (Step 8) and click Add. Wait 15 seconds.
  12. Fill the time entry details with 8 hours each from Monday to Friday and click on Submit for Approval button to submit timesheet. Wait 3 seconds.
  13. Open the Submitted timesheet by clicking on Timesheet icon. Wait 3 seconds.
  14. Click on Return timesheet button. Wait 3 seconds.
  15. Log out.
Use Case 13: PM Financial Transactions
  1. View Transaction Vouchers List Page (20 records on first page). Wait 25 seconds over 5 requests.
  2. View Transactions (Detail) List Page - Should Include 20 Transactions. Wait 5 seconds.
  3. Create a new transaction, retain values then click Submit and Create new. Wait 40 seconds over 7 requests.
Use Case 14: Departments
  1. Navigator. Wait 15 seconds over 2 requests.
  2. Departments (show 50 departments with 9 columns). Wait 5 seconds.
  3. Select department. Wait 5 seconds.
  4. Select resources. Wait 5 seconds.
  5. Select investments. Wait 5 seconds.
Use Case 15: Navigator – All Page Script
  1. Overview Wait 20 seconds over 3 requests
  2. General Wait 5 seconds
  3. Organizer Wait 5 seconds
    1. Tasks Wait 5 seconds
    2. Calendar Wait 5 seconds
    3. Process Wait 5 seconds
    4. Notifications Wait 5 seconds
  4. Dashboards Wait 5 seconds
    1. New Wait 5 seconds
    2. Cancel Wait 5 seconds
  5. Portlets Wait 5 seconds
  6. Chart Wait 5 seconds
    1. Select one
      1. Select Graph and Next Wait 5 seconds
      2. Back Wait 5 seconds
  7. Grid Wait 5 seconds
    1. Select one Wait 5 seconds
    2. Cancel Wait 5 seconds
  8. Filter Wait 5 seconds
    1. Cancel Wait 5 seconds
  9. Interactive Wait 5 seconds
    1. Cancel Wait 5 seconds
  10. Timesheets Wait 5 seconds
  11. Reports and jobs Wait 5 seconds
    1. Jobs Wait 5 seconds
    2. Reports Wait 5 seconds
  12. Account settings Wait 5 seconds
    1. Proxy Wait 5 seconds
    2. Notifications Wait 5 seconds
    3. Software downloads Wait 5 seconds
    4. Personal information Wait 5 seconds
  13. Organization
  14. Departments Wait 5 seconds
    1. New Wait 5 seconds
    2. Cancel Wait 5 seconds
  15. Knowledge Store Wait 5 seconds
  16. IT Service Management Wait 5 seconds
  17. Services – Wait 5 seconds
    1. New Wait 5 seconds
    2. Cancel Wait 5 seconds
  18. Requirements Planning
  19. Release Planning Wait 5 seconds
    1. New Wait 5 seconds
    2. Cancel Wait 5 seconds
  20. Releases Wait 5 seconds
    1. New Wait 5 seconds
      1. Cancel Wait 5 seconds
  21. Requirements Wait 5 seconds
    1. New Wait 5 seconds
      1. Cancel Wait 5 seconds
  22. Portfolios Wait 5 seconds
    1. New Wait 5 seconds
      1. Cancel Wait 5 seconds
  23. Projects Wait 5 seconds
    1. New Wait 5 seconds
      1. Cancel Wait 5 seconds
  24. New from template Wait 5 seconds
    1. Cancel
  25. Select project Wait 5 seconds
    1. Dashboard Wait 5 seconds
    2. Team Wait 5 seconds
      1. Detail Wait 5 seconds
      2. Role Capacity Wait 5 seconds
      3. Participants Wait 5 seconds
      4. Participant Groups Wait 5 seconds
      5. Requisitions Wait 5 seconds
      6. Staff Wait 5 seconds
    3. Task Wait 5 seconds
      1. Task List Wait 5 seconds
      2. Assignments Wait 5 seconds
    4. Chargebacks Wait 5 seconds
      1. Options Wait 5 seconds
      2. Transactions Wait 5 seconds
      3. Debit Rules Wait 5 seconds
        1. New Wait 5 seconds
          1. Cancel Wait 5 seconds
    5. Processes Wait 5 seconds
    6. Properties Wait 5 seconds
      1. Cancel Wait 5 seconds
  26. Programs Wait 5 seconds
    1. New Wait 5 seconds
      1. Cancel Wait 5 seconds
  27. Products Wait 5 seconds
    1. New Wait 5 seconds
      1. Cancel Wait 5 seconds
  28. Other Work Wait 5 seconds
    1. New Wait 5 seconds
      1. Cancel Wait 5 seconds
  29. Demand Management Wait 5 seconds
    1. Ideas Wait 5 seconds
    2. New Wait 5 seconds
      1. Cancel Wait 5 seconds
    3. Incidents Wait 5 seconds
  30. Resource Management Wait 5 seconds
  31. Resources Wait 5 seconds
    1. New Wait 5 seconds
      1. Cancel Wait 5 seconds
    2. Select one. Wait 5 seconds
    3. Skills Wait 5 seconds
      1. Add Wait 5 seconds
      2. Back Wait 5 seconds
    4. Allocations Wait 5 seconds
      1. Add Wait 5 seconds
      2. Back Wait 5 seconds
    5. Document Manager Wait 5 seconds
  32. Resource planning Wait 5 seconds
    1. Allocations Wait 5 seconds
    2. Capacity Wait 5 seconds
    3. Investments Wait 5 seconds
    4. Workloads Wait 5 seconds
  33. Resource Finder Wait 5 seconds
    1. Filter Wait 5 seconds
  34. Enter Resource ID Wait 5 seconds
    1. Search
      Wait 5 seconds
      1. Select one. Wait 5 seconds
  35. Skills Wait 5 seconds
    1. Add Wait 5 seconds
    2. Back Wait 5 seconds
  36. Allocations Wait 5 seconds
    1. Add Wait 5 seconds
      1. Back Wait 5 seconds
  37. Document Manager Allocations Wait 5 seconds
  38. Calendar Wait 5 seconds
  39. Properties Wait 5 seconds
    1. Cancel Wait 5 seconds
  40. Resource Requisitions Wait 5 seconds
  41. Transaction Entry Wait 5 seconds
    1. New Wait 5 seconds
    2. Transaction Entry Wait 5 seconds
  42. Post to WIP. Wait 5 seconds
  43. Create WIP Adjustment. Wait 5 seconds
  44. Approve WIP Adjustment. Wait 5 seconds
  45. Transactions. Wait 5 seconds
  46. Invoices. Wait 5 seconds
Use Case 16: PM Rate Matrix
  1. Open Rate/Cost Matrix. Wait 10 seconds.
  2. Create a new Matrix row properties page (5 assigned columns). Wait 45 Seconds over 5 requests.
Use Case 18: Administration – All Page Script
  1. Organization and Access Wait 2 seconds
    1. Resources
      1. Select resource Wait 2 seconds
      2. OBS and Partitions Wait 2 seconds
      3. Groups Wait 2 seconds
        1. Add Wait 2 seconds
        2. Back Wait 2 seconds
      4. Resource’s Access Rights – global Wait 2 seconds
        1. Add Wait 2 seconds
        2. Back Wait 2 seconds
      5. Access to this resource – Full view, Wait 2 seconds
        1. Continue Wait 2 seconds
        2. Add Wait 2 seconds
        3. Exit Wait 2 seconds
      6. Access to this resource –group Wait 2 seconds
        1. Add Wait 2 seconds
        2. Exit Wait 2 seconds
      7. Access to this resource – OBS unit Wait 2 seconds
        1. Add Wait 2 seconds
        2. Exit
      8. Groups Wait 2 seconds
      9. Select group Wait 2 seconds
        1. Resources Wait 2 seconds
          1. Add Wait 2 seconds
          2. Back Wait 2 seconds
        2. Group Access Rights – Instance Wait 2 seconds
          1. Add Wait 2 seconds
          2. Back Wait 2 seconds
          3. Group Access Rights – OBS Unit Wait 2 seconds
            1. Add Wait 2 seconds
            2. Exit Wait 2 seconds
          4. Group Access Rights – Global Wait 2 seconds
            1. Add Wait 2 seconds
            2. Back Wait 2 seconds
      10. OBS Wait 2 seconds
        1. New Wait 2 seconds
        2. Back Wait 2 seconds
  2. Studio
    1. Objects Wait 2 seconds
      1. Select Project: Wait 2 seconds
        1. Attributes Wait 2 seconds
          1. Select one Wait 2 seconds
          2. Back Wait 2 seconds
          3. New attribute Wait 2 seconds
          4. Back Wait 2 seconds
        2. Linking Wait 2 seconds
          1. Select one Wait 2 seconds
          2. Back Wait 2 seconds
          3. New Wait 2 seconds
          4. Back Wait 2 seconds
        3. Actions Wait 2 seconds
          1. Select one Wait 2 seconds
          2. Close Wait 2 seconds
          3. New Wait 2 seconds
          4. Close Wait 2 seconds
        4. Views Wait 2 seconds
        5. Audit Trail Wait 2 seconds
          1. Access To This Object Wait 2 seconds
          2. Full View Wait 2 seconds
          3. Resource Wait 2 seconds
          4. Group Wait 2 seconds
          5. OBS Unit Wait 2 seconds
      2. Queries Wait 2 seconds
        1. New Wait 2 seconds
        2. Back Wait 2 seconds
      3. Portlets Wait 2 seconds
        1. Select One
          1. Access To This Portlet
            1. Full View Wait 2 seconds
            2. Resource Wait 2 seconds
            3. Group Wait 2 seconds
            4. OBS Unit Wait 2 seconds
          2. Properties Wait 2 seconds
          3. Back Wait 2 seconds
        2. New Wait 2 seconds
          1. Chart Portlet Wait 4 seconds over 2 requests
          2. Grid Portlet Wait 4 seconds over 2 requests
          3. Filter Portlet Wait 4 seconds over 2 requests
          4. HTML Portlet Wait 4 seconds over 2 requests
          5. Interactive Portlet Wait 4 seconds over 2 requests
      4. Portlet Pages Wait 2 seconds
        1. Select one Wait 2 seconds
          1. Link Parameters Wait 2 seconds
            1. New Wait 2 seconds
            2. Back Wait 2 seconds
          2. Tabs Wait 2 seconds
            1. New Wait 2 seconds
            2. Back Wait 2 seconds
          3. Access To This Object Wait 2 seconds
            1. Back Wait 2 seconds
        2. New
          1. Back
      5. Add-Ins Wait 2 seconds
      6. UI Themes Wait 2 seconds
      7. Views Wait 2 seconds
        1. Select one Wait 2 seconds
          1. Exit Wait 2 seconds
  3. Data Administration
    1. Time Slices Wait 2 seconds
      1. Select one Wait 2 seconds
        1. Back Wait 2 seconds
      2. New Wait 2 seconds
        1. Back Wait 2 seconds
    2. Lookups Wait 2 seconds
      1. Select one Wait 2 seconds
        1. Parent Window Wait 2 seconds
        2. Values Wait 2 seconds
          1. Select one Wait 2 seconds
            1. Back Wait 2 seconds
        3. Auto Suggest Wait 2 seconds
          1. Back
        4. General Wait 2 seconds
          1. Back Wait 2 seconds
      2. New Wait 2 seconds
      3. Back Wait 2 seconds
    3. Reports and Jobs Wait 2 seconds
      1. Select one:
        1. Parameters Wait 2 seconds
          1. Access one Wait 2 seconds
            1. Back Wait 2 seconds
        2. Parameter order Wait 2 seconds
        3. Incompatible Jobs Wait 2 seconds
          1. Add Wait 2 seconds
            1. Back Wait 2 seconds
        4. Associated Categories Wait 2 seconds
          1. Add Wait 2 seconds
            1. Back Wait 2 seconds
        5. Access to this Job Wait 2 seconds
          1. Full View Wait 2 seconds
          2. Resource Wait 2 seconds
          3. Group Wait 2 seconds
          4. OBS Unit Wait 2 seconds
    4. Skills Hierarchy Wait 2 seconds
      1. New Wait 2 seconds
        1. Back Wait 2 seconds
    5. Notifications Wait 2 seconds
      1. Select one. Wait 2 seconds
        1. Cancel Wait 2 seconds
  4. Project Management
    1. Timesheet Options Wait 2 seconds
    2. Time Reporting Periods Wait 2 seconds
      1. New Wait 2 seconds
        1. Back Wait 2 seconds
    3. Charge Codes Wait 2 seconds
      1. New Wait 2 seconds
        1. Back Wait 2 seconds
    4. Input Type Codes Wait 2 seconds
      1. New Wait 2 seconds
        1. Back Wait 2 seconds
    5. Settings Wait 2 seconds
    6. Base Calendars Wait 2 seconds
      1. New Wait 2 seconds
        1. Close Wait 2 seconds
    7. Migrate Methods Wait 2 seconds
    8. Risk Settings Wait 2 seconds
  5. General Settings
    1. System Options Wait 2 seconds
    2. Site Links Wait 2 seconds
      1. New Wait 2 seconds
        1. Back Wait 2 seconds
    3. Client Downloads Wait 2 seconds
Use Case 19: Approve Timesheet
  1. Open a Timesheet. Wait 40 seconds over 5 requests.
  2. Approve Timesheet. Wait 5 seconds.
Use Case 21a: New Portfolio
  1. Log in. Wait 10 seconds over 2 requests.
  2. Click on Portfolios Link. Wait 5 seconds.
  3. Click on New portfolio button. Wait 20 seconds.
  4. Enter details and click Save. Wait 5 seconds.
  5. Click on Manual link. Wait 20 seconds.
  6. Click on Contents Editor tab. Wait 10 seconds.
  7. Select Projects, Assets and Applications and click on Include button. Wait 5 seconds.
  8. Click on Build Power Filter link for Projects. Wait 5 seconds.
  9. Select Description as power filter. Wait 10 seconds.
  10. Add Description as to power filter. Wait 5 seconds.
  11. Click on Evaluate button to validate the filter. Wait 5 seconds.
  12. Click Save and Return for Projects power filter. Wait 5 seconds.
  13. Click on Build Power Filter link for Assets. Wait 5 seconds.
  14. Select Description as power filter. Wait 10 seconds.
  15. Add Description as to power filter. Wait 5 seconds.
  16. Click on Evaluate button to validate the filter. Wait 5 seconds.
  17. Click Save and Return for Assets power filter. Wait 5 seconds.
  18. Click on Build Power Filter link for Applications. Wait 5 seconds.
  19. Select Description as power filter. Wait 10 seconds.
  20. Add Description as to power filter. Wait 5 seconds.
  21. Click on Evaluate button to validate the filter. Wait 5 seconds.
  22. Click Save and Return for Applications power filter. Wait 5 seconds.
  23. Click on Properties tab. Wait 5 seconds.
  24. Click on Synchronization Schedule link. Wait 10 seconds.
  25. Click on Sync Now button. Wait 10 seconds over two requests.
  26. Log out of the application.
Use Case 21b: New Portfolio
  1. Log in. Wait 10 seconds over two requests.
  2. Click on Portfolios link. Wait 5 seconds.
  3. Expand the filter. Wait 3 seconds.
  4. Filter for portfolio. Wait 3 seconds.
  5. Open portfolio. Wait 3 seconds.
  6. Click on Plans tab. Wait 5 seconds.
  7. Click on New button for new plan. Wait 10 seconds.
  8. Enter details and save plan 1. Wait 10 seconds.
  9. Select the created plan and click on Copy button. Wait 10 seconds.
  10. Enter details and save plan 2. Wait 5 seconds.
  11. Click on Investments tab. Wait 5 seconds.
  12. Click on Plans tab. Wait 5 seconds.
  13. Select plan 1 to edit. Wait 10 seconds.
  14. Edit and save plan 1. Wait 5 seconds.
  15. Click on Targets tab. Wait 10 seconds.
  16. Select plan 2 to edit. Wait 20 seconds.
  17. Edit and save plan 2. Wait 5 seconds.
  18. Return to plans list. Wait 5 seconds.
  19. Select plans 1 and 2 to delete. Wait 5 seconds.
  20. Delete selected plans. Wait 5 seconds.
  21. Log out of the application.
Use Cases: Detailed Load Test Results
The following file provides the 2,000-user load test results for each transaction:
Data Warehouse Size Details
The data warehouse feature (introduced in 
Clarity PPM
 Release 14.2) is optimized specifically for reporting and analytics. The data warehouse is installed on a separate schema from the 
Clarity PPM
 database schema. The data warehouse is populated at scheduled intervals by a 
Clarity PPM
 job. For customers upgrading to 
Clarity PPM
 15.4, the following sections provide examples of expected growth rates and loading times based on existing database sizes.
Expected Growth Rates
We sampled 10 customer data sets from various industries to get an idea of expected growth rates.
  image2016-8-12 12:36:56.png  
Expected Load Times
We sampled 10 customer data sets from various industries to get an idea of expected initial load times.
  image2016-8-12 12:37:31.png  
Functional Areas That Influence Growth
The following data points outline areas that influenced the load size of the data warehouse:
  image2016-8-12 12:38:4.png