HP ProSignia 720 Configuration and Tuning of Sybase System 11 for Microsoft Wi
HP ProSignia 720 Manual
View all HP ProSignia 720 manuals
Add to My Manuals
Save this manual to your list of manuals |
HP ProSignia 720 manual content summary:
- HP ProSignia 720 | 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 ProSignia 720 | 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 ProSignia 720 | Configuration and Tuning of Sybase System 11 for Microsoft Wi - Page 3
Introduction...1 Planning and Installation...1 Domain Controller, Backup Domain Controller or Server 1 System Processor Planning ...2 UniProcessor and MultiProcessor Support from Compaq 2 Processor Scalability ...2 Memory Planning ...3 Initial Memory...3 Virtual Memory ...4 Disk Subsystem Planning - HP ProSignia 720 | 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 ProSignia 720 | 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 ProSignia 720 | Configuration and Tuning of Sybase System 11 for Microsoft Wi - Page 6
important considerations regarding the system memory on Compaq servers. Initial Memory The Sybase SQL Server Installation Guide for Microsoft Windows NT states the minimum system memory requirement for running Sybase SQL Server is 32 megabytes, which includes the memory requirements for Windows NT - HP ProSignia 720 | Configuration and Tuning of Sybase System 11 for Microsoft Wi - Page 7
are environment-specific. In the "Memory Utilization, Monitoring, and Optimization" section found later in this document, we provide suggestions on how to detect and correct low memory situations. Virtual Memory During the initial installation of Windows NT, a paging file is setup automatically on - HP ProSignia 720 | Configuration and Tuning of Sybase System 11 for Microsoft Wi - Page 8
technique requires careful tuning considerations for the Compaq SMART and SMART-2 SCSI Array Controllers. this problem. Y The housekeeper, if enabled, waits until it detects idle time in the Sybase SQL Server then begins environment. Therefore, we omitted supplying performance differences for the - HP ProSignia 720 | Configuration and Tuning of Sybase System 11 for Microsoft Wi - Page 9
refer to Configuring Compaq RAID Technology for Database Servers white paper, published by Compaq (Document Number 267A/0294) for a more complete discussion. 2. Windows NT-based RAID Y To take advantage of Windows NT-based fault tolerance, you need to have Windows NT Server installed. The current - HP ProSignia 720 | 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 ProSignia 720 | Configuration and Tuning of Sybase System 11 for Microsoft Wi - Page 11
of network traffic to this 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 a particular network protocol - HP ProSignia 720 | Configuration and Tuning of Sybase System 11 for Microsoft Wi - Page 12
Compaq Servers Page 9 For larger data transfers between the clients and the server memory used by the network handlers. Adjusting the protocol binding order of the Server, Network Bindings has no effect on the server NT Server, System Guide for requiring immediate processor attention. Once - HP ProSignia 720 | Configuration and Tuning of Sybase System 11 for Microsoft Wi - Page 13
of CPUs installed in your server, you will still be able to run Sybase SQL Server but your overall system performance will be severely impacted. Unnecessary Services You may turn off or stop all unnecessary services running on the server, since they add a processing overhead on the system processor - HP ProSignia 720 | Configuration and Tuning of Sybase System 11 for Microsoft Wi - Page 14
your system is spending most time doing Sybase SQL Server computing, you may want to investigate denormalization, reduction of the number of joins, horizontal partitioning, or adding/upgrading your system processor. Memory Utilization, Monitoring and Optimization This section provides information on - HP ProSignia 720 | Configuration and Tuning of Sybase System 11 for Microsoft Wi - Page 15
Compaq Servers Object: Memory Counter: Page Faults/sec This counter monitors total page faults by all running processes. A page fault occurs when a process makes a reference to a virtual memory Please refer to the Sybase SQL Server System Administration Guide for more in depth information on the - HP ProSignia 720 | Configuration and Tuning of Sybase System 11 for Microsoft Wi - Page 16
System 11 for Microsoft Windows NT on Compaq Servers Page 13 Dbcc Memusage Dbcc Memusage reports the following very useful information: Y Sybase SQL Server memory allocation at startup Y Memory used by 20 largest objects in the data cache Y Memory used by 12 largest stored procedures, triggers - HP ProSignia 720 | 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 ProSignia 720 | Configuration and Tuning of Sybase System 11 for Microsoft Wi - Page 18
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 Server via the Services Manager or the Control Panel, Services menu, the Registry values are utilized. If you manually start Sybase SQL Server - HP ProSignia 720 | 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 ProSignia 720 | Configuration and Tuning of Sybase System 11 for Microsoft Wi - Page 20
installing Sybase SQL Server on the Primary Domain Controller, Default Gateway, Primary WINS Server, Secondary WINS Server or Domain Name Service Server • dedicate the server to Sybase SQL Server, use other servers for file and print services multi-processor systems • On dedicated Sybase SQL Server - HP ProSignia 720 | Configuration and Tuning of Sybase System 11 for Microsoft Wi - Page 21
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 necessary • on dedicated multi-processor systems set max online - HP ProSignia 720 | Configuration and Tuning of Sybase System 11 for Microsoft Wi - Page 22
Microsoft Windows NT Y SCO UnixWare Y Novell NetWare Y SCO 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 Processing Other: Please indicate the type of information you
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