HP Integrity rx2620 Installation (Smart Setup) Guide, Windows Server 2003, v5. - Page 77

A Preparing the server for Microsoft SQL Server 2005

This appendix describes the server configuration tasks needed to install Microsoft SQL Server

2005.

SQL Server 2005 installation

This section is an overview of the steps needed to install SQL Server 2005. For further installation

and configuration information, see the SQL Server 2005 documentation.

1.

Configure the server

•

Set the system

ACPI Config Flag

to Windows.

•

Verify that system nPartitions are set to 100% cell local memory (CLM) by using the

ParCLI

parstatus

command. Adjust the value to 100%, if necessary, using the

parmodify

command (see the

nPartition Guide

on the Smart Setup media at

\contents\doc\en_us\npartition.pdf

).

•

Data Warehousing: For decision support and data warehousing, set the number of CPUs

to a higher number, such as four, up to the actual number of CPUs.

2.

Configure SQL Server 2005

•

Check affinity masks. By default these are set to zero. Set them to actual CPU

configurations for all CPUs using Spconfigure.

•

Confirm the degree of parallelism settings:

1.

a) If you have a large system (more than four CPUs), do not set this number to zero

using SPconfigure. Also, increase parallelism if you expect highly complex queries.

2.

b) Online transaction processing (OLTP): For these workloads, set the level of

parallelism low (one query should not use more than one CPU, so set to 1).

3.

Verify networking issues

•

Confirm that you have enough network interface cards (NICs). If you have more than

10,000 packets/second on a NIC, add another NIC.

•

Enable TCP and IP, and Rx and Tx checksum off-loading.

4.

Verify storage/Fibre Channel HBAs:

•

Maximum queue depth: Ensure that the Emulex driver options set in LPutil are equal

to or greater than the number of physical drives (default = 20).

•

Maximum queue depth: For Qlogic NVRAM, ensure that the Sanblade execution throttle

setting is equal to or greater than the number of physical drives (default = 16).

•

Enable write cache: It is important to have a cached log for the database.

Installing SQL Server from the command prompt

To install a standalone instance of SQL Server from the command prompt, do the following:

1.

Insert the SQL Server 2005 installation media into the disk drive.

2.

For instance-aware components (the Database Engine, SQL Server Agent, Analysis Services,

and Reporting Services) use the following syntax:

Start /wait <CD or DVD Drive>\setup.exe /qb INSTANCENAME=<InstanceName> ADDLOCAL=SQL_Engine,

SQL_Replication PIDKEY=<pidkey value with no "-"> SAPWD=<StrongPassword>

SQLACCOUNT=<DomainName\UserName> SQLPASSWORD=<DomainUserPassword>

AGTACCOUNT=<DomainName\UserName> AGTPASSWORD=<DomainUserPassword>

SQLBROWSERACCOUNT=<DomainName\UserName>

SQLBROWSERPASSWORD=<DomainUserPassword>

To install a clustered instance of SQL Server 2005 from the command prompt, do the following:

1.

Insert the SQL Server 2005 installation media into the disk drive.

2.

For a new failover cluster, use the following syntax:

Start /wait <DVD Drive>\setup.exe /qn VS=<VSName>

SQL Server 2005 installation

77

