Compaq ProLiant 1000 Configuration and Tuning of Sybase System 11 for Microsof
Compaq ProLiant 1000 Manual
View all Compaq ProLiant 1000 manuals
Add to My Manuals
Save this manual to your list of manuals |
Compaq ProLiant 1000 manual content summary:
- Compaq ProLiant 1000 | 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 ProLiant 1000 | 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 ProLiant 1000 | Configuration and Tuning of Sybase System 11 for Microsof - Page 3
and MultiProcessor Support from Compaq 2 Processor Operations 9 Unnecessary Services ...10 CPU Performance Monitor Objects and 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 ProLiant 1000 | 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 ProLiant 1000 | 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 ProLiant 1000 | 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 ProLiant 1000 | 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 ProLiant 1000 | 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 ProLiant 1000 | Configuration and Tuning of Sybase System 11 for Microsof - Page 9
the applications. With a CPU-intensive application/environment, such Compaq RAID Technology for Database Servers white paper, published by Compaq SQL Server, System Administration Guide for guidelines on choosing which disk controller. Y Sybase SQL Server supports both serial and noserial write mode - Compaq ProLiant 1000 | 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 ProLiant 1000 | 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 ProLiant 1000 | 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 ProLiant 1000 | Configuration and Tuning of Sybase System 11 for Microsof - Page 13
Windows NT on Compaq Servers If to run other application programs or printer services then change the setting to Foreground and and Microsoft Windows NT Server, System Guide for a more detailed discussion. The engines setting, determines how many CPU resources should be dedicated exclusively to - Compaq ProLiant 1000 | Configuration and Tuning of Sybase System 11 for Microsof - Page 14
Sybase System 11 for Microsoft Windows NT on Compaq Servers Page 11 CPU Performance Monitor Objects and Their Meaning This section Counter: % Processor Time The % Processor Time counter monitors the percent of CPU utilization of all threads (both Privileged Mode and User Mode threads) running on - Compaq ProLiant 1000 | 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 ProLiant 1000 | 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 ProLiant 1000 | 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 ProLiant 1000 | 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 ProLiant 1000 | 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 ProLiant 1000 | Configuration and Tuning of Sybase System 11 for Microsof - Page 20
Server or Domain Name Service Server • dedicate the server to Sybase SQL Server, use other servers for file and print services • use SMART and SMART Throughput for File Sharing • use Compaq Insight Manager to monitor system hardware, CPU and EISA bus utilization © 1996 Compaq Computer Corporation - Compaq ProLiant 1000 | 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 set Sybase user connections higher than - Compaq ProLiant 1000 | Configuration and Tuning of Sybase System 11 for Microsof - Page 22
Y Other: YYYY Processing Type On-Line Transaction Processing Decision Support Batch Processing Other: Please indicate the type of information you Return to: Database Engineering Compaq Computer Corporation MailCode 090803 20555 SH 249 Houston, Texas 77070 © 1996 Compaq Computer Corporation, All
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