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

Chart 16 - Load Database: Reinitialization Performance based on Disk Array Type

Page 5 highlights

Compaq Backup and Recovery for Microsoft SQL Server 6.x Page 5 Chart 1 - Data Compression Ratios and Performance 18 Chart 2 - Throughput Variance with Block Size & Data Patterns 21 Chart 3 - Dump to Single Tape Device ...34 Chart 4 - Null Device Dumps : Reading Data from Disk Arrays 36 Chart 5 - Striped Dumps to Disk Arrays ...38 Chart 6 - Striped Dumps to 15/30 DLT Tape Drives 40 Chart 7 - Striped Dumps to 35/70 DLT Tape Drives 41 Chart 8 - Concurrent Dumps of Multiple Databases to 35/70 DLT Tape Drives 43 Chart 9 - Database Backup to 15/30 DLT Tape RAID Using ARCserve 45 Chart 10 - Database Backup to 35/70 DLT Tape RAID Using ARCserve 46 Chart 11 - Backup of One Server Across Single 10BaseT Segment 50 Chart 12 - Backup of One Server Across Single 100BaseTX Segment 51 Chart 13 - Concurrent Backup of Multiple Servers Across Multiple 10BaseT Segments 54 Chart 14 - Concurrent Backup of Multiple Servers Across Single 100BaseTX Segment 56 Chart 15 - Load Database: Data Restore Performance based on Disk Array Type 72 Chart 16 - Load Database: Page Reinitialization Performance based on Disk Array Type 73 Table 1 - Tape Cartridge Support Matrix ...15 Table 2 - Number of DLT Drives Needed for Desired Throughput 59 Table 3 - Online Dump of Active Database with SQL Server 63 Table 4 - Online Dump of Active Database with ARCserve 63 Table 5 - Online Dump of Inactive Database with SQL Server 64 Table 6 - Online Dump of Inactive Database with ARCserve 65 Table 7 - Max Dump Throughput for Small Arrays 68 Table 8 - Max Transaction Log Dump Throughput with Various Commands 68 Figure 1 - Network Layout: Backup of 4 Servers Across 4 Dedicated 10Base-T Segments 53 Figure 2 - Network Layout: Backup of 4 Servers Across 1 Shared 100Base-T Segment 55 Figure 3 - SQL Server Backup with Database Activity 62 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
5
1997 Compaq Computer Corporation, All Rights Reserved
Doc No 444A/0797
Chart 1 - Data Compression Ratios and Performance
........................................................................................
18
Chart 2 - Throughput Variance with Block Size & Data Patterns
......................................................................
21
Chart 3 - Dump to Single Tape Device
.............................................................................................................
34
Chart 4 - Null Device Dumps : Reading Data from Disk Arrays
.......................................................................
36
Chart 5 - Striped Dumps to Disk Arrays
...........................................................................................................
38
Chart 6 - Striped Dumps to 15/30 DLT Tape Drives
.........................................................................................
40
Chart 7 - Striped Dumps to 35/70 DLT Tape Drives
.........................................................................................
41
Chart 8 - Concurrent Dumps of Multiple Databases to 35/70 DLT Tape Drives
................................................
43
Chart 9 - Database Backup to 15/30 DLT Tape RAID Using ARCserve
...........................................................
45
Chart 10 - Database Backup to 35/70 DLT Tape RAID Using ARCserve
.........................................................
46
Chart 11 - Backup of One Server Across Single 10BaseT Segment
..................................................................
50
Chart 12 - Backup of One Server Across Single 100BaseTX Segment
..............................................................
51
Chart 13 - Concurrent Backup of Multiple Servers Across Multiple 10BaseT Segments
...................................
54
Chart 14 - Concurrent Backup of Multiple Servers Across Single 100BaseTX Segment
...................................
56
Chart 15 - Load Database: Data Restore Performance based on Disk Array Type
.............................................
72
Chart 16 - Load Database: Page Reinitialization Performance based on Disk Array Type
.................................
73
Table 1 - Tape Cartridge Support Matrix
..........................................................................................................
15
Table 2 - Number of DLT Drives Needed for Desired Throughput
...................................................................
59
Table 3 - Online Dump of Active Database with SQL Server
...........................................................................
63
Table 4 - Online Dump of Active Database with ARCserve
..............................................................................
63
Table 5 - Online Dump of Inactive Database with SQL Server
.........................................................................
64
Table 6 - Online Dump of Inactive Database with ARCserve
...........................................................................
65
Table 7 - Max Dump Throughput for Small Arrays
..........................................................................................
68
Table 8 - Max Transaction Log Dump Throughput with Various Commands
...................................................
68
Figure 1 – Network Layout: Backup of 4 Servers Across 4 Dedicated 10Base-T Segments
..............................
53
Figure 2 – Network Layout: Backup of 4 Servers Across 1 Shared 100Base-T Segment
...................................
55
Figure 3 - SQL Server Backup with Database Activity
.....................................................................................
62