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

Chart 2 - Throughput Variance with Block Size & Data Patterns, Single Tape Device Dump.

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 21 highlights

Compaq Backup and Recovery for Microsoft SQL Server 6.x Chart 2 - Throughput Variance with Block Size & Data Patterns Page 21 The above discussion is relevant to the subject of this paper in helping to explain performance differences that may be seen between versions of SQL Server. The blocking factor scheme used in SQL Server 6.0 was improved in SQL Server version 6.5 specifically for DLT drives. Whereas SQL Server 6.0 used an 8KB block size, version 6.5 now uses a much larger block size of 64KB.25 Furthermore, 6.5 uses variable block mode, in which only one block is sent to (or received from) the drive with each data transfer, but the size of the block can be varied during the dump (or load) operation. SQL Server 6.5 does not vary the block size though, so that the 64KB block is always used, thus providing for optimal performance with the DLT Tape drives.26 The advantages of this scheme will become apparent in the later section entitled Single Tape Device Dump. 25 SQL Server versions prior to 6.0 would use a hard-coded block size of 512 bytes, which had serious performance repercussions in the case of DLT tape drives. As a result, Compaq recommends that DLT drives not be used with these earlier (i.e: version 4.21x) SQL Servers. 512 byte blocks work fine for DAT and QIC drives. 26 Exceptions are when writing headers, trailers, or file-marks to the tape, where the size of the data sent may be less. 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
21
1997 Compaq Computer Corporation, All Rights Reserved
Doc No 444A/0797
Chart 2 - Throughput Variance with Block Size & Data Patterns
The above discussion is relevant to the subject of this paper in helping to explain performance
differences that may be seen between versions of SQL Server.
The blocking factor scheme used in
SQL Server 6.0 was improved in SQL Server version 6.5 specifically for DLT drives.
Whereas SQL
Server 6.0 used an 8KB block size, version 6.5 now uses a much larger block size of 64KB.
25
Furthermore, 6.5 uses
variable block mode
, in which only one block is sent to (or received from) the
drive with each data transfer, but the size of the block can be varied during the dump (or load)
operation.
SQL Server 6.5 does not vary the block size though, so that the 64KB block is always used,
thus providing for optimal performance with the DLT Tape drives.
26
The advantages of this scheme
will become apparent in the later section entitled
Single Tape Device Dump.
25
SQL Server versions prior to 6.0 would use a hard-coded block size of 512 bytes, which had serious
performance repercussions in the case of DLT tape drives.
As a result, Compaq recommends that DLT drives
not be used with these earlier (i.e: version 4.21x) SQL Servers.
512 byte blocks work fine for DAT and QIC
drives.
26
Exceptions are when writing headers, trailers, or file-marks to the tape, where the size of the data sent may be
less.