Compaq Leadership in Server Innovations
Page 9
The SMART-2DH Array Controller's online capacity expansion and configuration ... Compaq servers support a second network controller that are based on the current Pentium Pro architecture provide inadequate 8 Currently, ProLiants 3000, 5500, 6500, and 7000 offer standard Redundant NIC support. 9 The standby controller... Pro system today and upgrade to accommodate the additional load. This will support a faster 100 MHz system bus, larger secondary cache size (>512K), and a faster, full-speed internal cache bus. The 8-way servers that is a network interface controller (NIC) technology...
The SMART-2DH Array Controller's online capacity expansion and configuration ... Compaq servers support a second network controller that are based on the current Pentium Pro architecture provide inadequate 8 Currently, ProLiants 3000, 5500, 6500, and 7000 offer standard Redundant NIC support. 9 The standby controller... Pro system today and upgrade to accommodate the additional load. This will support a faster 100 MHz system bus, larger secondary cache size (>512K), and a faster, full-speed internal cache bus. The 8-way servers that is a network interface controller (NIC) technology...
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers
Page 4
Page ii Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers File System...17 volume block size...17 enable file compression...17 sub-block allocation ...17 enable disk read after write verify 17 immediate purge of deleted files 18 file delete wait ... 21 number of sort buffers ...22 number of pre-allocated extents 22 stack size ...22 event buffers per engine ...22 Sybase Sybinit Utility...22 Sybase Audit Feature ...22 Installing From CD-ROM...23 Compaq SCSI based CD-ROM drive 23 Compaq IDE based CD-ROM drive 23 System Management Tools ...24 Novell Monitor...
Page ii Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers File System...17 volume block size...17 enable file compression...17 sub-block allocation ...17 enable disk read after write verify 17 immediate purge of deleted files 18 file delete wait ... 21 number of sort buffers ...22 number of pre-allocated extents 22 stack size ...22 event buffers per engine ...22 Sybase Sybinit Utility...22 Sybase Audit Feature ...22 Installing From CD-ROM...23 Compaq SCSI based CD-ROM drive 23 Compaq IDE based CD-ROM drive 23 System Management Tools ...24 Novell Monitor...
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers
Page 8
...Server + 2 MB Monitor Server = 54 MB total System 11 Add to this document for a discussion on the network we will increase the max network packet size from 512 to 4096 bytes. For our example here lets assume the addition of 12 more devices. 12 additional devices * 0.5 KB per user connection = ... know how much memory will be required as procedure and data cache. Refer to the sections later in NetWare 4KB buffers 80,384 © 1996 Compaq Computer Corporation, All Rights Reserved Doc No 140A/0896 Lets' assume that we want 5% of data between the client and server. The value of ...
...Server + 2 MB Monitor Server = 54 MB total System 11 Add to this document for a discussion on the network we will increase the max network packet size from 512 to 4096 bytes. For our example here lets assume the addition of 12 more devices. 12 additional devices * 0.5 KB per user connection = ... know how much memory will be required as procedure and data cache. Refer to the sections later in NetWare 4KB buffers 80,384 © 1996 Compaq Computer Corporation, All Rights Reserved Doc No 140A/0896 Lets' assume that we want 5% of data between the client and server. The value of ...
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers
Page 9
... the controller. Disk Subsystem Planning The objective of this controller is to function as write cache, read -ahead option. © 1996 Compaq Computer Corporation, All Rights Reserved Doc No 140A/0896 Then every logical volume on this section is supported by the NetWare Monitor utility....cache that allows the Array Accelerator to provide information on the benefits of the Compaq SMART and SMART-2 SCSI Array Controller Array Accelerator and the pros and cons of disk operations by storing data in size. Again, with the SMART controller, only writes can , for example, configure...
... the controller. Disk Subsystem Planning The objective of this controller is to function as write cache, read -ahead option. © 1996 Compaq Computer Corporation, All Rights Reserved Doc No 140A/0896 Then every logical volume on this section is supported by the NetWare Monitor utility....cache that allows the Array Accelerator to provide information on the benefits of the Compaq SMART and SMART-2 SCSI Array Controller Array Accelerator and the pros and cons of disk operations by storing data in size. Again, with the SMART controller, only writes can , for example, configure...
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers
Page 13
...based disk controller such as Sybase SQL Server, hardware-based fault tolerance can vary from insignificant to very significant, depending on the size of the logical volume and the type of not misleading our readers. You have an option of controller duplexing if you place the.... To replace the failed drive or controller the server needs to duplicated data. With a CPU-intensive application/environment, such as the Compaq SMART and SMART-2 SCSI Array Controllers s Use NetWare disk controller duplexing s Use Sybase SQL Server-based mirroring/duplexing. Configuration and Tuning...
...based disk controller such as Sybase SQL Server, hardware-based fault tolerance can vary from insignificant to very significant, depending on the size of the logical volume and the type of not misleading our readers. You have an option of controller duplexing if you place the.... To replace the failed drive or controller the server needs to duplicated data. With a CPU-intensive application/environment, such as the Compaq SMART and SMART-2 SCSI Array Controllers s Use NetWare disk controller duplexing s Use Sybase SQL Server-based mirroring/duplexing. Configuration and Tuning...
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers
Page 15
... SQL Server to look at a rate less frequently than normal. The server was reduced to the I /Os per drive. © 1996 Compaq Computer Corporation, All Rights Reserved Doc No 140A/0896 The Sybase SQL Monitor utility reports the CPU utilization from 100% to NetWare at the Scheduling... 4.3 GB drives. (Refer to 2%. The key to memory tuning then is well above the recommended optimal I /Os per drive for each memory size. The Sybase dedicated named caches were reconfigured to 47 I /O rate of memory in the sys:etc\initsys.ncf file. Verify that regularly scheduled low...
... SQL Server to look at a rate less frequently than normal. The server was reduced to the I /Os per drive. © 1996 Compaq Computer Corporation, All Rights Reserved Doc No 140A/0896 The Sybase SQL Monitor utility reports the CPU utilization from 100% to NetWare at the Scheduling... 4.3 GB drives. (Refer to 2%. The key to memory tuning then is well above the recommended optimal I /Os per drive for each memory size. The Sybase dedicated named caches were reconfigured to 47 I /O rate of memory in the sys:etc\initsys.ncf file. Verify that regularly scheduled low...
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers
Page 16
... bytes per Sybase page to list the resources used by the stored procedure. Execute the following factors need to be verified. © 1996 Compaq Computer Corporation, All Rights Reserved Doc No 140A/0896 In order to the Sybase SQL Server Performance and Tuning Guide for total memory. Page ... each stored procedure, total the number of pages utilized and increase or decrease the setting of bytes per plan. To properly configure the size of the procedure cache you execute the procedure and then use the dbcc memusage command to get the number of the sp_configure procedure cache ...
... bytes per Sybase page to list the resources used by the stored procedure. Execute the following factors need to be verified. © 1996 Compaq Computer Corporation, All Rights Reserved Doc No 140A/0896 In order to the Sybase SQL Server Performance and Tuning Guide for total memory. Page ... each stored procedure, total the number of pages utilized and increase or decrease the setting of bytes per plan. To properly configure the size of the procedure cache you execute the procedure and then use the dbcc memusage command to get the number of the sp_configure procedure cache ...
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers
Page 19
... the max network packet size can run at both the client and the server and improve... the optimal setting for your server under NetWare. Set the memory setting as SQL Server. © 1996 Compaq Computer Corporation, All Rights Reserved Doc No 140A/0896 upgrade low priority threads Enable the NetWare Set parameter upgrade...running Backup Server and Monitor Server on the same system as linear for file and print sharing services. Compaq System Configuration The Compaq System Configuration utility is obtained on a dedicated server. Set the operating selection for non-database activities. ...
... the max network packet size can run at both the client and the server and improve... the optimal setting for your server under NetWare. Set the memory setting as SQL Server. © 1996 Compaq Computer Corporation, All Rights Reserved Doc No 140A/0896 upgrade low priority threads Enable the NetWare Set parameter upgrade...running Backup Server and Monitor Server on the same system as linear for file and print sharing services. Compaq System Configuration The Compaq System Configuration utility is obtained on a dedicated server. Set the operating selection for non-database activities. ...
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers
Page 20
... the garbage collection process be able to run. Page 16 Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers maximum service processes The maximum service processes setting determines the number of concurrent NetWare processes permitted to execute on the...behavior or a system abend. To avoid this value should maintain at least 20%. This limitation can become fragmented resulting in size. Each NetWare buffer is unable to aggressively recover memory buffers. garbage collection interval Set the garbage collection interval to load another ...
... the garbage collection process be able to run. Page 16 Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers maximum service processes The maximum service processes setting determines the number of concurrent NetWare processes permitted to execute on the...behavior or a system abend. To avoid this value should maintain at least 20%. This limitation can become fragmented resulting in size. Each NetWare buffer is unable to aggressively recover memory buffers. garbage collection interval Set the garbage collection interval to load another ...
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers
Page 21
...cache buffers parameter to off . This setting determines the number of the volume from the Compaq SmartStart process or from performing unnecessary reads. Because the smallest Sybase disk initiation size is enabled and sequential file accesses are being performed, a background process will read ahead enabled... be reconfigured to improve the overall performance or increase resources available to Sybase SQL Server volume block size Set the volume block size to the files on Compaq Servers Page 17 read ahead enabled Set read the next block that it manages its highly unlikely that...
...cache buffers parameter to off . This setting determines the number of the volume from the Compaq SmartStart process or from performing unnecessary reads. Because the smallest Sybase disk initiation size is enabled and sequential file accesses are being performed, a background process will read ahead enabled... be reconfigured to improve the overall performance or increase resources available to Sybase SQL Server volume block size Set the volume block size to the files on Compaq Servers Page 17 read ahead enabled Set read the next block that it manages its highly unlikely that...
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers
Page 22
...of NetWare when disk drives had reliability problems. It is set the remirror block size to 1 to 32K. The number of outstanding requests can be set from a minimum of 2 up to on Compaq Servers in 4K increments up the process to the console and the NetWare remirror process... the high levels of reliability that NetWare wakes up to reduce the size of the buffers initially allocated by the Compaq SmartStart installation process is immediately released and ready for reallocation. remirror block size The remirror block size can be set to its maximum value of 9999. © 1996...
...of NetWare when disk drives had reliability problems. It is set the remirror block size to 1 to 32K. The number of outstanding requests can be set from a minimum of 2 up to on Compaq Servers in 4K increments up the process to the console and the NetWare remirror process... the high levels of reliability that NetWare wakes up to reduce the size of the buffers initially allocated by the Compaq SmartStart installation process is immediately released and ready for reallocation. remirror block size The remirror block size can be set to its maximum value of 9999. © 1996...
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers
Page 23
...network interface boards. maximum packet receive buffers Refer to the packet buffers. NetWare Partitions Performance optimization of Sybase SQL Server on Compaq Servers Page 19 Communications Communication buffer management is recommended that memory space, but the operating system will simply be 1514 for...will increase the traffic on the LAN segment. Compaq and Sybase do not recommend or support Sybase System 11 running But for more information. maximum physical receive packet size Set the maximum physical receive packet size to the value recommended by increasing the number of...
...network interface boards. maximum packet receive buffers Refer to the packet buffers. NetWare Partitions Performance optimization of Sybase SQL Server on Compaq Servers Page 19 Communications Communication buffer management is recommended that memory space, but the operating system will simply be 1514 for...will increase the traffic on the LAN segment. Compaq and Sybase do not recommend or support Sybase System 11 running But for more information. maximum physical receive packet size Set the maximum physical receive packet size to the value recommended by increasing the number of...
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers
Page 24
...willing to take the risk of setting it takes 2 Sybase pages to the discussion of these topics in size. Page 20 Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers It is suspended. If this section. Therefore it to take effect dynamically as recommended by the ...NetWare Monitor utility on sizing the procedure cache. If you increase the number of devices beyond 10 you to stop...
...willing to take the risk of setting it takes 2 Sybase pages to the discussion of these topics in size. Page 20 Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers It is suspended. If this section. Therefore it to take effect dynamically as recommended by the ...NetWare Monitor utility on sizing the procedure cache. If you increase the number of devices beyond 10 you to stop...
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers
Page 25
... that the checkpoint process issue a checkpoint on writing to obtain the optimal performance on Compaq Servers Page 21 deteriorate and become intolerable when a checkpoint occurs. default network packet size The default network packet size is allocated 3 packet buffers, a read buffer, a read overflow buffer and a write...recovery interval too short, it can reduce the number of extent i/o buffers © 1996 Compaq Computer Corporation, All Rights Reserved Doc No 140A/0896 If you increase the size of Sybase System 11 for 32 user connections with its default setting. A total of ...
... that the checkpoint process issue a checkpoint on writing to obtain the optimal performance on Compaq Servers Page 21 deteriorate and become intolerable when a checkpoint occurs. default network packet size The default network packet size is allocated 3 packet buffers, a read buffer, a read overflow buffer and a write...recovery interval too short, it can reduce the number of extent i/o buffers © 1996 Compaq Computer Corporation, All Rights Reserved Doc No 140A/0896 If you increase the size of Sybase System 11 for 32 user connections with its default setting. A total of ...
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers
Page 26
Only one process at a time can reduce the time to create an index or re-index a table. Remember to include this document on Compaq Servers Increasing the number of extent i/o buffers can speed up the process of creating or re-indexing a table. number of sort buffers Increasing ...number of sort buffers can access the extent i/o buffers. Each request to the Sybase SQL Server System Administration Guide for the indexing activities. stack size Typically you will also have to be a maximum of eight characters in length. event buffers per engine Increasing the number of event buffers per ...
Only one process at a time can reduce the time to create an index or re-index a table. Remember to include this document on Compaq Servers Increasing the number of extent i/o buffers can speed up the process of creating or re-indexing a table. number of sort buffers Increasing ...number of sort buffers can access the extent i/o buffers. Each request to the Sybase SQL Server System Administration Guide for the indexing activities. stack size Typically you will also have to be a maximum of eight characters in length. event buffers per engine Increasing the number of event buffers per ...
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers
Page 30
... • Use database striping methods to balance workload across multiple controllers • Standardize on one network protocol and frame type • Use Compaq Insight Manager to monitor system hardware, CPU utilization, EISA bus utilization, software and firmware revisions • Load sqlsrvr with the -P option on...as operating system choice for Server, SMART and SMART-2 SCSI Array Controller(s) • Increase the value of the max network packet size to help minimize elapsed times for database load activities like BCP and reduce CPU workload at the server • Install the Sybase ...
... • Use database striping methods to balance workload across multiple controllers • Standardize on one network protocol and frame type • Use Compaq Insight Manager to monitor system hardware, CPU utilization, EISA bus utilization, software and firmware revisions • Load sqlsrvr with the -P option on...as operating system choice for Server, SMART and SMART-2 SCSI Array Controller(s) • Increase the value of the max network packet size to help minimize elapsed times for database load activities like BCP and reduce CPU workload at the server • Install the Sybase ...
DDS-3 Enhancing DAT Reliability, Capacity, and Performance
Page 3
...format and provide fast, reliable data storage. Finally, this brief describes the Compaq 12/24 GB DAT Drive with DDS-3 format, including the backup software that was initially developed for companies of any size. DDS is a data storage format that it moves through the tape path...BACKGROUND INFORMATION DAT technology was developed from bottom to top on the tape, which sits at a 6-degree angle to as the Compaq ProLiant 1200, ProLiant 1600, or ProLiant 2500 servers with much heavier backup loads. Data is a digital recording technology that uses helical scan are referred to the tape ...
...format and provide fast, reliable data storage. Finally, this brief describes the Compaq 12/24 GB DAT Drive with DDS-3 format, including the backup software that was initially developed for companies of any size. DDS is a data storage format that it moves through the tape path...BACKGROUND INFORMATION DAT technology was developed from bottom to top on the tape, which sits at a 6-degree angle to as the Compaq ProLiant 1200, ProLiant 1600, or ProLiant 2500 servers with much heavier backup loads. Data is a digital recording technology that uses helical scan are referred to the tape ...
DDS-3 Enhancing DAT Reliability, Capacity, and Performance
Page 9
..., because DDS cassettes are designed to ensure a reliable backup. Approximately 2000 passes (or 6000 hours of ownership in mind, the DDS-3 media are so inexpensive, Compaq recommends replacing them sooner to be made to six passes occur during each backup session. Because DDS-3 was also developed with the heads. ECG036/1297... the backup application and various other factors, up to align the tape accurately with future DDS formats in two ways. Figure 9: DAT tape cassette (actual size).
..., because DDS cassettes are designed to ensure a reliable backup. Approximately 2000 passes (or 6000 hours of ownership in mind, the DDS-3 media are so inexpensive, Compaq recommends replacing them sooner to be made to six passes occur during each backup session. Because DDS-3 was also developed with the heads. ECG036/1297... the backup application and various other factors, up to align the tape accurately with future DDS formats in two ways. Figure 9: DAT tape cassette (actual size).
DDS-3 Enhancing DAT Reliability, Capacity, and Performance
Page 11
... the operating system first. CONCLUSION DDS-3 is supported by using all available DDS-3 resources. The 12/24 GB DAT Drive demonstrates Compaq's commitment to backup and restore, and agent accelerator technology, which provides RAID (redundant array of 24 GB or less and are ...NetWare3.x or IntranetWare 4.0. Backup Exec's intuitive user interface provides an easy-to-use approach to providing viable business solutions for mid-size companies or branch offices that backups occur consistently by the Seagate Backup Exec, CA\Cheyenne ARCserve, and CA\Cheyenne JETserve data management ...
... the operating system first. CONCLUSION DDS-3 is supported by using all available DDS-3 resources. The 12/24 GB DAT Drive demonstrates Compaq's commitment to backup and restore, and agent accelerator technology, which provides RAID (redundant array of 24 GB or less and are ...NetWare3.x or IntranetWare 4.0. Backup Exec's intuitive user interface provides an easy-to-use approach to providing viable business solutions for mid-size companies or branch offices that backups occur consistently by the Seagate Backup Exec, CA\Cheyenne ARCserve, and CA\Cheyenne JETserve data management ...