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

Configuration and Tuning of Sybase System 11 for Microsoft Windows NT on Compaq Servers Page 7 Y Reliability and recovery procedures are very similar to those of Windows NT fault tolerance. Your system remains running, but you will have to take the system off-line and upon a failed drive replacement you will have to manually remirror the devices. Y Again, mirroring through Sybase SQL Server induces an additional processing overhead on the system, resulting in a lower performance. For further information on Compaq RAID technology with Sybase SQL Server, refer to the following document: Configuring Compaq RAID Technology for Database Servers, February 1994, Document Number 267A/0294 FAT vs. NTFS Our testing showed only a slight difference in performance between FAT and NTFS file systems in a Sybase SQL Server environment. It is recommended that NTFS be used for both transaction log and database files for optimal performance, ease of disk management and data recoverability. Be aware that the Windows NT C2-level security features are only available on NTFS volumes. A complete list of advantages and disadvantages of FAT and NTFS file systems is available in the Microsoft Windows NT, Concepts and Planning Guide. Compaq System Configuration Utility Considerations Compaq System Configuration5 utility allows you to select the operating system for each Compaq SMART and SMART-2 SCSI Array controller. This selection allows the configuration utility to choose the best physical characteristics, such as striping block size, number of sectors per track, etc., for a given environment. Once you choose the MS Windows NT option as your selection for the operating system, you will be presented with the following options: YMS Windows NT 3.1  Choose this option only if you're running Microsoft Windows NT version 3.1. YMS Windows NT 3.5x  This option provides with best performance under Microsoft Windows NT version 3.5x. YMS Windows NT 3.5x - Maximum Boot Size  This option provides you with maximum boot partition size available under Microsoft Windows NT version 3.5x. The partition limitations outlined below still apply. WARNING: Changing controller characteristics such as the operating system through the Compaq System Configuration utility causes the controller to apply different physical characteristics to the drive array. As a result, you may lose data on such a drive array. If you have existing data on such a drive array, and need to change these controller characteristics, we strongly suggest you back up your data completely before doing so. Current partition limitations are as follows: YWindows NT 3.5x limit the boot partition to 4GB, regardless of the file system. 5 Make sure you obtain the latest available version of Compaq System Configuration Utility from Compaq. © 1996 Compaq Computer Corporation, All Rights Reserved Doc No 143A/0596