ETMReadAccessControlPerformanceReport < Deployment

Engineering Lifecycle Management Wiki - Deployment
Community information and contribution guidelines
TWiki > Deployment Web > DeploymentPlanningAndDesign > PerformanceDatasheetsAndSizingGuidelines > ETMReadAccessControlPerformanceReport
Revision 11 - 2026-10-16 - 15:36:58 - SameerkumarKalaria
<div id="header-title" style="padding: 10px 15px; border-width:1px; border-style:solid; border-color:#FFD28C; background-image: url(<nop>https://jazz.net/wiki/pub/Deployment/WebPreferences/TLASE.jpg); background-size: cover; font-size:120%">
---+!! ETM Read Access Control (RAC) Performance Report
%DKGRAY% Authors: Main.SameerkumarKalaria <br>
Build basis: Engineering Test Management (ETM) 7.2
%ENDCOLOR%<br>
</div></sticky>

<!-- Page contents top of page on right hand side in box -->
<sticky><div style="float:right; border-width:1px; border-style:solid; border-color:#DFDFDF; background-color:#F6F6F6; margin:0 0 15px 15px; padding: 0 15px 0 15px; max-width:320px;">
%TOC{title="Page contents"}%
</div></sticky>

<sticky><div style="margin:15px;"></sticky>
---+ Introduction

*Engineering Test Management (ETM) Read Access Control (RAC)* provides granular visibility control within a single, non-configuration-management (Non-CM) project area by associating read access permissions with Jazz Team Areas. Team members only see the test artifacts assigned to the team areas in which they hold membership (or child team areas thereof), while unauthorized users are prevented from viewing or querying restricted artifacts.

%DKGRAY% *Note:* Read-access control is not supported for project areas that have configuration management (CM) enabled. %ENDCOLOR%

---++ Supported Test Artifacts

Read access control using team areas is supported across the core ETM artifact lifecycle:
   * Test Plan (TP)
   * Test Case (TC)
   * Test Suite (TS)
   * Test Script
   * Test Case Execution Record (TCER)
   * Test Suite Execution Record (TSER)
   * Test Case Result
   * Test Suite Result
   * Test Data
   * Keyword
   * Attachment

Assignment of a team area for the purpose of read access control can be performed on individual test artifacts in their respective editors or in bulk directly from artifact browsing tables.

