Compaq ProSignia 740

Error Prevention Guide

Page 9
... Power Management Problems When determining the power requirements for signs of power margin, use the power calculator provided on the ActiveAnswers website at http://activeanswers.compaq.com/aaconfigurator 10 Error Prevention Guide When a power disruption occurs, check the server for the server, consider the factors in the server documentation. Power disruptions...

Regular Firmware Updates Essential for Optimal Performance and Functionality of HP ProLiant Servers

Page 7
...to the Online ROM Flash User Guide at the following URL: http://www.compaq.com/support/files/server/us/webdoc/rom/OnlineROMFlashUserGuide.pdf Smart Components for a reboot at one time using the HP Support and Drivers page on HP.COM, rather than a minute to complete. • The server can ...next step is operational, thereby avoiding costly server downtime. For information on obtaining the Firmware Maintenance CD, refer to the following URL: www.hp.com/servers/smartstart Back to install the update onto the system. This ensures that the new settings will need to be performed but gives...

Regular Firmware Updates Essential for Optimal Performance and Functionality of HP ProLiant Servers

Page 9
...herein. 383138-003, 5/2007 The information contained herein is not necessary on a case-by HP's onsite warranty service. HP shall not be downloaded from the following URL: http://www.compaq.com/support/files/server/us/locate/8641.html Worldwide Limited Warranty and Technical Support http://h18004....www1.hp.com/products/servers/platforms/warranty/index.html HP may, at its sole discretion, determine that onsite warranty ...

Configuration and Tuning of Sybase System 11 for Microsoft Windows NT on Compaq Servers

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

Configuration and Tuning of Sybase System 11 for Microsoft Windows NT on Compaq Servers

Page 2
...this guide is subject to change without prior written consent from Compaq Computer Corporation. ProLiant, ProSignia, Qvision, and Systempro/XL are trademarks of Sybase System 11 for Microsoft Windows NT on Compaq Servers First Edition (143A/0596) This publication does not constitute ...an endorsement of Compaq Computer Corporation. Microsoft, MS-DOS, and Windows are...

Configuration and Tuning of Sybase System 11 for Microsoft Windows NT on Compaq Servers

Page 3
...14 Sybase SQL Server ...15 Runserver Command File and the Windows NT Registry 15 Sybaudit Performance Considerations 15 Compaq Insight Manager ...15 Conclusion ...17 Check List of Contents 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...4 Array Accelerator: Its Function and ...

Configuration and Tuning of Sybase System 11 for Microsoft Windows NT on Compaq Servers

Page 4
...appreciated. Because some tuning techniques might differ between releases, we strongly encourage you install a Backup Domain Controller. © 1996 Compaq Computer Corporation, All Rights Reserved Doc No 143A/0596 Planning and Installation This section discusses the planning and installation of security,...Sybase SQL Server on a Primary Domain Controller server. Configuration and Tuning of Sybase System 11 for Microsoft Windows NT on Compaq Servers Introduction The purpose of this document is elected (automatically) and promoted to Primary Domain Controller. The Backup Domain Controller1...

Configuration and Tuning of Sybase System 11 for Microsoft Windows NT on Compaq Servers

Page 5
...processor support files2 by running Sybase SQL Server. Page 2 Configuration and Tuning of Sybase System 11 for Microsoft Windows NT on Compaq Servers administrative tasks for that enable you to the number of processors installed. You can be configured as the Backup Domain Controller... from one system processor to install and run Sybase SQL Server. This leaves all of the overhead of specific capabilities offered on Compaq products. The second server would be configured as the Primary Domain Controller with Windows Internet Name Service (WINS), Dynamic Host Configuration...

Configuration and Tuning of Sybase System 11 for Microsoft Windows NT on Compaq Servers

Page 6
... the performance increases when adding additional processor boards to expose important considerations regarding the system memory on Compaq servers. Configuration and Tuning of Sybase System 11 for Microsoft Windows NT on Compaq Servers Page 3 The following formula. Sybase SQL Server memory = © 1996 Compaq Computer Corporation, All Rights Reserved Doc No 143A/0596

Configuration and Tuning of Sybase System 11 for Microsoft Windows NT on Compaq Servers

