Compaq ProLiant 1000 Configuration and Tuning of Sybase System 11 for Microsof - Page 18

Configuration and Tuning of Sybase System 11 for Microsoft Windows NT on Compaq Servers Page 15 transfers per logical volume. To calculate number of disk transfers per second per drive, you must divide the Disk Transfers/sec value by the number of drives in the logical volume. Use the following guidelines when optimizing the drive subsystem. You should not have more I/O requests (disk transfers) per second per drive than the values in the table below. 1.0GB drives 2.0GB drives 4.0 GB drives (Max I/Os per Second) (Max I/Os per Second) (Max I/Os per Second) Sequential Writes (Transaction Log) Random Reads/Writes (Database Access) ≈150 ≈30-40 ≈160 ≈50 ≈200 ≈60-65 If your values are much higher than those suggested in the above table, you should increase the throughput of your disk subsystem by adding more drives or using faster drives. Sybase SQL Server Runserver Command File and the Windows NT Registry The recommended method for altering the startup parameters for Sybase is through the Sybase Configuration Server Utility. But because there are other methods of editing the Runserver file and the Windows NT Registry mainly Edit and Regedt32, an inconsistency may exist between the two. When this happens the manner in which Sybase runs is now predictable. If you start Sybase SQL Server via the Services Manager or the Control Panel, Services menu, the Registry values are utilized. If you manually start Sybase SQL Server at the DOS prompt or use the Servername.bat file then the parameters specified will take effect. If the Registry has an entry for a parameter not specified at the DOS prompt or the Servername.bat file then the Registry parameter value(s) will be used as the default. The Sybase Server Configuration Utility does not verify or resolve any inconsistencies between the Runserver file and the Registry. You will need to manually check that the command line parameters specified in the C:\SQL11\install directory Servername.bat file match the Registry entries for arg0-argx under the heading of HKEY_LOCAL_MACHINE, SOFTWARE, Sybase, Server, Servername, Parameters. In the Servername.bat file, if multiple entries are listed for the same parameter, the last parameter is the one utilized. In the Registry, if multiple entries are listed for the same parameter, the arg with the highest number associated with it is the one utilized. This also applies to the entries for Backup Server and Monitor Server. Sybaudit Performance Considerations To avoid having the Sybase Audit database file becoming the limiting factor on your Sybase SQL Server it is suggested that it be treated in the same manner as a transaction log file. Place the Sybase Audit database files on a separate disk partition, use Compaq SMART or SMART-2 SCSI Array Controller with the Array Accelerator enabled and RAID-1 via hardware. Compaq Insight Manager © 1996 Compaq Computer Corporation, All Rights Reserved Doc No 143A/0596