Section	Page
Smart Setup Guide	1
Table of Contents	3
About This Document	11
Intended Audience	11
New and Changed Information in This Edition	11
Document Organization	11
Typographic Conventions	11
Related Information	12
Publishing History	13
HP Encourages Your Comments	13
1 Preparing for the installation	15
Choosing an installation method	15
Ensuring platform compatibility	16
Check hardware compatibility	16
Back up existing data	17
Choosing an installation environment	17
Choosing the Installation media	18
Using the Microsoft OS media	18
Using the HP Reinstallation media	18
Locating the Microsoft Certificate of Authenticity	18
Setting up a console	22
Set up a headless console	22
Set up the headless console using a null modem cable	22
Set up the headless console using a LAN	23
Set up the headless console using a Remote Serial Console (rx2660, rx3600, rx6600, BL860c, and BL870c only)	23
Set up a GUI console	23
Set up an Integrated Remote Console (rx2660, rx3600, rx6600, BL860c, and BL870c only)	25
Set up a Virtual Media (vMedia) drive	25
Setting up PXE/RIS	26
Set up a RIS server	27
Install RIS	28
Configure RIS	28
Authorize a RIS server in Active Directory	29
Use the Client Installation Wizard	29
Preparing the server hardware	30
Set up the boot drive	30
Boot to EFI	30
Locate the DVD/CD drive	31
Set ACPI flag to windows (cell-based servers only)	32
Set cell local memory to 100% (cell-based servers only)	32
Specify NIC for a network boot	32
2 Installing the OS	35
Installing from a headless console	35
Run EBSU	36
Run Windows Setup	38
Enter the product key	39
Installing from a GUI console	39
Run EBSU	39
Run Windows Setup	42
Specify server settings	42
Installing from PXE	43
Reinstalling from a headless console	43
Load the system image	44
Specify server settings	45
Reinstalling from a GUI console	46
Load the system image	46
Specify server settings	47
Applying OS updates	47
Enabling Windows components	48
Install TCP/IP	48
Install SNMP	48
Configure SNMP	49
Set IP addresses from a headless console	49
Set up and run a Remote Desktop Connection	49
Updating firmware, drivers, and software	50
Enable greater than 256 interrupts (cell-based servers only)	50
Update firmware	51
Update device drivers	51
Install the Integrity Support Pack (ISP)	52
Install updates from the web	53
Register for HP support notifications	53
Register for Microsoft security notifications	53
Register for Microsoft Windows Update	53
Miscellaneous installation issues	53
Using Integrated Remote Console to install Windows on rx2660, rx3600, rx6600, BL860c, and BL870c servers	53
Installing a Windows guest on an HP Integrity Virtual Machine host	54
Enabling hyperthreading on HP Integrity servers	55
Enable hyperthreading using EFI	55
Enable hyperthreading using Partition Manager	56
3 Installing the Management Tools	57
Installing System Management Homepage	57
Configure SMH after Support Pack installation	57
Install SMH separately	57
Initializing SMH	59
Installing the management agents	59
Configure management agents after Support Pack installation	60
Install management agents from Smart Setup media	60
Activating and configuring agents	60
Activating agents	60
Configuring the event notifier	61
Setting the agent SNMP data collection interval	63
Monitoring server processes	64
Sending SNMP traps to management applications via IP	65
Installing partition management tools	66
Install nPartition Commands Bundle from the Smart Setup media	67
Install Partition Manager Bundle from the Smart Setup media	67
Verifying the installation	68
Verify nPartition commands	68
Verify Partition Manager installation	68
4 Performing hot-plug operations	71
Before you begin	71
Adding a PCI card	72
Hardware interface for all HP Integrity servers except Superdome	72
Hardware interface for Superdome servers	73
Software interface	74
Removing a PCI card	74
Software interface for all HP Integrity servers except Superdome	74
Software interface for Superdome servers	74
Hardware interface for all HP Integrity servers except Superdome	74
Hardware interface for Superdome servers	75
A Preparing the server for Microsoft SQL Server 2005	77
SQL Server 2005 installation	77
Installing SQL Server from the command prompt	77
Installing SQL Server from the GUI	78
B EFI Utilities	81
Introduction to EFI	81
EFI Boot Manager	81
EFI Shell	81
Common EFI Shell commands	82
EFI-Based Setup Utility	85
Creating a new boot file using the EFI Shell	86
Verify successful boot file creation	87
C Management processor and Special Administration Console	89
Management processor	89
Accessing the MP	89
MP Commands	89
Special Administration Console	94

HP Integrity rx2620 Installation (Smart Setup) Guide, Windows Server 2003, v5. - Page 77

A Preparing the server for Microsoft SQL Server 2005, SQL Server 2005 installation

Page 77 highlights