Database Reference
In-Depth Information
Step 8
Now that the primary bottlenecks of the database and the application have been determined, the next series of tests
(Table 4-9 ) is to determine the maximum number of users supported by the RAC cluster. In the next series of tests, the
number of users, number of database servers, and also tests by increasing the number of application servers where
performed based on demand for resources.
Table 4-9. RAP Phase VII—Load Test on One Server
Test #
Date & Time
# of Users
Test
Duration
# of Db
Servers
# of App
Servers
Description
Status
9
20-Aug-xxxx
180
120 minutes
6
8
Db servers show normal
CPU usage and workload
is distributed across all db
instances.
Response times are slower
compared to previous
tests but within SLA
requirements.
SUCCESS
10
25-Aug-xxxx
240
120 minutes
6
8
2 application servers and
2 database servers evicted
because of high CPU usage
and server overload.
FAILED
Test 10 failed due to server saturation; this means that the ideal configuration from the preceding tests is 90 users
on a 6-node database cluster with 8 node application servers. Table 4-10 gives a snapshot of all the tests.
Table 4-10. RAP Phase VII—Consolidated List of Tests
Test #
# of Users
Duration
# of Db Servers
# of App Servers
1
40
2 hours
1
6
2
40
2 hours
4
6
3
40
2 hours
4
6
4
60
2 hours
4
6
5
80
2 hours
5
6
6
120
2 hours
5
6
7
140
2 hours
5
6
8
160
2 hours
5
7
9
180
2 hours
6
8
10
240
2 hours
6
8
11
240
2 hours
8
8
12
240
2 hours
8
8
13
180
2 hours
8
8
 
Search WWH ::




Custom Search