HP ProLiant 3000 DSS Sizing and Tuning of Oracle8 for Windows NT on Compaq Ser - Page 21

System Processor Scalability

Page 21 highlights

DSS Sizing and Tuning of Oracle8 for Windows NT on CompaqServers Page 19 I/O's per second per drive would be within the 75 I/O's per second per drive limit. Hence, you would not have to add more disk drives or rearrange files if you were using 9.1-Gigabyte drives. Figure 10: Performance Monitor - Disk I/O System Processor Scalability Oracle8 Server for Windows NT provides good system processor scalability. By adding system processors, performance can be improved, provided that your system is processor-bound. While no operating system or hardware provides 100-percent scalability, Windows NT and Oracle8 provide an above-average level of scalability. When well-tuned Oracle instances are system processor bound, most applications see significant improvement from the addition of more powerful processors and more processors. Additional cache may provide some improvement, depending upon the number of processors used. If the system is I/O bound, adding system processors will not offer significant improvement. In DSS systems, it is important to determine the threshold for acceptable processor performance. This threshold will depend upon the number of users and the processor time that each will require. © 1998 Compaq Computer Corporation, All Rights Reserved Doc No ECG156/0398

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45

DSS Sizing and Tuning of Oracle8 for Windows NT on CompaqServers
Page
19
1998 Compaq Computer Corporation, All Rights Reserved
Doc No ECG156/0398
I/O’s per second per drive would be within the 75 I/O’s per second per drive limit.
Hence, you
would not have to add more disk drives or rearrange files if you were using 9.1-Gigabyte drives.
Figure 10:
Performance Monitor - Disk I/O
System Processor Scalability
Oracle8 Server for Windows NT provides good system processor scalability.
By adding system
processors, performance can be improved, provided that your system is processor-bound.
While
no operating system or hardware provides 100-percent scalability, Windows NT and Oracle8
provide an above-average level of scalability.
When well-tuned Oracle instances are system
processor bound, most applications see significant improvement from the addition of more
powerful processors and more processors.
Additional cache may provide some improvement,
depending upon the number of processors used.
If the system is I/O bound, adding system
processors will not offer significant improvement.
In DSS systems, it is important to determine
the threshold for acceptable processor performance.
This threshold will depend upon the number
of users and the processor time that each will require.