Compaq ProLiant 1000 Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 49

Compaq Proliant 5000 Server with 4 P6/166 processor boards.

Page 49 highlights

Compaq Backup and Recovery for Microsoft SQL Server 6.x Page 49 2 Compaq DLT Tape Array cabinets. 1 Compaq External Storage cabinet with 5 Fast-Wide disk drives. 3 Compaq NetFlex-3 PCI 10/100 TX UTP cards. This is the primary system under test. It was set up as follows: The system boot and binary files were installed on a single internal disk drive attached to the integrated Fast-Wide SCSI-2 controller. The external storage cabinet was attached to one of the Smart-2 ports, and configured as a RAID-5 volume for the disk dump tests. The external cabinet was later removed, and the Smart-2/P was removed to make room for Fast-Wide SCSI-2 controllers needed for the tape backup tests. No database was built on this system. Up to 4 NetFlex-3 NICs were added to the system, as multiple NICs were used for tests in which multiple remote databases were backed up in parallel. These cards are capable of detecting either 10 Mb or 100 Mb transfers, so could be used for both types of tests. All of the NetFlex-3's were placed on the system's primary PCI bus All DLT Tape drives used for the tape dump device tests were attached either to the integrated Fast-Wide SCSI-2/P controller or to additional Wide-Ultra SCSI controllers. SCSI controllers used for the tape drives were placed on the secondary PCI bus of the Proliant 5000, apart from the network cards which were placed on the primary PCI bus. In this way, system throughput was optimized because the load was split evenly across the peer PCI channels (all data transferred into the system from peripherals on PCI bus 1, all data written out from memory to peripherals on PCI bus 2). Database Server: Compaq Proliant 5000 Server with 4 P6/166 processor boards. 1 Compaq SMART-2 Array PCI controller (C875). 1 Compaq External Storage cabinet with 5 Fast-Wide disk drives. 1 Compaq NetFlex-3 PCI 10/100 TX UTP card. This was the same system used for previous tests, with some modifications. It was set up as follows: The system boot and binary files were installed on a Smart-2 volume on the internal drives, along with the transaction log file for the database. The transaction log was first truncated so as not to figure into the database backup throughput (transaction log dumps are analyzed later). The system boot and binary files were installed on a Smart-2/P volume composed of drives in the internal bays. The external storage cabinet was attached to the external Smart-2 port, configured as a RAID-5 volume to hold the database. All SCSI-2/P controllers and DLT tape drives were removed from the system and added to the storage server (see above). For the later tests involving concurrent backups, another Proliant 5000 similar to the above was brought in to serve as a second database server. Two other machines were also configured as database servers, with the following hardware: Compaq Proliant 2500 Server with 1 P6/200 processor board. 1 Compaq SMART-2 Array PCI controller (C875). 1 Compaq External Storage cabinet with 4 Fast-Wide disk drives. 1 Compaq Integrated Netelligent 10/100 TX PCI card. Network: 1997 Compaq Computer Corporation, All Rights Reserved Doc No 444A/0797

  • 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
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81

Compaq Backup and Recovery for Microsoft SQL Server 6.x
Page
49
1997 Compaq Computer Corporation, All Rights Reserved
Doc No 444A/0797
2 Compaq DLT Tape Array cabinets.
1 Compaq External Storage cabinet with 5 Fast-Wide disk drives.
3 Compaq NetFlex-3 PCI 10/100 TX UTP cards.
This is the primary system under test.
It was set up as follows:
The system boot and binary files were installed on a single internal disk drive attached to the
integrated Fast-Wide SCSI-2 controller.
The external storage cabinet was attached to one of the
Smart-2 ports, and configured as a RAID-5 volume for the disk dump tests.
The external cabinet
was later removed, and the Smart-2/P was removed to make room for Fast-Wide SCSI-2
controllers needed for the tape backup tests.
No database was built on this system.
Up to 4 NetFlex-3 NICs were added to the system, as multiple NICs were used for tests in which
multiple remote databases were backed up in parallel.
These cards are capable of detecting either
10 Mb or 100 Mb transfers, so could be used for both types of tests.
All of the NetFlex-3’s were
placed on the system’s primary PCI bus
All DLT Tape drives used for the tape dump device tests were attached either to the integrated
Fast-Wide SCSI-2/P controller or to additional Wide-Ultra SCSI controllers.
SCSI controllers used
for the tape drives were placed on the secondary PCI bus of the Proliant 5000, apart from the
network cards which were placed on the primary PCI bus.
In this way, system throughput was
optimized because the load was split evenly across the peer PCI channels (all data transferred into
the system from peripherals on PCI bus 1, all data written out from memory to peripherals on PCI
bus 2).
Database Server:
Compaq Proliant 5000 Server with 4 P6/166 processor boards.
1 Compaq SMART-2 Array PCI controller (C875).
1 Compaq External Storage cabinet with 5 Fast-Wide disk drives.
1 Compaq NetFlex-3 PCI 10/100 TX UTP card.
This was the same system used for previous tests, with some modifications.
It was set up as follows:
The system boot and binary files were installed on a Smart-2 volume on the internal drives, along
with the transaction log file for the database.
The transaction log was first truncated so as not to
figure into the database backup throughput (transaction log dumps are analyzed later).
The system boot and binary files were installed on a Smart-2/P volume composed of drives in the
internal bays.
The external storage cabinet was attached to the external Smart-2 port, configured
as a RAID-5 volume to hold the database.
All SCSI-2/P controllers and DLT tape drives were removed from the system and added to the
storage server (see above).
For the later tests involving concurrent backups, another Proliant 5000 similar to the above was brought
in to serve as a second database server.
Two other machines were also configured as database servers,
with the following hardware:
Compaq Proliant 2500 Server with 1 P6/200 processor board.
1 Compaq SMART-2 Array PCI controller (C875).
1 Compaq External Storage cabinet with 4 Fast-Wide disk drives.
1 Compaq Integrated Netelligent 10/100 TX PCI card.
Network: