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

Chart 13 - Concurrent Backup of Multiple Servers Across Multiple 10BaseT Segments

Get Compaq ProLiant 1000 PDF manuals and user guides View all Compaq ProLiant 1000 manuals
Add to My Manuals
Save this manual to your list of manuals

Page 54 highlights

Compaq Backup and Recovery for Microsoft SQL Server 6.x Page 54 Chart 13 - Concurrent Backup of Multiple Servers Across Multiple 10BaseT Segments As can be seen, near perfect scalability was achieved in going from 1 to 4 concurrent backup jobs. Whether backing up 1 server or 4 servers, the amount of time was the same, thus yielding 4x overall throughput increase at the destination server. CPU use at the storage server also increased linearly, but did not exceed a 20% average. Network utilization on each of the segments involved was about the same - roughly 76%. Thus, we can conclude that the simultaneous backup of servers across multiple segments is a good way to increase the productivity of your storage server and reduce overall backup time. It should be noted that more than four such concurrent backup jobs could feasibly be performed with the addition of still more tape drives and NICs or dual-port NICs such as the Compaq Netelligent Dual 10/100TX74. The concurrent backup scheme is continued here, with 100 Mbit technology. There is however, a key difference in the way the network is setup, versus the 10 Mbit tests. Earlier we saw that the 100BaseTX network wire had significant bandwidth remaining while performing a single remote backup. Thus, here a single 100 Mbit 'segment' will be used to backup more than one server in parallel. In our environment, this was accomplished by connecting the 4 database servers to a single 100Base-TX repeater (hub), and then connecting 2 of the network cards on the storage server to that same repeater. TCP/IP addressing was used to create two separate logical subnets within the single physical segment, so that 2 of the database systems could communicate with one of the NICs in the storage server and the remaining 2 database systems could communicate with the other NIC in the server. Thus we maintained a 2:1 ratio between systems to be backed up vs. network cards in the storage server, although all data transfers occur over the same wire. The reason for having more than one NIC on the 74 Our configuration did not include performance testing with the Compaq Netelligent Dual 10/100TX PCI UTP controller.

  • 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
54
Chart 13 - Concurrent Backup of Multiple Servers Across Multiple 10BaseT Segments
As can be seen,
near perfect scalability was achieved in going from 1 to 4 concurrent backup jobs
.
Whether backing up 1 server or 4 servers, the amount of time was the same, thus yielding 4x overall
throughput increase at the destination server.
CPU use at the storage server also increased linearly, but
did not exceed a 20% average.
Network utilization on each of the segments involved was about the
same - roughly 76%.
Thus, we can conclude that the simultaneous backup of servers across multiple
segments is a good way to increase the productivity of your storage server and reduce overall backup
time.
It should be noted that more than four such concurrent backup jobs could feasibly be performed with
the addition of still more tape drives and NICs or dual-port NICs such as the Compaq Netelligent Dual
10/100TX
74
.
The concurrent backup scheme is continued here, with 100 Mbit technology.
There is however, a key
difference in the way the network is setup, versus the 10 Mbit tests.
Earlier we saw that the 100Base-
TX network wire had significant bandwidth remaining while performing a single remote backup.
Thus,
here
a single 100 Mbit ‘segment’ will be used to backup more than one server in parallel
.
In our
environment, this was accomplished by connecting the 4 database servers to a single 100Base-TX
repeater (hub), and then connecting 2 of the network cards on the storage server to that same repeater.
TCP/IP addressing was used to create two separate logical subnets within the single physical segment,
so that 2 of the database systems could communicate with one of the NICs in the storage server and the
remaining 2 database systems could communicate with the other NIC in the server.
Thus we
maintained a 2:1 ratio between systems to be backed up vs. network cards in the storage server,
although all data transfers occur over the same wire.
The reason for having more than one NIC on the
74
Our configuration did not include performance testing with the Compaq Netelligent Dual 10/100TX PCI UTP
controller.