Compaq ProSignia 300 Configuration and Tuning of Sybase System 11 for Microsof
Compaq ProSignia 300 Manual
View all Compaq ProSignia 300 manuals
Add to My Manuals
Save this manual to your list of manuals |
Compaq ProSignia 300 manual content summary:
- Compaq ProSignia 300 | Configuration and Tuning of Sybase System 11 for Microsof - Page 1
Configuration and Tuning of Sybase System 11 for Microsoft Windows NT on Compaq Servers White Paper Prepared By Database Engineering Compaq Computer Corporation May 1996 - Compaq ProSignia 300 | Configuration and Tuning of Sybase System 11 for Microsof - Page 2
by copyright. No part of this publication may be photocopied or reproduced in any form without prior written consent from Compaq Computer Corporation. The software described in this guide is furnished under a license agreement or non disclosure agreement. The software may be used or copied only in - Compaq ProSignia 300 | Configuration and Tuning of Sybase System 11 for Microsof - Page 3
and MultiProcessor Support from Compaq 2 Processor SQL Server Operations 9 Unnecessary Services ...10 CPU Performance Monitor File and the Windows NT Registry 15 Sybaudit Performance Considerations 15 Compaq Insight Manager ...15 Conclusion ...17 Check List of Recommendations 17 © 1996 Compaq - Compaq ProSignia 300 | Configuration and Tuning of Sybase System 11 for Microsof - Page 4
might differ between releases, we strongly encourage you to upgrade to the latest available versions of Windows NT, Windows NT Software Support Diskette (NT SSD) from Compaq, and Sybase SQL Server. The reader should already be familiar with the installation and reconfiguring of Windows NT Server - Compaq ProSignia 300 | Configuration and Tuning of Sybase System 11 for Microsof - Page 5
file and print services. For additional information on Domain Controllers, refer to the Windows NT Server, Concepts and Planning Guide. System Processor Planning The objective of this section is to outline the configurations of the Compaq -processor support files2 by running the SETUP.CMD file on the - Compaq ProSignia 300 | Configuration and Tuning of Sybase System 11 for Microsof - Page 6
the Windows NT Registry. Edit the \hkey_local\machine\system\currentcontrolset\services\lanmanserver\parameters entry to Edit, Add Value, RawWorkItems REG_DWORD = regarding the system memory on Compaq servers. Initial Memory The Sybase SQL Server Installation Guide for Microsoft Windows NT states - Compaq ProSignia 300 | Configuration and Tuning of Sybase System 11 for Microsof - Page 7
and Windows NT system level files. Additional information on disk subsystem configuration and Compaq drive array technology can be found: s Configuring Compaq RAID Technology for Database Servers, Compaq TechNote, P/N 184206-001 s Microsoft Windows NT Server, System Guide s Microsoft Windows NT - Compaq ProSignia 300 | Configuration and Tuning of Sybase System 11 for Microsof - Page 8
at the controller. Proper tuning of the housekeeper can help alleviate this problem. Y The housekeeper, if enabled, waits until it detects idle time protecting your data: s Use a RAID-based disk controller such as the Compaq SMART and SMART-2 SCSI Array Controllers s Use Windows NT-based RAID s - Compaq ProSignia 300 | Configuration and Tuning of Sybase System 11 for Microsof - Page 9
to Configuring Compaq RAID Technology for Database Servers white paper, published by Compaq (Document to Sybase SQL Server, System Administration Guide for guidelines on choosing which devices to different disk controller. Y Sybase SQL Server supports both serial and noserial write mode of mirroring. - Compaq ProSignia 300 | Configuration and Tuning of Sybase System 11 for Microsof - Page 10
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 file systems is available in the Microsoft Windows NT, Concepts and Planning Guide. Compaq System Configuration Utility Considerations Compaq - Compaq ProSignia 300 | Configuration and Tuning of Sybase System 11 for Microsof - Page 11
Compaq Servers YNon-bootable partitions to be formatted with FAT file system are limited to 4GB. Nonbootable partitions to be formatted with NTFS file other hand decision support systems (DSS) services to another Windows NT server on the network. Refer to the Sybase SQL Server, Installation Guide - Compaq ProSignia 300 | Configuration and Tuning of Sybase System 11 for Microsof - Page 12
Windows NT on Compaq Servers Page 9 Windows NT and Sybase SQL Server support multiple network protocols. From the the Microsoft Windows NT Server, System Guide for more detail on this subject. Performance to the database in an ASCII format data file of the name, servername.cfg. This makes it possible - Compaq ProSignia 300 | Configuration and Tuning of Sybase System 11 for Microsof - Page 13
for Microsoft Windows NT on Compaq Servers If the server being used to run other application programs or printer services then change the setting to Foreground and Background Applications Windows NT and Microsoft Windows NT Server, System Guide for a more detailed discussion. The tunable parameter - Compaq ProSignia 300 | Configuration and Tuning of Sybase System 11 for Microsof - Page 14
Configuration and Tuning of Sybase System 11 for Microsoft Windows NT on Compaq Servers Page 11 CPU Performance Monitor Objects and Their Meaning This section provides you with some important Performance Monitor objects that you can monitor to - Compaq ProSignia 300 | Configuration and Tuning of Sybase System 11 for Microsof - Page 15
11 for Microsoft Windows NT on Compaq Servers Object: Memory Counter: Page size of the database object 2. Edit the server.cfg file to establish the dedicated named cache object for the Please refer to the Sybase SQL Server System Administration Guide for more in depth information on the tuning of - Compaq ProSignia 300 | Configuration and Tuning of Sybase System 11 for Microsof - Page 16
of Sybase System 11 for Microsoft Windows NT on Compaq Servers Page 13 Dbcc Memusage Dbcc Memusage reports the following in the Sybase SQL Server cache. Refer to the Sybase SQL Server System Administration Guide for more detailed information on how to use this feature. Procedure Cache The amount - Compaq ProSignia 300 | Configuration and Tuning of Sybase System 11 for Microsof - Page 17
Disk Transfers/sec counter monitors the rate of read and write operations on the disk. It is important to realize that if you have a Compaq SMART or SMART-2 SCSI Array controller and several drives allocated to a logical volume, this counter monitors the total number of disk 9The diskperf option - Compaq ProSignia 300 | Configuration and Tuning of Sybase System 11 for Microsof - Page 18
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 as a transaction log file. Place the Sybase Audit database files on a separate disk partition, use Compaq SMART or SMART-2 - Compaq ProSignia 300 | Configuration and Tuning of Sybase System 11 for Microsof - Page 19
System 11 for Microsoft Windows NT on Compaq Servers Use the Compaq Insight Manager to remotely monitor the health of the Compaq Server running Sybase SQL Server. Compaq Insight Manager can provide pre-failure warnings of potential hardware problems. This allows the scheduling of preventative - Compaq ProSignia 300 | Configuration and Tuning of Sybase System 11 for Microsof - Page 20
start • start with minimum of 32MB RAM • check revision levels of Compaq NT SSD files, update to latest revisions • when possible, use System Configuration Utility or Domain Name Service Server • dedicate the server to Sybase SQL Server, use other servers for file and print services • use SMART - Compaq ProSignia 300 | Configuration and Tuning of Sybase System 11 for Microsof - Page 21
Page 18 Configuration and Tuning of Sybase System 11 for Microsoft Windows NT on Compaq Servers • use the Windows NT Performance Monitor to monitor CPU, memory and disk utilization • enable diskperf only when necessary to monitor disk performance • do not - Compaq ProSignia 300 | Configuration and Tuning of Sybase System 11 for Microsof - Page 22
Sybase System 11 for Microsoft Windows NT on Compaq Servers User Registration/Evaluation Form Please fill out Server Y Oracle 7 Y Other: YYYY Processing Type On-Line Transaction Processing Decision Support Batch Processing Other: Please indicate the type of information you would like us to
Configuration and Tuning of Sybase System
11 for Microsoft Windows NT on Compaq
Servers
White Paper
________________________________________________________________
Prepared By
Database Engineering
Compaq Computer Corporation
May 1996