For additional feature documentation, refer to the [[https://www.ibm.com/docs/en/engineering-lifecycle-management-suite/test-management/7.3.0_beta?topic=areas-read-access-control-by-using-team][IBM Documentation on ETM Read Access Control by Using Team Areas]].

---+++!! Standard Disclaimer

The information in this document is distributed AS IS. The use of this information or the implementation of any of these techniques is a customer responsibility and depends on the customer’s ability to evaluate and integrate them into the customer’s operational environment. While each item may have been reviewed by IBM for accuracy in a specific situation, there is no guarantee that the same or similar results will be obtained elsewhere. Customers attempting to adapt these techniques to their own environments do so at their own risk. Any pointers in this publication to external Web sites are provided for convenience only and do not in any manner serve as an endorsement of these Web sites. Any performance data contained in this document was determined in a controlled environment, and therefore, the results that may be obtained in other operating environments may vary significantly. Users of this document should verify the applicable data for their specific environment.

Performance is based on measurements and projections using standard IBM benchmarks in a controlled environment. The actual throughput or performance that any user will experience will vary depending upon many factors, including considerations such as the amount of multi-programming in the user’s job stream, the I/O configuration, the storage configuration, and the workload processed. Therefore, no assurance can be given that an individual user will achieve results similar to those stated here.

This testing was done as a way to evaluate and characterize the performance, scalability, and resource utilization of ETM Read Access Control under high concurrent user load and large data volumes. The results shown here should be evaluated as comparative performance data and operational guidance rather than an absolute benchmark for all custom deployments.

<br>
---+ Key Findings

Performance and scalability characterization of *ETM Read Access Control (RAC) by using Team Areas* across large enterprise repositories (147M+ artifacts) established the following key conclusions:

   * *High Concurrency Scalability*:
      * With up to *500 team areas*, RAC scales reliably up to *3,000 concurrent users* without encountering a performance degradation inflection point.
      * Under standard workloads (up to 1,500 users), all transactions consistently satisfied the 5.0-second Service Level Agreement (SLA) threshold.

   * *Low Infrastructure Overhead*:
      * The RAC SQL access-filtering logic introduces minimal CPU overhead on the hosting environment. At peak 1,500-user load, CPU utilization remained well below capacity—peaking at *12.4% on the Oracle 19c Database* and *8.7% on the ETM Liberty Application Server*.

   * *Team Area Sizing Boundaries*:
      * Because RAC evaluates team hierarchies dynamically in SQL queries, high team area density per project introduces sizing boundaries:
         * *500 Team Areas*: Recommended up to *3,000 concurrent users*.
         * *1,000 Team Areas*: Recommended up to *1,800 concurrent users* (degradation inflection point at ~2,000 users).
         * *2,000 Team Areas*: Recommended up to *1,000 concurrent users* (elevated latency beyond 1,000 users).

   * *Identified Bottlenecks*:
      * Initial project area dashboard loads invoke =/processAreaHierarchiesWithApplicationContext=, which can take up to ~1 minute once team area counts exceed approximately 1,000 — as this service computes the full project and team area hierarchy on every dashboard load.
      * User permission resolution (=/processAreasForUser=) scales linearly with the number of team areas assigned to an individual user, warranting the practice of least privilege in user team assignments.

<br>
---+ Test Methodology

This section details how the ETM RAC performance characterization and scale tests were conducted, including the repository data shape, environment topology, test scenarios, and workload execution methodology.

---++ Data Shape & Repository Scale

Performance validation was executed against our largest ETM repository containing approximately *147M artifacts* across *2,040 project areas* and *20,200 team areas*.

To stress-test the new RAC SQL filtering paths, hierarchy resolution logic, synthetic benchmark project areas and team area hierarchies were generated in two structured phases using the Java-based ETM Data Generator tool:

   * *Phase 1 — Project & Team Area Hierarchy Generation*:
      * Created ~1,000 non-configuration ETM project areas.
      * Configured hierarchical team structures in each project: 10 top-level team areas, each having 1 sub-team area (20 team areas per project).
      * Assigned users across project and team areas with standard =JazzUsers= and =JazzAdmin= roles.

   * *Phase 2 — High-Volume RAC Project Areas*:
      * Populated high-volume project areas generating ~250K to ~2.3M total artifacts with complex team area assignments.
      * Configured user populations from 500 up to 10,000 assigned users per project area.
      * Generated multiple artifact states and relationship links across Test Plans, Test Cases, Test Suites, Test Scripts, and Execution Records.

<br>
<table border="1" cellpadding="8" cellspacing="0" style="border-collapse:collapse; width:100%; border:1px solid #d0d7de; font-size:13px; margin: 15px 0;">
  <tr style="background-color:#f6f8fa; border-bottom: 2px solid #d0d7de;">
    <th style="padding:10px 16px; text-align:left; width:34%;"><b>Project Area Name</b></th>
    <th style="padding:10px 16px; text-align:left; width:13%;"><b>Type</b></th>
    <th style="padding:10px 16px; text-align:left; width:25%;"><b>Team Area Structure</b></th>
    <th style="padding:10px 16px; text-align:right; width:13%;"><b>User Base</b></th>
    <th style="padding:10px 16px; text-align:right; width:15%;"><b>Generated Artifacts</b></th>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td style="padding:10px 16px; font-family:monospace; font-size:12px; color:#0969da;"><b>ETM_Project_Non-CM_500K_10KUsers_RAC</b></td>
    <td style="padding:10px 16px;">Non-CM (RAC)</td>
    <td style="padding:10px 16px;">20 main teams, 1 sub-team, 1 sub-sub team</td>
    <td style="padding:10px 16px; text-align:right;">10,000 Users</td>
    <td style="padding:10px 16px; text-align:right;"><b>~2.3M Artifacts</b></td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td style="padding:10px 16px; font-family:monospace; font-size:12px; color:#0969da;"><b>ETM_Project_Non-CM_500K_RAC</b></td>
    <td style="padding:10px 16px;">Non-CM (RAC)</td>
    <td style="padding:10px 16px;">10 main teams, 1 sub-team</td>
    <td style="padding:10px 16px; text-align:right;">500 Users</td>
    <td style="padding:10px 16px; text-align:right;"><b>~2.3M Artifacts</b></td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td style="padding:10px 16px; font-family:monospace; font-size:12px; color:#0969da;"><b>ETM_Project_Non-CM_50K_RAC</b></td>
    <td style="padding:10px 16px;">Non-CM (RAC)</td>
    <td style="padding:10px 16px;">10 main teams, 1 sub-team</td>
    <td style="padding:10px 16px; text-align:right;">500 Users</td>
    <td style="padding:10px 16px; text-align:right;"><b>~250K Artifacts</b></td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td style="padding:10px 16px; font-family:monospace; font-size:12px; color:#6f42c1;"><b>ETM_Project_CM_500K_10KUsers_RAC</b></td>
    <td style="padding:10px 16px;">CM-Aware</td>
    <td style="padding:10px 16px;">20 main teams, 1 sub-team, 1 sub-sub team</td>
    <td style="padding:10px 16px; text-align:right;">10,000 Users</td>
    <td style="padding:10px 16px; text-align:right;"><b>~2.3M Artifacts</b></td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td style="padding:10px 16px; font-family:monospace; font-size:12px; color:#6f42c1;"><b>ETM_Project_CM_500K_RAC</b></td>
    <td style="padding:10px 16px;">CM-Aware</td>
    <td style="padding:10px 16px;">10 main teams, 1 sub-team</td>
    <td style="padding:10px 16px; text-align:right;">500 Users</td>
    <td style="padding:10px 16px; text-align:right;"><b>~2.3M Artifacts</b></td>
  </tr>
  <tr style="background-color:#f9fafb;">
    <td style="padding:10px 16px; font-family:monospace; font-size:12px; color:#6f42c1;"><b>ETM_Project_CM_50K_RAC</b></td>
    <td style="padding:10px 16px;">CM-Aware</td>
    <td style="padding:10px 16px;">10 main teams, 1 sub-team</td>
    <td style="padding:10px 16px; text-align:right;">500 Users</td>
    <td style="padding:10px 16px; text-align:right;"><b>~250K Artifacts</b></td>
  </tr>
</table>

<br>
The following screenshot illustrates the team area hierarchy configuration established in the test project areas:

<img src="%ATTACHURLPATH%/ETMProject_TeamAreaHierarchy.png" alt="ETMProject_TeamAreaHierarchy.png" width="700" />

---++ Workload & Test Scenarios

The performance workload was designed to simulate realistic end-user navigation patterns, browsing actions, and complex filtering operations across RAC-enabled repositories. The core scenario suite included:

   1. *Authentication & Dashboard Navigation*:
      * =RQM_Login=: User authentication and initial session handshake.
      * =RQM_Dashboard=: Initial project dashboard rendering and widget data retrieval.
   2. *Test Plan & Artifact Browsing*:
      * =QM_Browse_TestPlans=: Loading the paginated Test Plan table.
      * =QM_Open_Random_TestPlan=: Opening a full Test Plan editor.
      * =QM_Open_TP_TC_View=: Browsing Test Cases associated with a selected Test Plan.
      * =QM_Open_TP_TS_View=: Browsing Test Suites associated with a selected Test Plan.
      * =QM_Open_TP_TCER_View=: Browsing Test Case Execution Records (TCERs) associated with a selected Test Plan.
      * =QM_Open_TCs_List_View=: Browsing the main Test Cases table view.
      * =QM_Open_TCERs_List_View=: Browsing the main Test Case Execution Records (TCERs) table view.
   3. *Direct Artifact Opening*:
      * =QM_Open_Random_TestCase=, =QM_Open_Random_TestSuite=, =QM_Open_Random_TCER=.
   4. *TCER Filter Operations*:
      * Iterations
      * Last Result Passed
      * Last Result Failed
      * Blocked / Error
      * Owners
      * Owners + Weights
      * Owners Exclude Iterations
      * Test Environment + Owners
   5. *Test Case Filter Operations*:
      * Categories
      * Categories Excluding
      * Categories (Some Unassigned)
      * Draft Status
      * Created By
      * Owners
      * Categories + Test Plan Script Steps
      * Categories + Test Suites + Test Scripts
      * Categories + Weight

---++ Load Testing Methodology

Multi-user workload simulation was executed using *Rational Performance Tester (RPT)*:
   * Multi-user load schedules were built to execute mixed-scenario workloads with realistic pacing and think time.
   * Multi-tier scale runs were conducted from *10 concurrent users up to 1,500 concurrent users* (with dedicated scaling capacity evaluations up to *3,000 users*).
   * Workloads were executed side-by-side against both *Non-CM (RAC)* and *CM-Aware* project areas under identical hardware and database configurations to isolate and quantify the RAC access-filtering overhead.

The following screenshot shows the RPT test schedule structure:

<img src="%ATTACHURLPATH%/ETM_RAC_RPT_Schedule.png" alt="ETM_RAC_RPT_Schedule.png" width="700" />

---++ Monitoring Tools

Comprehensive monitoring was active throughout all benchmark windows:
   * *NMON (Nigel's Monitor)*: Continuous recording of CPU, memory utilization, disk I/O, and network throughput across all physical nodes.
   * *Oracle AWR (Automatic Workload Repository)*: Profiling database execution time, RAC Common Table Expression (CTE) query overhead, buffer cache hits, and SQL execution plans.
   * *Java Diagnostics*: Thread dumps, javacores, and queryStats instrumentation to detect internal lock contention or JVM memory pressure.
   * *RPT Report*: Aggregating transaction throughput, response times, and error rates.

<br>
---+ Test Environment Details

The performance tests were conducted on an enterprise four-server topology deployed on bare-metal physical servers.

<table border="1" cellpadding="8" cellspacing="0" style="border-collapse:collapse; width:100%; border:1px solid #d0d7de; font-size:13px; margin: 15px 0;">
  <tr style="background-color:#f6f8fa; border-bottom: 2px solid #d0d7de;">
    <th style="padding:10px 14px; text-align:left; width:18%;"><b>Server Role</b></th>
    <th style="padding:10px 14px; text-align:left; width:22%;"><b>Hostname / Endpoint</b></th>
    <th style="padding:10px 14px; text-align:left; width:12%;"><b>Operating System</b></th>
    <th style="padding:10px 14px; text-align:left; width:24%;"><b>Application / Stack</b></th>
    <th style="padding:10px 14px; text-align:right; width:10%;"><b>vCPUs</b></th>
    <th style="padding:10px 14px; text-align:right; width:14%;"><b>RAM</b></th>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td style="padding:9px 14px;"><b>Web / Reverse Proxy</b></td>
    <td style="padding:9px 14px; font-family:monospace; font-size:12px; color:#0969da;">RTPCLMPERF42 (perfqm.ibm.com)</td>
    <td style="padding:9px 14px;">Red Hat Enterprise Linux (RHEL) 7.9</td>
    <td style="padding:9px 14px;">IBM HTTP Server (IHS)</td>
    <td style="padding:9px 14px; text-align:right;">8</td>
    <td style="padding:9px 14px; text-align:right;">16 GB</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td style="padding:9px 14px;"><b>JTS Server</b></td>
    <td style="padding:9px 14px; font-family:monospace; font-size:12px; color:#0969da;">RTPCLMPERF36</td>
    <td style="padding:9px 14px;">RHEL 7.9</td>
    <td style="padding:9px 14px;">Jazz Team Server (JTS) (Liberty)</td>
    <td style="padding:9px 14px; text-align:right;">24</td>
    <td style="padding:9px 14px; text-align:right;">32 GB</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td style="padding:9px 14px;"><b>ETM Application</b></td>
    <td style="padding:9px 14px; font-family:monospace; font-size:12px; color:#0969da;">RTPCLMPERF28</td>
    <td style="padding:9px 14px;">RHEL 8.x</td>
    <td style="padding:9px 14px;">ETM Server (Liberty)</td>
    <td style="padding:9px 14px; text-align:right;">24</td>
    <td style="padding:9px 14px; text-align:right;">64 GB</td>
  </tr>
  <tr style="background-color:#f9fafb;">
    <td style="padding:9px 14px;"><b>Database Server</b></td>
    <td style="padding:9px 14px; font-family:monospace; font-size:12px; color:#0969da;">RTPCLMPERF73</td>
    <td style="padding:9px 14px;">RHEL 7.9</td>
    <td style="padding:9px 14px;">Oracle Database 19c Enterprise</td>
    <td style="padding:9px 14px; text-align:right;">40</td>
    <td style="padding:9px 14px; text-align:right;">64 GB</td>
  </tr>
</table>

<br>
---+ Performance Test Results

This section presents the performance test findings, capacity thresholds, comparative metrics between Non-CM (RAC) and CM-Aware project areas, and server resource utilization under load up to 1,500 concurrent users.

---++ Summary of Load Test Results

   * *Stable Scalability to 1,500 Users*: ETM Non-CM project areas with Read Access Control enabled scale reliably up to 1,500 concurrent users with *zero response time threshold breaches* (> 5.0 seconds SLA).
   * *Minimal Server Resource Overhead*: Server CPU utilization remained exceptionally low on both tiers at 1,500 concurrent users—peaking at *12.4% on the Oracle Database server* and *8.7% on the ETM Application server*.
   * *Fast Navigation & TCER Filtering in Non-CM*: Browsing Test Plans (~236 ms), opening TCER views (~328 ms), and executing TCER filters (285–307 ms) demonstrated sub-second response times across all load levels.
   * *Predictable Scaling Profile*: Response times for navigation, dashboards, and filtering remained flat from 100U to 1,500U, demonstrating strong query execution stability.

---++ Load Testing with Varying Team Area Counts (Capacity Limits)

To establish operational sizing guidelines, dedicated load testing was conducted with varying numbers of team areas (*500, 1,000, and 2,000 team areas*) under increasing concurrent user counts. Because RAC SQL filters evaluate team hierarchy paths and memberships during query execution, team area density directly influences database query planning and memory structures.

The testing revealed clear scaling thresholds across the evaluated team area topologies:

---+++ 1. 500 Team Areas

   * *Tested Load Range*: Scaled up to *3,000 concurrent users*.
   * *Behavior*: Response times scaled predictably across the entire load spectrum without encountering a performance degradation inflection point.
   * *Compliance*: All transaction response times consistently satisfied operational SLA criteria.
   * *Recommended Operational Limit*: Up to *3,000 concurrent users*.

<img src="%ATTACHURLPATH%/ResponseTimeVsUsers_500TeamAreas.png" alt="ResponseTimeVsUsers_500TeamAreas.png" width="950" style="max-width:100%; height:auto; border: 1px solid #e1e4e8; border-radius: 4px; margin: 10px 0;" />

<br>
---+++ 2. 1,000 Team Areas

   * *Stable Load Range (100 to 1,600 Users)*: Performance remained completely stable across all transactions, well within acceptable SLA limits.
   * *Degradation Threshold (1,600 to 2,000 Users)*: Starting around 1,800 concurrent users, response times began experiencing exponential growth due to cumulative database CTE resolution overhead and lock queues under high team area density.
   * *Recommended Operational Limit*: Up to *1,800 concurrent users*.

<br>
%DKGRAY% *Chart 1: Response Time vs Users (100 to 1,600 Users — Stable Performance)* %ENDCOLOR%
<img src="%ATTACHURLPATH%/ResponseTimeVsUsers_1000TeamAreas_Chart1.png" alt="ResponseTimeVsUsers_1000TeamAreas_Chart1.png" width="950" style="max-width:100%; height:auto; border: 1px solid #e1e4e8; border-radius: 4px; margin: 10px 0;" />

<br>
%DKGRAY% *Chart 2: Response Time vs Users (1,600 to 2,000 Users — Degradation from 1,800U)* %ENDCOLOR%
<img src="%ATTACHURLPATH%/ResponseTimeVsUsers_1000TeamAreas_Chart2.png" alt="ResponseTimeVsUsers_1000TeamAreas_Chart2.png" width="950" style="max-width:100%; height:auto; border: 1px solid #e1e4e8; border-radius: 4px; margin: 10px 0;" />

<br>
---+++ 3. 2,000 Team Areas

   * *Stable Load Range (100 to 1,000 Users)*: Response times remained predictable and within acceptable operational thresholds up to 1,000 concurrent users.
   * *Degradation Threshold (1,000 to 1,400 Users)*: Exponential performance degradation and elevated query latency were observed immediately past 1,000 users as massive team area volume magnified the cost of hierarchy evaluation under concurrent load.
   * *Recommended Operational Limit*: Up to *1,000 concurrent users*.

<br>
%DKGRAY% *Chart 1: Response Time vs Users (100 to 1,000 Users — Stable Performance)* %ENDCOLOR%
<img src="%ATTACHURLPATH%/ResponseTimeVsUsers_2000TeamAreas_Chart1.png" alt="ResponseTimeVsUsers_2000TeamAreas_Chart1.png" width="950" style="max-width:100%; height:auto; border: 1px solid #e1e4e8; border-radius: 4px; margin: 10px 0;" />

<br>
%DKGRAY% *Chart 2: Response Time vs Users (1,000 to 1,400 Users — Degradation beyond 1,000U)* %ENDCOLOR%
<img src="%ATTACHURLPATH%/ResponseTimeVsUsers_2000TeamAreas_Chart2.png" alt="ResponseTimeVsUsers_2000TeamAreas_Chart2.png" width="950" style="max-width:100%; height:auto; border: 1px solid #e1e4e8; border-radius: 4px; margin: 10px 0;" />

<br>
---+++ 4. Summary of Sizing Guidelines by Team Area Scale

<table border="1" cellpadding="8" cellspacing="0" style="border-collapse:collapse; width:100%; border:1px solid #d0d7de; font-size:13px; margin: 15px 0;">
  <tr style="background-color:#f6f8fa; border-bottom: 2px solid #d0d7de;">
    <th style="padding:10px 16px; text-align:left; width:22%;"><b>Team Area Count</b></th>
    <th style="padding:10px 16px; text-align:left; width:26%;"><b>Recommended User Limit</b></th>
    <th style="padding:10px 16px; text-align:left; width:28%;"><b>Observed Degradation Point</b></th>
    <th style="padding:10px 16px; text-align:center; width:24%;"><b>Status / Sizing</b></th>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td style="padding:10px 16px; text-align:left;"><b>500 Team Areas</b></td>
    <td style="padding:10px 16px; text-align:left;">Up to 3,000 Users</td>
    <td style="padding:10px 16px; text-align:left;">No performance degradation inflection point observed up to 3,000 Users</td>
    <td style="padding:10px 16px; text-align:center;"><span style="color:#065f46; font-weight:bold; background:#d1fae5; padding:4px 12px; border-radius:12px; font-size:11.5px; white-space:nowrap;">Excellent Scalability</span></td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td style="padding:10px 16px; text-align:left;"><b>1,000 Team Areas</b></td>
    <td style="padding:10px 16px; text-align:left;">Up to 1,800 Users</td>
    <td style="padding:10px 16px; text-align:left;">~1,800 to 2,000 Users</td>
    <td style="padding:10px 16px; text-align:center;"><span style="color:#065f46; font-weight:bold; background:#d1fae5; padding:4px 12px; border-radius:12px; font-size:11.5px; white-space:nowrap;">Stable for Large Scale</span></td>
  </tr>
  <tr style="background-color:#ffffff;">
    <td style="padding:10px 16px; text-align:left;"><b>2,000 Team Areas</b></td>
    <td style="padding:10px 16px; text-align:left;">Up to 1,000 Users</td>
    <td style="padding:10px 16px; text-align:left;">~1,000 Users</td>
    <td style="padding:10px 16px; text-align:center;"><span style="color:#9a3412; font-weight:bold; background:#ffedd5; padding:4px 12px; border-radius:12px; font-size:11.5px; white-space:nowrap;">Plan Sizing Carefully</span></td>
  </tr>
</table>

<br>
---++ Server CPU Utilization

Resource monitoring confirmed that neither the ETM application server nor the Oracle database server experienced CPU exhaustion during the 1,500 user scale test. Both Non-CM (RAC) and CM-Aware workloads exhibited similar, moderate CPU growth profiles.

<table border="1" cellpadding="8" cellspacing="0" style="border-collapse:collapse; width:95%; border:1px solid #d0d7de; font-size:13px; margin: 15px 0;">
  <tr style="background-color:#f6f8fa; border-bottom: 2px solid #d0d7de;">
    <th style="padding:10px 14px; text-align:left; width:30%;"><b>Project Area Mode & Node</b></th>
    <th style="padding:10px 10px; text-align:right; width:10%;"><b>10U</b></th>
    <th style="padding:10px 10px; text-align:right; width:10%;"><b>100U</b></th>
    <th style="padding:10px 10px; text-align:right; width:10%;"><b>250U</b></th>
    <th style="padding:10px 10px; text-align:right; width:10%;"><b>500U</b></th>
    <th style="padding:10px 10px; text-align:right; width:10%;"><b>750U</b></th>
    <th style="padding:10px 10px; text-align:right; width:10%;"><b>1000U</b></th>
    <th style="padding:10px 10px; text-align:right; width:10%;"><b>1500U</b></th>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td style="padding:9px 14px;"><span style="background:#dbeafe; color:#1e40af; font-size:10px; font-weight:bold; padding:2px 7px; border-radius:10px; margin-right:6px;">Non-CM</span> <b>Oracle DB Server</b></td>
    <td style="padding:9px 10px; text-align:right;">1.9%</td>
    <td style="padding:9px 10px; text-align:right;">2.6%</td>
    <td style="padding:9px 10px; text-align:right;">4.5%</td>
    <td style="padding:9px 10px; text-align:right;">6.0%</td>
    <td style="padding:9px 10px; text-align:right;">8.0%</td>
    <td style="padding:9px 10px; text-align:right;">9.5%</td>
    <td style="padding:9px 10px; text-align:right; font-weight:bold; color:#065f46; background:#ecfdf5;">12.4%</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td style="padding:9px 14px;"><span style="background:#dbeafe; color:#1e40af; font-size:10px; font-weight:bold; padding:2px 7px; border-radius:10px; margin-right:6px;">Non-CM</span> <b>ETM App Server</b></td>
    <td style="padding:9px 10px; text-align:right;">1.4%</td>
    <td style="padding:9px 10px; text-align:right;">1.7%</td>
    <td style="padding:9px 10px; text-align:right;">2.0%</td>
    <td style="padding:9px 10px; text-align:right;">3.0%</td>
    <td style="padding:9px 10px; text-align:right;">4.8%</td>
    <td style="padding:9px 10px; text-align:right;">6.1%</td>
    <td style="padding:9px 10px; text-align:right; font-weight:bold; color:#065f46; background:#ecfdf5;">8.7%</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td style="padding:9px 14px;"><span style="background:#fce7f3; color:#9d174d; font-size:10px; font-weight:bold; padding:2px 7px; border-radius:10px; margin-right:6px;">CM</span> <b>Oracle DB Server</b></td>
    <td style="padding:9px 10px; text-align:right;">1.9%</td>
    <td style="padding:9px 10px; text-align:right;">2.6%</td>
    <td style="padding:9px 10px; text-align:right;">4.3%</td>
    <td style="padding:9px 10px; text-align:right;">6.0%</td>
    <td style="padding:9px 10px; text-align:right;">7.6%</td>
    <td style="padding:9px 10px; text-align:right;">9.2%</td>
    <td style="padding:9px 10px; text-align:right; font-weight:bold; color:#065f46; background:#ecfdf5;">12.5%</td>
  </tr>
  <tr style="background-color:#f9fafb;">
    <td style="padding:9px 14px;"><span style="background:#fce7f3; color:#9d174d; font-size:10px; font-weight:bold; padding:2px 7px; border-radius:10px; margin-right:6px;">CM</span> <b>ETM App Server</b></td>
    <td style="padding:9px 10px; text-align:right;">1.4%</td>
    <td style="padding:9px 10px; text-align:right;">1.7%</td>
    <td style="padding:9px 10px; text-align:right;">1.6%</td>
    <td style="padding:9px 10px; text-align:right;">2.5%</td>
    <td style="padding:9px 10px; text-align:right;">3.4%</td>
    <td style="padding:9px 10px; text-align:right;">4.4%</td>
    <td style="padding:9px 10px; text-align:right; font-weight:bold; color:#065f46; background:#ecfdf5;">6.1%</td>
  </tr>
</table>

<br>
The charts below show the CPU utilization curves on the ETM Application Server and Database Server as user load scaled from 10 to 1,500 concurrent users:

<img src="%ATTACHURLPATH%/CPU_Usages_ETMServer.png" alt="CPU_Usages_ETMServer.png" width="650" />
<br><br>
<img src="%ATTACHURLPATH%/CPU_Usages_DatabaseServer.png" alt="CPU_Usages_DatabaseServer.png" width="650" />

---++ Detailed Response Time Analysis: Non-CM (RAC) vs CM-Aware

The multi-user benchmark measured 31 distinct user transactions and queries across both project area modes.

---+++ 1. Navigation & View Operations

<div style="max-height: 480px; overflow-y: auto; overflow-x: auto; border: 1px solid #d0d7de; border-radius: 4px; margin: 15px 0;">
<table border="0" cellpadding="8" cellspacing="0" style="border-collapse:separate; border-spacing:0; width:100%; font-size:12.5px; margin:0;">
  <tr style="background-color:#f6f8fa;">
    <th style="position:sticky; top:0; background-color:#f6f8fa; z-index:2; border-bottom:2px solid #d0d7de; padding:10px 14px; text-align:left; width:26%;"><b>Transaction / Scenario</b></th>
    <th style="position:sticky; top:0; background-color:#f6f8fa; z-index:2; border-bottom:2px solid #d0d7de; padding:10px 8px; text-align:center; width:12%;"><b>Mode</b></th>
    <th style="position:sticky; top:0; background-color:#f6f8fa; z-index:2; border-bottom:2px solid #d0d7de; padding:8px 10px; text-align:right; width:10%;"><b>10U<br>(ms)</b></th>
    <th style="position:sticky; top:0; background-color:#f6f8fa; z-index:2; border-bottom:2px solid #d0d7de; padding:8px 10px; text-align:right; width:10%;"><b>100U<br>(ms)</b></th>
    <th style="position:sticky; top:0; background-color:#f6f8fa; z-index:2; border-bottom:2px solid #d0d7de; padding:8px 10px; text-align:right; width:10%;"><b>250U<br>(ms)</b></th>
    <th style="position:sticky; top:0; background-color:#f6f8fa; z-index:2; border-bottom:2px solid #d0d7de; padding:8px 10px; text-align:right; width:10%;"><b>500U<br>(ms)</b></th>
    <th style="position:sticky; top:0; background-color:#f6f8fa; z-index:2; border-bottom:2px solid #d0d7de; padding:8px 10px; text-align:right; width:11%;"><b>1000U<br>(ms)</b></th>
    <th style="position:sticky; top:0; background-color:#f6f8fa; z-index:2; border-bottom:2px solid #d0d7de; padding:8px 10px; text-align:right; width:11%;"><b>1500U<br>(ms)</b></th>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td rowspan="2" style="padding:8px 14px; font-family:monospace; font-size:12px; vertical-align:middle;"><b>RQM_Login</b></td>
    <td style="padding:6px 8px; text-align:center;"><span style="background:#dbeafe; color:#1e40af; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">Non-CM</span></td>
    <td style="padding:6px 10px; text-align:right;">98.6</td>
    <td style="padding:6px 10px; text-align:right;">52.7</td>
    <td style="padding:6px 10px; text-align:right;">42.3</td>
    <td style="padding:6px 10px; text-align:right;">45.7</td>
    <td style="padding:6px 10px; text-align:right;">41.1</td>
    <td style="padding:6px 10px; text-align:right;">45.8</td>
  </tr>
  <tr style="border-bottom:2px solid #d0d7de; background-color:#ffffff;">
    <td style="padding:6px 8px; text-align:center;"><span style="background:#fce7f3; color:#9d174d; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">CM</span></td>
    <td style="padding:6px 10px; text-align:right;">104.2</td>
    <td style="padding:6px 10px; text-align:right;">50.8</td>
    <td style="padding:6px 10px; text-align:right;">42.0</td>
    <td style="padding:6px 10px; text-align:right;">42.0</td>
    <td style="padding:6px 10px; text-align:right;">42.0</td>
    <td style="padding:6px 10px; text-align:right;">43.7</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td rowspan="2" style="padding:8px 14px; font-family:monospace; font-size:12px; vertical-align:middle;"><b>RQM_Dashboard</b></td>
    <td style="padding:6px 8px; text-align:center;"><span style="background:#dbeafe; color:#1e40af; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">Non-CM</span></td>
    <td style="padding:6px 10px; text-align:right;">2,243.7</td>
    <td style="padding:6px 10px; text-align:right;">2,240.1</td>
    <td style="padding:6px 10px; text-align:right;">2,029.0</td>
    <td style="padding:6px 10px; text-align:right;">2,062.6</td>
    <td style="padding:6px 10px; text-align:right;">2,032.7</td>
    <td style="padding:6px 10px; text-align:right;">2,073.1</td>
  </tr>
  <tr style="border-bottom:2px solid #d0d7de; background-color:#f9fafb;">
    <td style="padding:6px 8px; text-align:center;"><span style="background:#fce7f3; color:#9d174d; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">CM</span></td>
    <td style="padding:6px 10px; text-align:right;">2,027.2</td>
    <td style="padding:6px 10px; text-align:right;">2,063.6</td>
    <td style="padding:6px 10px; text-align:right;">2,031.0</td>
    <td style="padding:6px 10px; text-align:right;">1,960.1</td>
    <td style="padding:6px 10px; text-align:right;">1,967.2</td>
    <td style="padding:6px 10px; text-align:right;">2,028.8</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td rowspan="2" style="padding:8px 14px; font-family:monospace; font-size:12px; vertical-align:middle;"><b>QM_Browse_TestPlans</b></td>
    <td style="padding:6px 8px; text-align:center;"><span style="background:#dbeafe; color:#1e40af; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">Non-CM</span></td>
    <td style="padding:6px 10px; text-align:right;">303.8</td>
    <td style="padding:6px 10px; text-align:right;">235.7</td>
    <td style="padding:6px 10px; text-align:right;">237.3</td>
    <td style="padding:6px 10px; text-align:right;">229.7</td>
    <td style="padding:6px 10px; text-align:right;">227.9</td>
    <td style="padding:6px 10px; text-align:right;">236.2</td>
  </tr>
  <tr style="border-bottom:2px solid #d0d7de; background-color:#ffffff;">
    <td style="padding:6px 8px; text-align:center;"><span style="background:#fce7f3; color:#9d174d; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">CM</span></td>
    <td style="padding:6px 10px; text-align:right;">114.5</td>
    <td style="padding:6px 10px; text-align:right;">124.5</td>
    <td style="padding:6px 10px; text-align:right;">105.8</td>
    <td style="padding:6px 10px; text-align:right;">99.9</td>
    <td style="padding:6px 10px; text-align:right;">94.6</td>
    <td style="padding:6px 10px; text-align:right;">100.4</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td rowspan="2" style="padding:8px 14px; font-family:monospace; font-size:12px; vertical-align:middle;"><b>QM_Open_Random_TestPlan</b></td>
    <td style="padding:6px 8px; text-align:center;"><span style="background:#dbeafe; color:#1e40af; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">Non-CM</span></td>
    <td style="padding:6px 10px; text-align:right;">532.8</td>
    <td style="padding:6px 10px; text-align:right;">466.0</td>
    <td style="padding:6px 10px; text-align:right;">467.6</td>
    <td style="padding:6px 10px; text-align:right;">496.5</td>
    <td style="padding:6px 10px; text-align:right;">482.1</td>
    <td style="padding:6px 10px; text-align:right;">495.5</td>
  </tr>
  <tr style="border-bottom:2px solid #d0d7de; background-color:#f9fafb;">
    <td style="padding:6px 8px; text-align:center;"><span style="background:#fce7f3; color:#9d174d; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">CM</span></td>
    <td style="padding:6px 10px; text-align:right;">590.6</td>
    <td style="padding:6px 10px; text-align:right;">614.9</td>
    <td style="padding:6px 10px; text-align:right;">609.5</td>
    <td style="padding:6px 10px; text-align:right;">599.7</td>
    <td style="padding:6px 10px; text-align:right;">599.1</td>
    <td style="padding:6px 10px; text-align:right;">619.8</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td rowspan="2" style="padding:8px 14px; font-family:monospace; font-size:12px; vertical-align:middle;"><b>QM_Open_Random_TestCase</b></td>
    <td style="padding:6px 8px; text-align:center;"><span style="background:#dbeafe; color:#1e40af; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">Non-CM</span></td>
    <td style="padding:6px 10px; text-align:right;">467.3</td>
    <td style="padding:6px 10px; text-align:right;">531.2</td>
    <td style="padding:6px 10px; text-align:right;">506.6</td>
    <td style="padding:6px 10px; text-align:right;">480.8</td>
    <td style="padding:6px 10px; text-align:right;">482.1</td>
    <td style="padding:6px 10px; text-align:right;">489.1</td>
  </tr>
  <tr style="border-bottom:2px solid #d0d7de; background-color:#ffffff;">
    <td style="padding:6px 8px; text-align:center;"><span style="background:#fce7f3; color:#9d174d; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">CM</span></td>
    <td style="padding:6px 10px; text-align:right;">308.0</td>
    <td style="padding:6px 10px; text-align:right;">493.6</td>
    <td style="padding:6px 10px; text-align:right;">310.2</td>
    <td style="padding:6px 10px; text-align:right;">283.2</td>
    <td style="padding:6px 10px; text-align:right;">257.5</td>
    <td style="padding:6px 10px; text-align:right;">263.0</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td rowspan="2" style="padding:8px 14px; font-family:monospace; font-size:12px; vertical-align:middle;"><b>QM_Open_Random_TestSuite</b></td>
    <td style="padding:6px 8px; text-align:center;"><span style="background:#dbeafe; color:#1e40af; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">Non-CM</span></td>
    <td style="padding:6px 10px; text-align:right;">409.5</td>
    <td style="padding:6px 10px; text-align:right;">495.4</td>
    <td style="padding:6px 10px; text-align:right;">438.8</td>
    <td style="padding:6px 10px; text-align:right;">411.5</td>
    <td style="padding:6px 10px; text-align:right;">405.9</td>
    <td style="padding:6px 10px; text-align:right;">417.9</td>
  </tr>
  <tr style="border-bottom:2px solid #d0d7de; background-color:#f9fafb;">
    <td style="padding:6px 8px; text-align:center;"><span style="background:#fce7f3; color:#9d174d; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">CM</span></td>
    <td style="padding:6px 10px; text-align:right;">188.5</td>
    <td style="padding:6px 10px; text-align:right;">218.6</td>
    <td style="padding:6px 10px; text-align:right;">209.0</td>
    <td style="padding:6px 10px; text-align:right;">195.7</td>
    <td style="padding:6px 10px; text-align:right;">190.3</td>
    <td style="padding:6px 10px; text-align:right;">201.1</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td rowspan="2" style="padding:8px 14px; font-family:monospace; font-size:12px; vertical-align:middle;"><b>QM_Open_Random_TCER</b></td>
    <td style="padding:6px 8px; text-align:center;"><span style="background:#dbeafe; color:#1e40af; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">Non-CM</span></td>
    <td style="padding:6px 10px; text-align:right;">688.8</td>
    <td style="padding:6px 10px; text-align:right;">498.9</td>
    <td style="padding:6px 10px; text-align:right;">562.0</td>
    <td style="padding:6px 10px; text-align:right;">530.8</td>
    <td style="padding:6px 10px; text-align:right;">464.8</td>
    <td style="padding:6px 10px; text-align:right;">514.7</td>
  </tr>
  <tr style="border-bottom:2px solid #d0d7de; background-color:#ffffff;">
    <td style="padding:6px 8px; text-align:center;"><span style="background:#fce7f3; color:#9d174d; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">CM</span></td>
    <td style="padding:6px 10px; text-align:right;">419.8</td>
    <td style="padding:6px 10px; text-align:right;">605.2</td>
    <td style="padding:6px 10px; text-align:right;">380.7</td>
    <td style="padding:6px 10px; text-align:right;">390.1</td>
    <td style="padding:6px 10px; text-align:right;">374.9</td>
    <td style="padding:6px 10px; text-align:right;">349.1</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td rowspan="2" style="padding:8px 14px; font-family:monospace; font-size:12px; vertical-align:middle;"><b>QM_Open_TCERs_List_View</b></td>
    <td style="padding:6px 8px; text-align:center;"><span style="background:#dbeafe; color:#1e40af; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">Non-CM</span></td>
    <td style="padding:6px 10px; text-align:right; font-weight:bold; color:#065f46;">355.5</td>
    <td style="padding:6px 10px; text-align:right; font-weight:bold; color:#065f46;">306.5</td>
    <td style="padding:6px 10px; text-align:right; font-weight:bold; color:#065f46;">305.5</td>
    <td style="padding:6px 10px; text-align:right; font-weight:bold; color:#065f46;">313.9</td>
    <td style="padding:6px 10px; text-align:right; font-weight:bold; color:#065f46;">320.6</td>
    <td style="padding:6px 10px; text-align:right; font-weight:bold; color:#065f46;">328.5</td>
  </tr>
  <tr style="border-bottom:2px solid #d0d7de; background-color:#f9fafb;">
    <td style="padding:6px 8px; text-align:center;"><span style="background:#fce7f3; color:#9d174d; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">CM</span></td>
    <td style="padding:6px 10px; text-align:right;">1,858.9</td>
    <td style="padding:6px 10px; text-align:right;">1,873.1</td>
    <td style="padding:6px 10px; text-align:right;">1,905.8</td>
    <td style="padding:6px 10px; text-align:right;">1,928.7</td>
    <td style="padding:6px 10px; text-align:right;">1,950.8</td>
    <td style="padding:6px 10px; text-align:right;">1,981.7</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td rowspan="2" style="padding:8px 14px; font-family:monospace; font-size:12px; vertical-align:middle;"><b>QM_Open_TCs_List_View</b></td>
    <td style="padding:6px 8px; text-align:center;"><span style="background:#dbeafe; color:#1e40af; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">Non-CM</span></td>
    <td style="padding:6px 10px; text-align:right;">1,319.4</td>
    <td style="padding:6px 10px; text-align:right;">1,151.2</td>
    <td style="padding:6px 10px; text-align:right;">1,140.6</td>
    <td style="padding:6px 10px; text-align:right;">1,168.1</td>
    <td style="padding:6px 10px; text-align:right;">1,177.7</td>
    <td style="padding:6px 10px; text-align:right;">1,191.1</td>
  </tr>
  <tr style="border-bottom:2px solid #d0d7de; background-color:#ffffff;">
    <td style="padding:6px 8px; text-align:center;"><span style="background:#fce7f3; color:#9d174d; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">CM</span></td>
    <td style="padding:6px 10px; text-align:right;">212.5</td>
    <td style="padding:6px 10px; text-align:right;">229.3</td>
    <td style="padding:6px 10px; text-align:right;">196.0</td>
    <td style="padding:6px 10px; text-align:right;">194.1</td>
    <td style="padding:6px 10px; text-align:right;">189.4</td>
    <td style="padding:6px 10px; text-align:right;">198.0</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td rowspan="2" style="padding:8px 14px; font-family:monospace; font-size:12px; vertical-align:middle;"><b>QM_Open_TP_TC_View</b></td>
    <td style="padding:6px 8px; text-align:center;"><span style="background:#dbeafe; color:#1e40af; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">Non-CM</span></td>
    <td style="padding:6px 10px; text-align:right;">1,439.7</td>
    <td style="padding:6px 10px; text-align:right;">1,382.4</td>
    <td style="padding:6px 10px; text-align:right;">1,386.7</td>
    <td style="padding:6px 10px; text-align:right;">1,415.2</td>
    <td style="padding:6px 10px; text-align:right;">1,419.0</td>
    <td style="padding:6px 10px; text-align:right;">1,442.5</td>
  </tr>
  <tr style="border-bottom:2px solid #d0d7de; background-color:#f9fafb;">
    <td style="padding:6px 8px; text-align:center;"><span style="background:#fce7f3; color:#9d174d; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">CM</span></td>
    <td style="padding:6px 10px; text-align:right;">460.6</td>
    <td style="padding:6px 10px; text-align:right;">463.8</td>
    <td style="padding:6px 10px; text-align:right;">479.6</td>
    <td style="padding:6px 10px; text-align:right;">485.6</td>
    <td style="padding:6px 10px; text-align:right;">487.6</td>
    <td style="padding:6px 10px; text-align:right;">499.5</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td rowspan="2" style="padding:8px 14px; font-family:monospace; font-size:12px; vertical-align:middle;"><b>QM_Open_TP_TCER_View</b></td>
    <td style="padding:6px 8px; text-align:center;"><span style="background:#dbeafe; color:#1e40af; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">Non-CM</span></td>
    <td style="padding:6px 10px; text-align:right;">387.8</td>
    <td style="padding:6px 10px; text-align:right;">346.5</td>
    <td style="padding:6px 10px; text-align:right;">350.9</td>
    <td style="padding:6px 10px; text-align:right;">357.6</td>
    <td style="padding:6px 10px; text-align:right;">359.5</td>
    <td style="padding:6px 10px; text-align:right;">368.7</td>
  </tr>
  <tr style="border-bottom:2px solid #d0d7de; background-color:#ffffff;">
    <td style="padding:6px 8px; text-align:center;"><span style="background:#fce7f3; color:#9d174d; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">CM</span></td>
    <td style="padding:6px 10px; text-align:right;">181.5</td>
    <td style="padding:6px 10px; text-align:right;">175.0</td>
    <td style="padding:6px 10px; text-align:right;">174.7</td>
    <td style="padding:6px 10px; text-align:right;">176.3</td>
    <td style="padding:6px 10px; text-align:right;">176.4</td>
    <td style="padding:6px 10px; text-align:right;">178.2</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td rowspan="2" style="padding:8px 14px; font-family:monospace; font-size:12px; vertical-align:middle;"><b>QM_Open_TP_TS_View</b></td>
    <td style="padding:6px 8px; text-align:center;"><span style="background:#dbeafe; color:#1e40af; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">Non-CM</span></td>
    <td style="padding:6px 10px; text-align:right;">1,277.3</td>
    <td style="padding:6px 10px; text-align:right;">1,250.5</td>
    <td style="padding:6px 10px; text-align:right;">1,264.0</td>
    <td style="padding:6px 10px; text-align:right;">1,289.4</td>
    <td style="padding:6px 10px; text-align:right;">1,295.5</td>
    <td style="padding:6px 10px; text-align:right;">1,317.0</td>
  </tr>
  <tr style="border-bottom:2px solid #d0d7de; background-color:#f9fafb;">
    <td style="padding:6px 8px; text-align:center;"><span style="background:#fce7f3; color:#9d174d; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">CM</span></td>
    <td style="padding:6px 10px; text-align:right;">167.3</td>
    <td style="padding:6px 10px; text-align:right;">158.9</td>
    <td style="padding:6px 10px; text-align:right;">161.2</td>
    <td style="padding:6px 10px; text-align:right;">162.4</td>
    <td style="padding:6px 10px; text-align:right;">161.9</td>
    <td style="padding:6px 10px; text-align:right;">165.5</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td rowspan="2" style="padding:8px 14px; font-family:monospace; font-size:12px; vertical-align:middle;"><b>QM_Expand_TCERs_Filter_Section</b></td>
    <td style="padding:6px 8px; text-align:center;"><span style="background:#dbeafe; color:#1e40af; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">Non-CM</span></td>
    <td style="padding:6px 10px; text-align:right;">288.1</td>
    <td style="padding:6px 10px; text-align:right;">268.3</td>
    <td style="padding:6px 10px; text-align:right;">268.0</td>
    <td style="padding:6px 10px; text-align:right;">283.3</td>
    <td style="padding:6px 10px; text-align:right;">281.6</td>
    <td style="padding:6px 10px; text-align:right;">290.4</td>
  </tr>
  <tr style="border-bottom:2px solid #d0d7de; background-color:#ffffff;">
    <td style="padding:6px 8px; text-align:center;"><span style="background:#fce7f3; color:#9d174d; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">CM</span></td>
    <td style="padding:6px 10px; text-align:right;">1,776.4</td>
    <td style="padding:6px 10px; text-align:right;">1,807.0</td>
    <td style="padding:6px 10px; text-align:right;">1,859.6</td>
    <td style="padding:6px 10px; text-align:right;">1,881.3</td>
    <td style="padding:6px 10px; text-align:right;">1,904.3</td>
    <td style="padding:6px 10px; text-align:right;">1,931.0</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td rowspan="2" style="padding:8px 14px; font-family:monospace; font-size:12px; vertical-align:middle;"><b>QM_Expand_TCs_Filter_Section</b></td>
    <td style="padding:6px 8px; text-align:center;"><span style="background:#dbeafe; color:#1e40af; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">Non-CM</span></td>
    <td style="padding:6px 10px; text-align:right;">1,690.8</td>
    <td style="padding:6px 10px; text-align:right;">1,665.3</td>
    <td style="padding:6px 10px; text-align:right;">1,692.2</td>
    <td style="padding:6px 10px; text-align:right;">1,719.7</td>
    <td style="padding:6px 10px; text-align:right;">1,727.6</td>
    <td style="padding:6px 10px; text-align:right;">1,753.2</td>
  </tr>
  <tr style="background-color:#f9fafb;">
    <td style="padding:6px 8px; text-align:center;"><span style="background:#fce7f3; color:#9d174d; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">CM</span></td>
    <td style="padding:6px 10px; text-align:right;">128.5</td>
    <td style="padding:6px 10px; text-align:right;">123.3</td>
    <td style="padding:6px 10px; text-align:right;">110.4</td>
    <td style="padding:6px 10px; text-align:right;">109.0</td>
    <td style="padding:6px 10px; text-align:right;">108.9</td>
    <td style="padding:6px 10px; text-align:right;">112.7</td>
  </tr>
</table>
</div>

---+++ 2. TCER Filter Operations

TCER filtering demonstrated high efficiency under RAC in Non-CM project areas, consistently executing in *280 ms to 380 ms*. In CM-Aware project areas, TCER queries executed in the *1.7 s to 2.0 s* range due to configuration-context resolution overhead across versioned configurations.

<div style="max-height: 480px; overflow-y: auto; overflow-x: auto; border: 1px solid #d0d7de; border-radius: 4px; margin: 15px 0;">
<table border="0" cellpadding="8" cellspacing="0" style="border-collapse:separate; border-spacing:0; width:100%; font-size:12.5px; margin:0;">
  <tr style="background-color:#f6f8fa;">
    <th style="position:sticky; top:0; background-color:#f6f8fa; z-index:2; border-bottom:2px solid #d0d7de; padding:10px 14px; text-align:left; width:28%;"><b>TCER Filter Transaction</b></th>
    <th style="position:sticky; top:0; background-color:#f6f8fa; z-index:2; border-bottom:2px solid #d0d7de; padding:10px 8px; text-align:center; width:12%;"><b>Mode</b></th>
    <th style="position:sticky; top:0; background-color:#f6f8fa; z-index:2; border-bottom:2px solid #d0d7de; padding:8px 10px; text-align:right; width:10%;"><b>10U<br>(ms)</b></th>
    <th style="position:sticky; top:0; background-color:#f6f8fa; z-index:2; border-bottom:2px solid #d0d7de; padding:8px 10px; text-align:right; width:10%;"><b>100U<br>(ms)</b></th>
    <th style="position:sticky; top:0; background-color:#f6f8fa; z-index:2; border-bottom:2px solid #d0d7de; padding:8px 10px; text-align:right; width:10%;"><b>250U<br>(ms)</b></th>
    <th style="position:sticky; top:0; background-color:#f6f8fa; z-index:2; border-bottom:2px solid #d0d7de; padding:8px 10px; text-align:right; width:10%;"><b>500U<br>(ms)</b></th>
    <th style="position:sticky; top:0; background-color:#f6f8fa; z-index:2; border-bottom:2px solid #d0d7de; padding:8px 10px; text-align:right; width:10%;"><b>1000U<br>(ms)</b></th>
    <th style="position:sticky; top:0; background-color:#f6f8fa; z-index:2; border-bottom:2px solid #d0d7de; padding:8px 10px; text-align:right; width:10%;"><b>1500U<br>(ms)</b></th>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td rowspan="2" style="padding:8px 14px; vertical-align:middle;"><b>Iterations</b></td>
    <td style="padding:6px 8px; text-align:center;"><span style="background:#dbeafe; color:#1e40af; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">Non-CM</span></td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">378.0</td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">293.8</td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">285.2</td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">292.3</td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">291.1</td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">297.5</td>
  </tr>
  <tr style="border-bottom:2px solid #d0d7de; background-color:#ffffff;">
    <td style="padding:6px 8px; text-align:center;"><span style="background:#fce7f3; color:#9d174d; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">CM</span></td>
    <td style="padding:6px 10px; text-align:right;">1,718.0</td>
    <td style="padding:6px 10px; text-align:right;">1,762.9</td>
    <td style="padding:6px 10px; text-align:right;">1,818.7</td>
    <td style="padding:6px 10px; text-align:right;">1,886.3</td>
    <td style="padding:6px 10px; text-align:right;">1,857.1</td>
    <td style="padding:6px 10px; text-align:right;">1,889.8</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td rowspan="2" style="padding:8px 14px; vertical-align:middle;"><b>Last Result Passed</b></td>
    <td style="padding:6px 8px; text-align:center;"><span style="background:#dbeafe; color:#1e40af; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">Non-CM</span></td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">368.0</td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">295.2</td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">285.0</td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">288.9</td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">288.2</td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">298.6</td>
  </tr>
  <tr style="border-bottom:2px solid #d0d7de; background-color:#f9fafb;">
    <td style="padding:6px 8px; text-align:center;"><span style="background:#fce7f3; color:#9d174d; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">CM</span></td>
    <td style="padding:6px 10px; text-align:right;">1,771.0</td>
    <td style="padding:6px 10px; text-align:right;">1,752.4</td>
    <td style="padding:6px 10px; text-align:right;">1,811.9</td>
    <td style="padding:6px 10px; text-align:right;">1,846.2</td>
    <td style="padding:6px 10px; text-align:right;">1,860.1</td>
    <td style="padding:6px 10px; text-align:right;">1,897.9</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td rowspan="2" style="padding:8px 14px; vertical-align:middle;"><b>Last Result Failed</b></td>
    <td style="padding:6px 8px; text-align:center;"><span style="background:#dbeafe; color:#1e40af; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">Non-CM</span></td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">299.0</td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">299.7</td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">286.1</td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">319.5</td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">292.1</td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">297.4</td>
  </tr>
  <tr style="border-bottom:2px solid #d0d7de; background-color:#ffffff;">
    <td style="padding:6px 8px; text-align:center;"><span style="background:#fce7f3; color:#9d174d; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">CM</span></td>
    <td style="padding:6px 10px; text-align:right;">1,747.0</td>
    <td style="padding:6px 10px; text-align:right;">1,782.6</td>
    <td style="padding:6px 10px; text-align:right;">1,812.2</td>
    <td style="padding:6px 10px; text-align:right;">1,836.0</td>
    <td style="padding:6px 10px; text-align:right;">1,854.4</td>
    <td style="padding:6px 10px; text-align:right;">1,896.2</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td rowspan="2" style="padding:8px 14px; vertical-align:middle;"><b>Blocked / Error</b></td>
    <td style="padding:6px 8px; text-align:center;"><span style="background:#dbeafe; color:#1e40af; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">Non-CM</span></td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">357.0</td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">296.9</td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">289.5</td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">292.5</td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">306.7</td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">296.7</td>
  </tr>
  <tr style="border-bottom:2px solid #d0d7de; background-color:#f9fafb;">
    <td style="padding:6px 8px; text-align:center;"><span style="background:#fce7f3; color:#9d174d; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">CM</span></td>
    <td style="padding:6px 10px; text-align:right;">1,712.0</td>
    <td style="padding:6px 10px; text-align:right;">1,763.1</td>
    <td style="padding:6px 10px; text-align:right;">1,815.6</td>
    <td style="padding:6px 10px; text-align:right;">1,839.1</td>
    <td style="padding:6px 10px; text-align:right;">1,870.9</td>
    <td style="padding:6px 10px; text-align:right;">1,890.6</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td rowspan="2" style="padding:8px 14px; vertical-align:middle;"><b>Owners</b></td>
    <td style="padding:6px 8px; text-align:center;"><span style="background:#dbeafe; color:#1e40af; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">Non-CM</span></td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">332.0</td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">291.9</td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">285.9</td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">291.8</td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">290.6</td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">299.8</td>
  </tr>
  <tr style="border-bottom:2px solid #d0d7de; background-color:#ffffff;">
    <td style="padding:6px 8px; text-align:center;"><span style="background:#fce7f3; color:#9d174d; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">CM</span></td>
    <td style="padding:6px 10px; text-align:right;">1,803.0</td>
    <td style="padding:6px 10px; text-align:right;">1,770.9</td>
    <td style="padding:6px 10px; text-align:right;">1,803.3</td>
    <td style="padding:6px 10px; text-align:right;">1,835.8</td>
    <td style="padding:6px 10px; text-align:right;">1,862.9</td>
    <td style="padding:6px 10px; text-align:right;">1,899.8</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td rowspan="2" style="padding:8px 14px; vertical-align:middle;"><b>Owners + Weights</b></td>
    <td style="padding:6px 8px; text-align:center;"><span style="background:#dbeafe; color:#1e40af; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">Non-CM</span></td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">351.0</td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">296.2</td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">286.5</td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">290.0</td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">292.1</td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">307.7</td>
  </tr>
  <tr style="border-bottom:2px solid #d0d7de; background-color:#f9fafb;">
    <td style="padding:6px 8px; text-align:center;"><span style="background:#fce7f3; color:#9d174d; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">CM</span></td>
    <td style="padding:6px 10px; text-align:right;">2,084.0</td>
    <td style="padding:6px 10px; text-align:right;">1,756.1</td>
    <td style="padding:6px 10px; text-align:right;">1,810.3</td>
    <td style="padding:6px 10px; text-align:right;">1,865.7</td>
    <td style="padding:6px 10px; text-align:right;">1,856.5</td>
    <td style="padding:6px 10px; text-align:right;">1,890.2</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td rowspan="2" style="padding:8px 14px; vertical-align:middle;"><b>Owners Exclude Iterations</b></td>
    <td style="padding:6px 8px; text-align:center;"><span style="background:#dbeafe; color:#1e40af; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">Non-CM</span></td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">287.0</td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">287.2</td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">286.7</td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">293.3</td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">289.5</td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">306.5</td>
  </tr>
  <tr style="border-bottom:2px solid #d0d7de; background-color:#ffffff;">
    <td style="padding:6px 8px; text-align:center;"><span style="background:#fce7f3; color:#9d174d; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">CM</span></td>
    <td style="padding:6px 10px; text-align:right;">1,748.0</td>
    <td style="padding:6px 10px; text-align:right;">1,757.5</td>
    <td style="padding:6px 10px; text-align:right;">1,816.3</td>
    <td style="padding:6px 10px; text-align:right;">1,836.7</td>
    <td style="padding:6px 10px; text-align:right;">1,863.1</td>
    <td style="padding:6px 10px; text-align:right;">1,888.7</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td rowspan="2" style="padding:8px 14px; vertical-align:middle;"><b>TestEnvironment + Owners</b></td>
    <td style="padding:6px 8px; text-align:center;"><span style="background:#dbeafe; color:#1e40af; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">Non-CM</span></td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">321.0</td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">279.1</td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">289.5</td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">292.1</td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">293.0</td>
    <td style="padding:6px 10px; text-align:right; color:#065f46; font-weight:bold;">306.3</td>
  </tr>
  <tr style="background-color:#f9fafb;">
    <td style="padding:6px 8px; text-align:center;"><span style="background:#fce7f3; color:#9d174d; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">CM</span></td>
    <td style="padding:6px 10px; text-align:right;">1,721.0</td>
    <td style="padding:6px 10px; text-align:right;">1,771.4</td>
    <td style="padding:6px 10px; text-align:right;">1,812.2</td>
    <td style="padding:6px 10px; text-align:right;">1,851.8</td>
    <td style="padding:6px 10px; text-align:right;">1,865.2</td>
    <td style="padding:6px 10px; text-align:right;">1,888.8</td>
  </tr>
</table>
</div>

---+++ 3. Test Case Filter Operations

In Test Case filtering, queries involving negative category filters (*Categories Excluding*) or unassigned status (*Draft*) in Non-CM RAC project areas require broader table scans and multi-join CTE evaluations across the large unversioned artifact repository. These operations took ~4.2–4.3 s at low load (cold cache) and stabilized at *~3.0–3.1 s* at 1,500 users. In CM-Aware project areas, the versioned component scoping allows these queries to execute faster (~150 ms).

<div style="max-height: 480px; overflow-y: auto; overflow-x: auto; border: 1px solid #d0d7de; border-radius: 4px; margin: 15px 0;">
<table border="0" cellpadding="8" cellspacing="0" style="border-collapse:separate; border-spacing:0; width:100%; font-size:12.5px; margin:0;">
  <tr style="background-color:#f6f8fa;">
    <th style="position:sticky; top:0; background-color:#f6f8fa; z-index:2; border-bottom:2px solid #d0d7de; padding:10px 14px; text-align:left; width:28%;"><b>Test Case Filter Transaction</b></th>
    <th style="position:sticky; top:0; background-color:#f6f8fa; z-index:2; border-bottom:2px solid #d0d7de; padding:10px 8px; text-align:center; width:12%;"><b>Mode</b></th>
    <th style="position:sticky; top:0; background-color:#f6f8fa; z-index:2; border-bottom:2px solid #d0d7de; padding:8px 10px; text-align:right; width:10%;"><b>10U<br>(ms)</b></th>
    <th style="position:sticky; top:0; background-color:#f6f8fa; z-index:2; border-bottom:2px solid #d0d7de; padding:8px 10px; text-align:right; width:10%;"><b>100U<br>(ms)</b></th>
    <th style="position:sticky; top:0; background-color:#f6f8fa; z-index:2; border-bottom:2px solid #d0d7de; padding:8px 10px; text-align:right; width:10%;"><b>250U<br>(ms)</b></th>
    <th style="position:sticky; top:0; background-color:#f6f8fa; z-index:2; border-bottom:2px solid #d0d7de; padding:8px 10px; text-align:right; width:10%;"><b>500U<br>(ms)</b></th>
    <th style="position:sticky; top:0; background-color:#f6f8fa; z-index:2; border-bottom:2px solid #d0d7de; padding:8px 10px; text-align:right; width:10%;"><b>1000U<br>(ms)</b></th>
    <th style="position:sticky; top:0; background-color:#f6f8fa; z-index:2; border-bottom:2px solid #d0d7de; padding:8px 10px; text-align:right; width:10%;"><b>1500U<br>(ms)</b></th>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td rowspan="2" style="padding:8px 14px; vertical-align:middle;"><b>Categories Excluding</b></td>
    <td style="padding:6px 8px; text-align:center;"><span style="background:#dbeafe; color:#1e40af; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">Non-CM</span></td>
    <td style="padding:6px 10px; text-align:right;">4,358.0</td>
    <td style="padding:6px 10px; text-align:right;">3,543.5</td>
    <td style="padding:6px 10px; text-align:right;">3,052.0</td>
    <td style="padding:6px 10px; text-align:right;">3,148.2</td>
    <td style="padding:6px 10px; text-align:right;">3,036.2</td>
    <td style="padding:6px 10px; text-align:right;">3,076.8</td>
  </tr>
  <tr style="border-bottom:2px solid #d0d7de; background-color:#ffffff;">
    <td style="padding:6px 8px; text-align:center;"><span style="background:#fce7f3; color:#9d174d; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">CM</span></td>
    <td style="padding:6px 10px; text-align:right;">157.0</td>
    <td style="padding:6px 10px; text-align:right;">166.0</td>
    <td style="padding:6px 10px; text-align:right;">165.1</td>
    <td style="padding:6px 10px; text-align:right;">153.6</td>
    <td style="padding:6px 10px; text-align:right;">154.8</td>
    <td style="padding:6px 10px; text-align:right;">161.2</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td rowspan="2" style="padding:8px 14px; vertical-align:middle;"><b>Draft Status</b></td>
    <td style="padding:6px 8px; text-align:center;"><span style="background:#dbeafe; color:#1e40af; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">Non-CM</span></td>
    <td style="padding:6px 10px; text-align:right;">4,223.0</td>
    <td style="padding:6px 10px; text-align:right;">3,451.3</td>
    <td style="padding:6px 10px; text-align:right;">3,118.1</td>
    <td style="padding:6px 10px; text-align:right;">3,178.3</td>
    <td style="padding:6px 10px; text-align:right;">3,072.2</td>
    <td style="padding:6px 10px; text-align:right;">3,102.5</td>
  </tr>
  <tr style="border-bottom:2px solid #d0d7de; background-color:#f9fafb;">
    <td style="padding:6px 8px; text-align:center;"><span style="background:#fce7f3; color:#9d174d; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">CM</span></td>
    <td style="padding:6px 10px; text-align:right;">176.0</td>
    <td style="padding:6px 10px; text-align:right;">192.5</td>
    <td style="padding:6px 10px; text-align:right;">162.6</td>
    <td style="padding:6px 10px; text-align:right;">160.0</td>
    <td style="padding:6px 10px; text-align:right;">156.4</td>
    <td style="padding:6px 10px; text-align:right;">162.6</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td rowspan="2" style="padding:8px 14px; vertical-align:middle;"><b>Created By</b></td>
    <td style="padding:6px 8px; text-align:center;"><span style="background:#dbeafe; color:#1e40af; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">Non-CM</span></td>
    <td style="padding:6px 10px; text-align:right;">2,218.0</td>
    <td style="padding:6px 10px; text-align:right;">2,111.6</td>
    <td style="padding:6px 10px; text-align:right;">2,021.0</td>
    <td style="padding:6px 10px; text-align:right;">2,059.7</td>
    <td style="padding:6px 10px; text-align:right;">2,022.5</td>
    <td style="padding:6px 10px; text-align:right;">2,065.5</td>
  </tr>
  <tr style="border-bottom:2px solid #d0d7de; background-color:#ffffff;">
    <td style="padding:6px 8px; text-align:center;"><span style="background:#fce7f3; color:#9d174d; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">CM</span></td>
    <td style="padding:6px 10px; text-align:right;">153.0</td>
    <td style="padding:6px 10px; text-align:right;">142.3</td>
    <td style="padding:6px 10px; text-align:right;">131.9</td>
    <td style="padding:6px 10px; text-align:right;">130.1</td>
    <td style="padding:6px 10px; text-align:right;">128.3</td>
    <td style="padding:6px 10px; text-align:right;">153.2</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td rowspan="2" style="padding:8px 14px; vertical-align:middle;"><b>Categories (Some Unassigned)</b></td>
    <td style="padding:6px 8px; text-align:center;"><span style="background:#dbeafe; color:#1e40af; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">Non-CM</span></td>
    <td style="padding:6px 10px; text-align:right;">944.0</td>
    <td style="padding:6px 10px; text-align:right;">908.0</td>
    <td style="padding:6px 10px; text-align:right;">929.2</td>
    <td style="padding:6px 10px; text-align:right;">950.0</td>
    <td style="padding:6px 10px; text-align:right;">953.7</td>
    <td style="padding:6px 10px; text-align:right;">969.6</td>
  </tr>
  <tr style="border-bottom:2px solid #d0d7de; background-color:#f9fafb;">
    <td style="padding:6px 8px; text-align:center;"><span style="background:#fce7f3; color:#9d174d; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">CM</span></td>
    <td style="padding:6px 10px; text-align:right;">269.0</td>
    <td style="padding:6px 10px; text-align:right;">265.2</td>
    <td style="padding:6px 10px; text-align:right;">241.0</td>
    <td style="padding:6px 10px; text-align:right;">231.9</td>
    <td style="padding:6px 10px; text-align:right;">227.2</td>
    <td style="padding:6px 10px; text-align:right;">288.9</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td rowspan="2" style="padding:8px 14px; vertical-align:middle;"><b>Categories</b></td>
    <td style="padding:6px 8px; text-align:center;"><span style="background:#dbeafe; color:#1e40af; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">Non-CM</span></td>
    <td style="padding:6px 10px; text-align:right; color:#8c959f; font-style:italic;">—</td>
    <td style="padding:6px 10px; text-align:right;">995.1</td>
    <td style="padding:6px 10px; text-align:right;">998.1</td>
    <td style="padding:6px 10px; text-align:right;">1,051.8</td>
    <td style="padding:6px 10px; text-align:right;">1,018.2</td>
    <td style="padding:6px 10px; text-align:right;">1,038.6</td>
  </tr>
  <tr style="border-bottom:2px solid #d0d7de; background-color:#ffffff;">
    <td style="padding:6px 8px; text-align:center;"><span style="background:#fce7f3; color:#9d174d; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">CM</span></td>
    <td style="padding:6px 10px; text-align:right; color:#8c959f; font-style:italic;">—</td>
    <td style="padding:6px 10px; text-align:right;">172.8</td>
    <td style="padding:6px 10px; text-align:right;">149.2</td>
    <td style="padding:6px 10px; text-align:right;">142.9</td>
    <td style="padding:6px 10px; text-align:right;">141.1</td>
    <td style="padding:6px 10px; text-align:right;">157.7</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td rowspan="2" style="padding:8px 14px; vertical-align:middle;"><b>Categories + TP ScriptSteps</b></td>
    <td style="padding:6px 8px; text-align:center;"><span style="background:#dbeafe; color:#1e40af; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">Non-CM</span></td>
    <td style="padding:6px 10px; text-align:right;">998.0</td>
    <td style="padding:6px 10px; text-align:right;">982.3</td>
    <td style="padding:6px 10px; text-align:right;">998.8</td>
    <td style="padding:6px 10px; text-align:right;">1,030.3</td>
    <td style="padding:6px 10px; text-align:right;">1,038.8</td>
    <td style="padding:6px 10px; text-align:right;">1,037.7</td>
  </tr>
  <tr style="border-bottom:2px solid #d0d7de; background-color:#f9fafb;">
    <td style="padding:6px 8px; text-align:center;"><span style="background:#fce7f3; color:#9d174d; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">CM</span></td>
    <td style="padding:6px 10px; text-align:right;">142.0</td>
    <td style="padding:6px 10px; text-align:right;">162.7</td>
    <td style="padding:6px 10px; text-align:right;">159.9</td>
    <td style="padding:6px 10px; text-align:right;">142.9</td>
    <td style="padding:6px 10px; text-align:right;">142.6</td>
    <td style="padding:6px 10px; text-align:right;">151.5</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td rowspan="2" style="padding:8px 14px; vertical-align:middle;"><b>Categories + TS + Scripts</b></td>
    <td style="padding:6px 8px; text-align:center;"><span style="background:#dbeafe; color:#1e40af; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">Non-CM</span></td>
    <td style="padding:6px 10px; text-align:right;">947.0</td>
    <td style="padding:6px 10px; text-align:right;">943.9</td>
    <td style="padding:6px 10px; text-align:right;">955.2</td>
    <td style="padding:6px 10px; text-align:right;">1,002.5</td>
    <td style="padding:6px 10px; text-align:right;">978.1</td>
    <td style="padding:6px 10px; text-align:right;">988.1</td>
  </tr>
  <tr style="border-bottom:2px solid #d0d7de; background-color:#ffffff;">
    <td style="padding:6px 8px; text-align:center;"><span style="background:#fce7f3; color:#9d174d; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">CM</span></td>
    <td style="padding:6px 10px; text-align:right;">144.0</td>
    <td style="padding:6px 10px; text-align:right;">157.9</td>
    <td style="padding:6px 10px; text-align:right;">133.5</td>
    <td style="padding:6px 10px; text-align:right;">125.4</td>
    <td style="padding:6px 10px; text-align:right;">126.7</td>
    <td style="padding:6px 10px; text-align:right;">131.9</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td rowspan="2" style="padding:8px 14px; vertical-align:middle;"><b>Categories + Weight</b></td>
    <td style="padding:6px 8px; text-align:center;"><span style="background:#dbeafe; color:#1e40af; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">Non-CM</span></td>
    <td style="padding:6px 10px; text-align:right;">982.0</td>
    <td style="padding:6px 10px; text-align:right;">975.1</td>
    <td style="padding:6px 10px; text-align:right;">987.5</td>
    <td style="padding:6px 10px; text-align:right;">1,035.5</td>
    <td style="padding:6px 10px; text-align:right;">1,009.1</td>
    <td style="padding:6px 10px; text-align:right;">1,019.8</td>
  </tr>
  <tr style="border-bottom:2px solid #d0d7de; background-color:#f9fafb;">
    <td style="padding:6px 8px; text-align:center;"><span style="background:#fce7f3; color:#9d174d; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">CM</span></td>
    <td style="padding:6px 10px; text-align:right;">89.0</td>
    <td style="padding:6px 10px; text-align:right;">87.9</td>
    <td style="padding:6px 10px; text-align:right;">78.3</td>
    <td style="padding:6px 10px; text-align:right;">72.8</td>
    <td style="padding:6px 10px; text-align:right;">72.2</td>
    <td style="padding:6px 10px; text-align:right;">75.8</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td rowspan="2" style="padding:8px 14px; vertical-align:middle;"><b>Owners</b></td>
    <td style="padding:6px 8px; text-align:center;"><span style="background:#dbeafe; color:#1e40af; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">Non-CM</span></td>
    <td style="padding:6px 10px; text-align:right;">1,356.0</td>
    <td style="padding:6px 10px; text-align:right;">1,227.0</td>
    <td style="padding:6px 10px; text-align:right;">1,148.6</td>
    <td style="padding:6px 10px; text-align:right;">1,186.0</td>
    <td style="padding:6px 10px; text-align:right;">1,177.6</td>
    <td style="padding:6px 10px; text-align:right;">1,190.6</td>
  </tr>
  <tr style="background-color:#ffffff;">
    <td style="padding:6px 8px; text-align:center;"><span style="background:#fce7f3; color:#9d174d; font-size:10px; font-weight:bold; padding:2px 6px; border-radius:4px;">CM</span></td>
    <td style="padding:6px 10px; text-align:right;">159.0</td>
    <td style="padding:6px 10px; text-align:right;">148.4</td>
    <td style="padding:6px 10px; text-align:right;">129.2</td>
    <td style="padding:6px 10px; text-align:right;">132.5</td>
    <td style="padding:6px 10px; text-align:right;">148.0</td>
    <td style="padding:6px 10px; text-align:right;">152.3</td>
  </tr>
</table>
</div>

<br>
---+ Performance Limitations

During rigorous performance and single-user scale profiling, two existing Jazz Foundation (JAF) Web UI services were identified as performance bottlenecks when the total number of project areas, team areas, and user memberships in an environment becomes very large.

%BLUE% *Important Technical Context:* %ENDCOLOR%
It is important to emphasize that this performance degradation is *not caused by RAC code changes*. No modifications were made to either of these services as part of the Read Access Control feature delivery. However, because adopting the RAC feature naturally encourages organizations to create and configure more Team Areas to partition artifact access, the total volume of team areas in an enterprise repository increases. Because these two preexisting foundation services are designed to traverse, serialize, and return complete process area hierarchies and user memberships, their execution latency is directly dependent on the total count of project areas and team areas in the repository.

To provide transparent guidance for architecture, capacity planning, and deployment design, the operational characteristics of these two services are detailed below.

---++ 1. Service: =/processAreaHierarchiesWithApplicationContext=

   * *Full Service Endpoint*:
     =/qm/service/com.ibm.team.process.internal.service.web.IProcessWebUIService/processAreaHierarchiesWithApplicationContext=
   * *When Triggered*:
     Executed automatically by the web client whenever a user loads or refreshes an ETM *Project Area Dashboard*.
   * *Behavior & Performance Impact*:
     This service computes the complete process area hierarchy (all project areas and recursive team areas) associated with the application context. When an environment contains thousands of project areas and deeply nested team areas, this service experiences significant latency—taking *up to ~1 minute (60 seconds)* to return.
   * *Impact on End-User Experience*:
     The initial dashboard loading spinner remains active for extended durations, degrading the perceived performance of project dashboards.

The single-user characterization chart below illustrates response time growth for =processAreaHierarchiesWithApplicationContext= as the team area count increases:

<img src="%ATTACHURLPATH%/processAreaHierarchiesWithApplicationContext_chart.png" alt="processAreaHierarchiesWithApplicationContext_chart.png" width="950" style="max-width:100%; height:auto; border: 1px solid #e1e4e8; border-radius: 4px; margin: 12px 0;" />

<br>
---++ 2. Service: =/processAreasForUser=

   * *Full Service Endpoint*:
     =/qm/service/com.ibm.team.process.internal.service.web.IProcessWebUIService/processAreasForUser=
   * *When Triggered*:
     Triggered during user navigating to artifact editors or detail views (such as opening a Test Plan, Test Case, or TCER).
   * *Behavior & Performance Impact*:
     This service fetches and serializes all project areas and team areas to which the logged-in user is explicitly assigned. As a user's assigned team area count grows (e.g. users belonging to hundreds of team areas across large enterprise deployments), the payload generation and permission resolution time scale linearly.
   * *Impact on End-User Experience*:
     Introduces incremental latency on individual artifact transitions and initial navigation clicks for users with broad team memberships.

The chart below shows single-user response times for =processAreasForUser= as a function of the user's assigned team area count:

<img src="%ATTACHURLPATH%/getProcessAreasForUser_chart.png" alt="getProcessAreasForUser_chart.png" width="950" style="max-width:100%; height:auto; border: 1px solid #e1e4e8; border-radius: 4px; margin: 12px 0;" />

---++ Recommendations

The performance degradation in both services stems from recursive hierarchy traversal and process model serialization in the Jazz Foundation layer when handling massive team area sets.

*Recommendations & Best Practices*:
   1. *Team Area Sizing*: Keep total team areas per project area within the tested sweet spot (*500 to 1,000 team areas*). Where larger counts are required, maintain user concurrency within the recommended limits (1,000 users for 2,000 team areas).
   2. *Principle of Least Privilege in Team Membership*: Avoid assigning individual user accounts or service accounts globally to hundreds of team areas. Users should only be added to the specific team areas where they actively participate.
   3. *Dashboard Optimization*: Avoid heavy process-area-dependent widgets on personal and project dashboards where large team hierarchies exist.

<br>
---+ Additional Details on the Data Shape

To provide full context on the repository size used during testing, the breakdown of artifact distributions across project areas and overall database table volumes in the ETM repository is detailed below.

*Repository Overview*:
   * *Total Project Areas*: 2,040
   * *Total Team Areas*: 20,200
   * *Total Artifact Count in Repository Version Table*: 216,162,299 artifacts

---+++ Artifact Counts in =repository_version= Table

<table border="1" cellpadding="8" cellspacing="0" style="border-collapse:collapse; width:80%; border:1px solid #d0d7de; font-size:12.5px; margin: 12px 0 28px 0;">
  <tr style="background-color:#f6f8fa; border-bottom: 2px solid #d0d7de;">
    <th style="padding:9px 16px; text-align:left; width:65%;"><b>Artifact Type (=repository_version=)</b></th>
    <th style="padding:9px 16px; text-align:right; width:35%;"><b>Count</b></th>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px;">com.ibm.rqm.execution#ExecutionElementResult</td>
    <td style="padding:7px 16px; text-align:right; font-weight:bold;">115,481,548</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px;">com.ibm.rqm.execution#ExecutionResult</td>
    <td style="padding:7px 16px; text-align:right; font-weight:bold;">28,870,387</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px;">com.ibm.rqm.planning#ExecutionElement2</td>
    <td style="padding:7px 16px; text-align:right; font-weight:bold;">19,569,260</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px;">com.ibm.rqm.execution#TestcaseExecutionRecord</td>
    <td style="padding:7px 16px; text-align:right; font-weight:bold;">18,525,548</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px;">com.ibm.rqm.planning#ManualExecutionScriptStepLookup</td>
    <td style="padding:7px 16px; text-align:right;">4,904,187</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px;">com.ibm.rqm.deployment#QualityApproval</td>
    <td style="padding:7px 16px; text-align:right;">4,890,719</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px;">com.ibm.rqm.planning#VersionedExecutionScript</td>
    <td style="padding:7px 16px; text-align:right;">4,884,836</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px;">com.ibm.rqm.planning#ManualExecutionScript</td>
    <td style="padding:7px 16px; text-align:right;">4,884,836</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px;">com.ibm.rqm.planning#VersionedTestCase</td>
    <td style="padding:7px 16px; text-align:right;">4,881,583</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px;">com.ibm.rqm.planning#TestCase</td>
    <td style="padding:7px 16px; text-align:right;">4,881,583</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px;">com.ibm.rqm.execution#ExecutionResultGroup</td>
    <td style="padding:7px 16px; text-align:right;">2,438,100</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px;">com.ibm.rational.test.lm.sequencer#ExecutionSequence</td>
    <td style="padding:7px 16px; text-align:right;">779,917</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px;">com.ibm.rqm.planning#TestSuite</td>
    <td style="padding:7px 16px; text-align:right;">550,885</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px;">com.ibm.rqm.planning#VersionedTestSuite</td>
    <td style="padding:7px 16px; text-align:right;">550,885</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px;">com.ibm.rqm.execution#TestSuiteExecutionRecord</td>
    <td style="padding:7px 16px; text-align:right;">550,330</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px;">com.ibm.rqm.process#TestPhase</td>
    <td style="padding:7px 16px; text-align:right;">316,022</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px;">com.ibm.rational.test.lm#AssetConfiguration</td>
    <td style="padding:7px 16px; text-align:right;">135,386</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px;">com.ibm.rqm.planning#VersionedTestPlan</td>
    <td style="padding:7px 16px; text-align:right;">22,721</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px;">com.ibm.rqm.planning#TestPlan</td>
    <td style="padding:7px 16px; text-align:right;">22,721</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px;">com.ibm.rqm.process#SizingRecord</td>
    <td style="padding:7px 16px; text-align:right;">22,144</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px;">com.ibm.team.links#AuditableLink</td>
    <td style="padding:7px 16px; text-align:right;">9,680</td>
  </tr>
  <tr style="border-bottom:2px solid #d0d7de; background-color:#f9fafb;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px;">com.ibm.rqm.risk#Risk</td>
    <td style="padding:7px 16px; text-align:right;">21</td>
  </tr>
  <tr style="background-color:#f1f5f9; font-weight:bold;">
    <td style="padding:9px 16px; text-align:left;"><b>Total Artifact Count</b></td>
    <td style="padding:9px 16px; text-align:right; font-size:13.5px; color:#1e40af;"><b>216,162,299 artifacts</b></td>
  </tr>
</table>

<br><br>
---+++ Test Case Distribution by Project Area

<table border="1" cellpadding="8" cellspacing="0" style="border-collapse:collapse; width:75%; border:1px solid #d0d7de; font-size:12.5px; margin: 12px 0 28px 0;">
  <tr style="background-color:#f6f8fa; border-bottom: 2px solid #d0d7de;">
    <th style="padding:9px 16px; text-align:left; width:65%;"><b>Project Area</b></th>
    <th style="padding:9px 16px; text-align:right; width:35%;"><b>Test Case Count</b></th>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px;"><b>CLM603_QM</b></td>
    <td style="padding:7px 16px; text-align:right; font-weight:bold;">2,798,186</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px; color:#6f42c1;">ETM_Project_CM_500K_10KUsers_RAC</td>
    <td style="padding:7px 16px; text-align:right;">24,600</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px; color:#6f42c1;">ETM_Project_CM_500K_RAC</td>
    <td style="padding:7px 16px; text-align:right;">19,800</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px; color:#0969da;">ETM_Project_Non-CM_500K_10KUsers_RAC</td>
    <td style="padding:7px 16px; text-align:right;">18,600</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px; color:#0969da;">ETM_Project_Non-CM_500K_RAC</td>
    <td style="padding:7px 16px; text-align:right;">11,400</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px; color:#6f42c1;">ETM_Project_CM_50K_RAC</td>
    <td style="padding:7px 16px; text-align:right;">3,500</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px; color:#0969da;">ETM_Project_Non-CM_50K_RAC</td>
    <td style="padding:7px 16px; text-align:right;">3,000</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px;">ETM_ReconcileTest_ConfigurationManagement_Disable</td>
    <td style="padding:7px 16px; text-align:right;">806</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px;">QM_ReconcileTest</td>
    <td style="padding:7px 16px; text-align:right;">800</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px;">QM_ReconcileTest_WithConfigurationManagement</td>
    <td style="padding:7px 16px; text-align:right;">465</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px;">ETM_Project_RAC_1</td>
    <td style="padding:7px 16px; text-align:right;">8</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px;">ETM_Link_Test</td>
    <td style="padding:7px 16px; text-align:right;">2</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px;">JAF_Services_Exploration_CM</td>
    <td style="padding:7px 16px; text-align:right;">1</td>
  </tr>
  <tr style="background-color:#f9fafb;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px;">ETM Sev 1 test</td>
    <td style="padding:7px 16px; text-align:right;">1</td>
  </tr>
</table>

<br><br>
---+++ Test Suite Distribution by Project Area

<table border="1" cellpadding="8" cellspacing="0" style="border-collapse:collapse; width:75%; border:1px solid #d0d7de; font-size:12.5px; margin: 12px 0 28px 0;">
  <tr style="background-color:#f6f8fa; border-bottom: 2px solid #d0d7de;">
    <th style="padding:9px 16px; text-align:left; width:65%;"><b>Project Area</b></th>
    <th style="padding:9px 16px; text-align:right; width:35%;"><b>Test Suite Count</b></th>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px;"><b>CLM603_QM</b></td>
    <td style="padding:7px 16px; text-align:right; font-weight:bold;">342,720</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px; color:#6f42c1;">ETM_Project_CM_500K_10KUsers_RAC</td>
    <td style="padding:7px 16px; text-align:right;">2,520</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px; color:#6f42c1;">ETM_Project_CM_500K_RAC</td>
    <td style="padding:7px 16px; text-align:right;">1,980</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px; color:#0969da;">ETM_Project_Non-CM_500K_10KUsers_RAC</td>
    <td style="padding:7px 16px; text-align:right;">1,785</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px; color:#0969da;">ETM_Project_Non-CM_500K_RAC</td>
    <td style="padding:7px 16px; text-align:right;">1,140</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px; color:#6f42c1;">ETM_Project_CM_50K_RAC</td>
    <td style="padding:7px 16px; text-align:right;">400</td>
  </tr>
  <tr style="background-color:#ffffff;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px; color:#0969da;">ETM_Project_Non-CM_50K_RAC</td>
    <td style="padding:7px 16px; text-align:right;">300</td>
  </tr>
</table>

<br><br>
---+++ Test Case Execution Record (TCER) Distribution by Project Area

<table border="1" cellpadding="8" cellspacing="0" style="border-collapse:collapse; width:75%; border:1px solid #d0d7de; font-size:12.5px; margin: 12px 0 28px 0;">
  <tr style="background-color:#f6f8fa; border-bottom: 2px solid #d0d7de;">
    <th style="padding:9px 16px; text-align:left; width:65%;"><b>Project Area</b></th>
    <th style="padding:9px 16px; text-align:right; width:35%;"><b>TCER Count</b></th>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px;"><b>CLM603_QM</b></td>
    <td style="padding:7px 16px; text-align:right; font-weight:bold;">10,436,440</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px; color:#6f42c1;">ETM_Project_CM_500K_10KUsers_RAC</td>
    <td style="padding:7px 16px; text-align:right;">133,991</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px; color:#6f42c1;">ETM_Project_CM_500K_RAC</td>
    <td style="padding:7px 16px; text-align:right;">107,365</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px; color:#0969da;">ETM_Project_Non-CM_500K_10KUsers_RAC</td>
    <td style="padding:7px 16px; text-align:right;">98,208</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px; color:#0969da;">ETM_Project_Non-CM_500K_RAC</td>
    <td style="padding:7px 16px; text-align:right;">62,588</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px; color:#6f42c1;">ETM_Project_CM_50K_RAC</td>
    <td style="padding:7px 16px; text-align:right;">19,158</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px; color:#0969da;">ETM_Project_Non-CM_50K_RAC</td>
    <td style="padding:7px 16px; text-align:right;">16,479</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px;">ETM_Project_RAC_1</td>
    <td style="padding:7px 16px; text-align:right;">8</td>
  </tr>
  <tr style="background-color:#ffffff;">
    <td style="padding:7px 16px; text-align:left; font-family:monospace; font-size:12px;">JAF_Services_Exploration_CM</td>
    <td style="padding:7px 16px; text-align:right;">1</td>
  </tr>
</table>

<br>
---+ Appendix: Abbreviations and Terminology

<table border="1" cellpadding="8" cellspacing="0" style="border-collapse:collapse; width:85%; border:1px solid #d0d7de; font-size:13px; margin: 15px 0;">
  <tr style="background-color:#f6f8fa; border-bottom: 2px solid #d0d7de;">
    <th style="padding:10px 16px; text-align:left; width:22%;"><b>Abbreviation</b></th>
    <th style="padding:10px 16px; text-align:left; width:78%;"><b>Description / Full Form</b></th>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td style="padding:8px 16px; font-family:monospace; font-size:12px; font-weight:bold; color:#0969da;">ETM</td>
    <td style="padding:8px 16px;">IBM Engineering Test Management (formerly Rational Quality Manager / RQM)</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td style="padding:8px 16px; font-family:monospace; font-size:12px; font-weight:bold; color:#0969da;">RAC</td>
    <td style="padding:8px 16px;">Read Access Control (using Jazz Team Areas for granular artifact visibility)</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td style="padding:8px 16px; font-family:monospace; font-size:12px; font-weight:bold; color:#0969da;">TCER</td>
    <td style="padding:8px 16px;">Test Case Execution Record</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td style="padding:8px 16px; font-family:monospace; font-size:12px; font-weight:bold; color:#0969da;">TSER</td>
    <td style="padding:8px 16px;">Test Suite Execution Record</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td style="padding:8px 16px; font-family:monospace; font-size:12px; font-weight:bold; color:#0969da;">TP / TC / TS</td>
    <td style="padding:8px 16px;">Test Plan / Test Case / Test Suite</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td style="padding:8px 16px; font-family:monospace; font-size:12px; font-weight:bold; color:#0969da;">Non-CM</td>
    <td style="padding:8px 16px;">Non-Configuration Management enabled project area (traditional unversioned project)</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td style="padding:8px 16px; font-family:monospace; font-size:12px; font-weight:bold; color:#0969da;">CM</td>
    <td style="padding:8px 16px;">Configuration Management (versioned, baseline, and stream-aware project area)</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td style="padding:8px 16px; font-family:monospace; font-size:12px; font-weight:bold; color:#0969da;">JAF</td>
    <td style="padding:8px 16px;">Jazz Foundation Architecture / Services</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td style="padding:8px 16px; font-family:monospace; font-size:12px; font-weight:bold; color:#0969da;">JTS</td>
    <td style="padding:8px 16px;">Jazz Team Server</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td style="padding:8px 16px; font-family:monospace; font-size:12px; font-weight:bold; color:#0969da;">RPT</td>
    <td style="padding:8px 16px;">Rational Performance Tester (workload generator tool)</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td style="padding:8px 16px; font-family:monospace; font-size:12px; font-weight:bold; color:#0969da;">CTE</td>
    <td style="padding:8px 16px;">Common Table Expression (SQL construct used for recursive hierarchy resolution)</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#f9fafb;">
    <td style="padding:8px 16px; font-family:monospace; font-size:12px; font-weight:bold; color:#0969da;">SLA</td>
    <td style="padding:8px 16px;">Service Level Agreement (e.g. standard 5.0-second response time threshold)</td>
  </tr>
  <tr style="border-bottom:1px solid #e1e4e8; background-color:#ffffff;">
    <td style="padding:8px 16px; font-family:monospace; font-size:12px; font-weight:bold; color:#0969da;">AWR</td>
    <td style="padding:8px 16px;">Automatic Workload Repository (Oracle Database performance reporting engine)</td>
  </tr>
  <tr style="background-color:#f9fafb;">
    <td style="padding:8px 16px; font-family:monospace; font-size:12px; font-weight:bold; color:#0969da;">NMON</td>
    <td style="padding:8px 16px;">Nigel's Monitor (operating system resource and performance monitor for Linux/AIX)</td>
  </tr>
</table>

<br>
---+ References

   * [[https://www.ibm.com/docs/en/engineering-lifecycle-management-suite/test-management/7.3.0_beta?topic=areas-read-access-control-by-using-team][IBM Documentation: Read access control by using team areas in ETM]]

</div>
</sticky>
Attachments
Topic attachments
I	Attachment	Action	Size	Date	Who	Comment
png	CPU_Usages_DatabaseServer.png	manage	117.8 K	2026-10-08 - 13:35	SameerkumarKalaria	CPU_Usages_DatabaseServer
png	CPU_Usages_ETMServer.png	manage	114.5 K	2026-10-08 - 13:36	SameerkumarKalaria	CPU_Usages_ETMServer
png	ETMProject_TeamAreaHierarchy.png	manage	250.0 K	2026-10-08 - 13:38	SameerkumarKalaria	ETMProject_TeamAreaHierarchy
png	ETM_RAC_RPT_Schedule.png	manage	426.7 K	2026-10-08 - 13:37	SameerkumarKalaria	ETM_RAC_RPT_Schedule
png	ResponseTimeVsUsers_1000TeamAreas.png	manage	323.2 K	2026-10-08 - 13:39	SameerkumarKalaria	ResponseTimeVsUsers_1000TeamAreas
png	ResponseTimeVsUsers_1000TeamAreas_Chart1.png	manage	310.1 K	2026-10-12 - 16:26	SameerkumarKalaria	ResponseTimeVsUsers_1000TeamAreas_Chart1
png	ResponseTimeVsUsers_1000TeamAreas_Chart2.png	manage	283.7 K	2026-10-12 - 16:27	SameerkumarKalaria	ResponseTimeVsUsers_1000TeamAreas_Chart2
png	ResponseTimeVsUsers_2000TeamAreas.png	manage	297.2 K	2026-10-08 - 13:40	SameerkumarKalaria	ResponseTimeVsUsers_2000TeamAreas
png	ResponseTimeVsUsers_2000TeamAreas_Chart1.png	manage	233.8 K	2026-10-12 - 16:28	SameerkumarKalaria	ResponseTimeVsUsers_2000TeamAreas_Chart1
png	ResponseTimeVsUsers_2000TeamAreas_Chart2.png	manage	294.4 K	2026-10-12 - 16:29	SameerkumarKalaria	ResponseTimeVsUsers_2000TeamAreas_Chart2
png	ResponseTimeVsUsers_500TeamAreas.png	manage	323.8 K	2026-10-08 - 13:39	SameerkumarKalaria	ResponseTimeVsUsers_500TeamAreas
png	getProcessAreasForUser_chart.png	manage	65.7 K	2026-10-08 - 13:38	SameerkumarKalaria	getProcessAreasForUser_chart
png	processAreaHierarchiesWithApplicationContext_chart.png	manage	64.2 K	2026-10-08 - 13:38	SameerkumarKalaria	processAreaHierarchiesWithApplicationContext_chart
Copyright © by IBM and non-IBM contributing authors. All material on this collaboration platform is the property of the contributing authors.
Contributions are governed by our Terms of Use. Please read the following disclaimer.
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.