HP ProLiant 2500 Configuration and Tuning of Sybase System 11 for Microsoft Wi
HP ProLiant 2500 Manual
View all HP ProLiant 2500 manuals
Add to My Manuals
Save this manual to your list of manuals |
HP ProLiant 2500 manual content summary:
- HP ProLiant 2500 | Configuration and Tuning of Sybase System 11 for Microsoft Wi - 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 - HP ProLiant 2500 | Configuration and Tuning of Sybase System 11 for Microsoft Wi - Page 2
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 Patent and Trademark Office. ProLiant, ProSignia, Qvision, and Systempro/XL are trademarks of Compaq Computer Corporation. Microsoft, MS - HP ProLiant 2500 | Configuration and Tuning of Sybase System 11 for Microsoft Wi - Page 3
Backup Domain Controller or Server 1 System Processor Planning ...2 UniProcessor and MultiProcessor Support from Compaq 2 Processor Scalability and Optimization 9 Optimizing Windows NT & SQL Server Operations 9 Unnecessary Services ...10 CPU Performance Monitor Objects and Their Meaning - HP ProLiant 2500 | Configuration and Tuning of Sybase System 11 for Microsoft Wi - Page 4
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 SSD for Windows NT, and Sybase System 11 for Windows NT - HP ProLiant 2500 | Configuration and Tuning of Sybase System 11 for Microsoft Wi - Page 5
provide shared 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 ProLiant Family of Servers and to provide some - HP ProLiant 2500 | Configuration and Tuning of Sybase System 11 for Microsoft Wi - Page 6
Compaq Servers Page 3 The following chart shows the performance increases when adding additional processor boards to a ProLiant the \hkey_local\machine\system\currentcontrolset\services\lanmanserver\parameters entry to Edit, Compaq servers. Initial Memory The Sybase SQL Server Installation Guide - HP ProLiant 2500 | Configuration and Tuning of Sybase System 11 for Microsoft Wi - Page 7
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 Server, Concepts and Planning Guide s Sybase SQL Server, System Administration Guide Array Accelerator: Its Function and - HP ProLiant 2500 | Configuration and Tuning of Sybase System 11 for Microsoft Wi - Page 8
as possible. This technique requires careful tuning considerations for the Compaq SMART and SMART-2 SCSI Array Controllers. In some environments can help alleviate this problem. Y The housekeeper, if enabled, waits until it detects idle time in the Sybase SQL Server then begins to write dirty - HP ProLiant 2500 | Configuration and Tuning of Sybase System 11 for Microsoft Wi - Page 9
to Configuring Compaq RAID Technology for Database Servers white paper, published by Compaq (Document Guide for guidelines on choosing which devices to mirror. Y You have an option of controller duplexing, if you place the mirrored device on a different disk controller. Y Sybase SQL Server supports - HP ProLiant 2500 | Configuration and Tuning of Sybase System 11 for Microsoft Wi - Page 10
drive replacement you will have to manually remirror the devices. Y Again, mirroring through Sybase SQL Server induces an additional processing overhead on on Compaq RAID technology with Sybase SQL Server, refer to the following document: Configuring Compaq RAID Technology for Database Servers, - HP ProLiant 2500 | Configuration and Tuning of Sybase System 11 for Microsoft Wi - Page 11
Windows NT on Compaq Servers YNon-bootable partitions server. When possible, move these services to another Windows NT server on the network. Refer to the Sybase SQL Server, Installation Guide for Microsoft Windows NT for information on how to configure the server and the clients to support - HP ProLiant 2500 | Configuration and Tuning of Sybase System 11 for Microsoft Wi - Page 12
System 11 for Microsoft Windows NT on Compaq Servers Page 9 For larger data transfers between the clients and the server, such as BCP loads and unloads, heavily loaded system. Refer to the Microsoft Windows NT Server, System Guide for more detail on this subject. Performance Monitoring and Tuning - HP ProLiant 2500 | Configuration and Tuning of Sybase System 11 for Microsoft Wi - Page 13
Compaq Servers If the server is dedicated to Sybase SQL Server, change the setting to Best Foreground Application Response Time. If the server is not dedicated to Sybase SQL Server and is being used to run other application programs or printer services Windows NT Server, System Guide for a - HP ProLiant 2500 | Configuration and Tuning of Sybase System 11 for Microsoft Wi - 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 gain - HP ProLiant 2500 | Configuration and Tuning of Sybase System 11 for Microsoft Wi - Page 15
Tuning of Sybase System 11 for Microsoft Windows NT on Compaq Servers Object: Memory Counter: Page Faults/sec This counter monitors sp_helpcache to verify the cache binding Please refer to the Sybase SQL Server System Administration Guide for more in depth information on the tuning of the LMM. - HP ProLiant 2500 | Configuration and Tuning of Sybase System 11 for Microsoft Wi - Page 16
Windows NT on Compaq Servers Page 13 Dbcc Memusage Dbcc Memusage reports the following very useful information: Y Sybase SQL Server memory allocation at what is not in the Sybase SQL Server cache. Refer to the Sybase SQL Server System Administration Guide for more detailed information on how to - HP ProLiant 2500 | Configuration and Tuning of Sybase System 11 for Microsoft Wi - Page 17
Sybase System 11 for Microsoft Windows NT on Compaq Servers transaction rate, Sybase SQL Server would perform the checkpoint approximately every 2 minutes. 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 - HP ProLiant 2500 | Configuration and Tuning of Sybase System 11 for Microsoft Wi - Page 18
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 Compaq SMART or SMART-2 SCSI Array Controller with the Array Accelerator enabled and RAID-1 via hardware. Compaq Insight Manager © 1996 Compaq - HP ProLiant 2500 | Configuration and Tuning of Sybase System 11 for Microsoft Wi - 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 - HP ProLiant 2500 | Configuration and Tuning of Sybase System 11 for Microsoft Wi - 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 Server, Secondary WINS Server or Domain Name Service Server • dedicate the server to Sybase SQL Server, use other servers for file and print services - HP ProLiant 2500 | Configuration and Tuning of Sybase System 11 for Microsoft Wi - Page 21
and Tuning of Sybase System 11 for Microsoft Windows NT on Compaq Servers • use the Windows NT Performance Monitor to monitor CPU, memory to determine system bottlenecks • use stored procedures to reduce network traffic and server CPU load • increase size of TDS packets to speed up activities and - HP ProLiant 2500 | Configuration and Tuning of Sybase System 11 for Microsoft Wi - Page 22
of Sybase System 11 for Microsoft Windows NT on Compaq Servers User Registration/Evaluation Form Please fill out and Open Server Y IBM OS/2 Y Other: RDBMS Y Sybase System 11 Y Microsoft SQL Server Y Oracle 7 Y Other: YYYY Processing Type On-Line Transaction Processing Decision Support Batch
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