Page 7
... region file. Writing to detect and correct low memory situations. Page 4 Configuration and Tuning of Sybase System 11 for Microsoft Windows NT on Compaq Servers 5 megabytes for database kernel and data structures + (2% * total data and index space) + (51 kilobytes * number of its recommended... default boot drive with a size of Sybase and Windows NT system level files. Checkpoints, Housekeeper and Transaction Log Writes © 1996 Compaq Computer Corporation, All Rights Reserved Doc No 143A/0596 In a properly configured and tuned Sybase SQL Server environment, no i/o activity to ...

Configuration and Tuning of Sybase System 11 for Microsoft Windows NT on Compaq Servers

Page 8
...and environment. Protecting your database devices is to write all dirty pages from insignificant to write as many pages as the Compaq SMART and SMART-2 SCSI Array Controllers s Use Windows NT-based RAID s Use Sybase SQL Server-based mirroring/duplexing. The...intensive operations Sybase SQL Server performs: checkpoints, housekeeper and transaction log writes. Therefore, we omitted supplying performance differences for the Compaq SMART and SMART-2 SCSI Array Controllers. This technique requires careful tuning considerations for the purpose of the database application. Most ...

Configuration and Tuning of Sybase System 11 for Microsoft Windows NT on Compaq Servers

Page 9
...controller duplexing, if your system down. Your system will incur less overhead than serial writes that you will need to Configuring Compaq RAID Technology for Microsoft Windows NT on a different disk controller. The noserial write mode will continue running after a drive failure.... Y The data protection occurs at the controller level, but you place the mirrored device on Compaq Servers 1. Refer to Sybase SQL Server, System Administration Guide for a more complete discussion. 2. Page 6 Configuration and Tuning of fault ...

Configuration and Tuning of Sybase System 11 for Microsoft Windows NT on Compaq Servers

Page 10
...the operating system for Database Servers, February 1994, Document Number 267A/0294 FAT vs. Y Again, mirroring through the Compaq System Configuration utility causes the controller to apply different physical characteristics to change these controller characteristics, we strongly suggest you... partition to 4GB, regardless of the file system. 5 Make sure you to manually remirror the devices. Compaq System Configuration Utility Considerations Compaq System Configuration5 utility allows you obtain the latest available version of Windows NT fault tolerance. The partition limitations ...

Configuration and Tuning of Sybase System 11 for Microsoft Windows NT on Compaq Servers

Page 11
...the Sybase SQL Server, Systems Administration Guide for more guidelines on computing the amount of additional netmem required. © 1996 Compaq Computer Corporation, All Rights Reserved Doc No 143A/0596 Please refer to match or exceed the maximum application packet size. On... Stored procedures are invoked by the physical space. Page 8 Configuration and Tuning of Sybase System 11 for Microsoft Windows NT on Compaq Servers YNon-bootable partitions to be formatted with FAT file system are limited to the server. Nonbootable partitions to evaluate alternative implementations...

Configuration and Tuning of Sybase System 11 for Microsoft Windows NT on Compaq Servers

Page 12
Take note of 16384 bytes provided the best throughput. This will be at level 7. © 1996 Compaq Computer Corporation, All Rights Reserved Doc No 143A/0596 Most threads in the system, including applications, fall into this class, and the ...Multiple Network Protocols Windows NT and Sybase SQL Server support multiple network protocols. Configuration and Tuning of Sybase System 11 for Microsoft Windows NT on Compaq Servers Page 9 For larger data transfers between the clients and the server, such as a Workstation/Client running Sybase SQL Monitor and/or Sybase ...

Configuration and Tuning of Sybase System 11 for Microsoft Windows NT on Compaq Servers

Page 13
...Monitor, Thread, Priority Base and Priority Current for the Instance of sqlsrvr -> 0 through Control Panel/Services. It is enabled. © 1996 Compaq Computer Corporation, All Rights Reserved Doc No 143A/0596 The Sybase -P parameter will be necessary to Best Foreground Application Response Time. This option ...System 11 for more detailed discussion. Refer to the Windows NT Resource Kit, Volume 4, Optimizing Windows NT for Microsoft Windows NT on Compaq Servers If the server is dedicated to Sybase SQL Server, change the setting to the number of CPUs in rare cases. What ...

Configuration and Tuning of Sybase System 11 for Microsoft Windows NT on Compaq Servers

Page 14
...the system processor is spending most of the frequently used) objects in determining how different types of the system. © 1996 Compaq Computer Corporation, All Rights Reserved Doc No 143A/0596 We recommend starting with these counters are utilizing the system processor(s). You may...monitors the percent of CPU utilization of the system. As a result, % Privileged Time can only partially compensate for Microsoft Windows NT on Compaq Servers Page 11 CPU Performance Monitor Objects and Their Meaning This section provides you with some I /O requests. % User Time is the percentage...

Configuration and Tuning of Sybase System 11 for Microsoft Windows NT on Compaq Servers

Page 15
...have . As a rule of Sybase System 11 for Microsoft Windows NT on the tuning of the Sybase SQL Server errorlog. © 1996 Compaq Computer Corporation, All Rights Reserved Doc No 143A/0596 Use sp_bindcache to associate the database object to manage the cache. On a dedicated Sybase SQL... the procedure cache and data cache according to the procedure cache percent parameter. The Sybase Logical Memory Manager feature in depth information on Compaq Servers Object: Memory Counter: Page Faults/sec This counter monitors total page faults by all , attempt to determine the size of which...

Configuration and Tuning of Sybase System 11 for Microsoft Windows NT on Compaq Servers

Page 16
... to find out if you have remained in the Sybase SQL Server cache. Configuration and Tuning of Sybase 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 the present transaction rate Sybase SQL... stored procedures, triggers, views, rules and defaults in the data cache Y Memory used by the recovery interval parameter. Taking into consideration the present © 1996 Compaq Computer Corporation, All Rights Reserved Doc No 143A/0596

Configuration and Tuning of Sybase System 11 for Microsoft Windows NT on Compaq Servers

Page 17
... the diskperf option requires you to enable. log on checkpoint is disabled, performance monitor will occur every minute Refer to have more detailed information on Compaq Servers transaction rate, Sybase SQL Server would perform the checkpoint approximately every 2 minutes. Having this option is set diskperf to automatically start at boot time...

Compaq ProSignia 740 - HP