HP Integrity rx2800 Installation Guide, Windows Server 2008 R2 v7.0 - Page 71

A Preparing the Server for Microsoft SQL Server, SQL Server 2005 Installation

Get HP Integrity rx2800 - i2 PDF manuals and user guides View all HP Integrity rx2800 manuals
Add to My Manuals
Save this manual to your list of manuals

Page 71 highlights

A Preparing the Server for Microsoft SQL Server This appendix describes the server configuration tasks needed to install Microsoft SQL Server. NOTE: The Itanium version of Microsoft® SQL Server® 2008 is designed for use with the following operating systems: • Windows Server 2003 for Itanium-based Systems with Service Pack 2, or later • Windows Server 2008 for Itanium-based Systems, or later • Windows Server 2008 R2 for Itanium-based Systems, or later NOTE: The minimum requirements for running Microsoft® SQL Server® 2005 on Windows Server 2008 R2 systems are found here: http://support.microsoft.com/kb/955725 NOTE: If you are running Microsoft® SQL Server® 2005 "Server + CAL" licenses on a partitioned server, you can only run the software on the number of partitions for which you have valid software licenses. If you are running Microsoft® SQL Server® 2005 or 2008 "Per Processor" licenses on a partitioned server, you can only run the software on the number of CPUs for which you have valid software licenses. NOTE: For Microsoft® SQL Server® 2005 Enterprise Edition Software users: You may only run the Microsoft SQL Server 2005 Enterprise Edition software in place of Microsoft SQL Server® 2008 Enterprise software in order to exercise your Downgrade rights under the SQL Server 2008 Enterprise License Terms. The SQL Server 2008 License Terms apply to your use of the SQL Server 2005 Software. 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: a. Set the system ACPI Config Flag to Windows. b. 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. c. 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: a. Check affinity masks. By default these are set to zero. Set them to actual CPU configurations for all CPUs using Spconfigure. b. Confirm the degree of parallelism settings: i. 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. ii. 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: a. Confirm that you have enough network interface cards (NICs). If you have more than 10,000 packets/second on a NIC, add another NIC. b. Enable TCP and IP, and Rx and Tx checksum off-loading. SQL Server 2005 Installation 71

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
A Preparing the Server for Microsoft SQL Server
This appendix describes the server configuration tasks needed to install Microsoft SQL Server.
NOTE:
The Itanium version of Microsoft® SQL Server® 2008 is designed for use with the
following operating systems:
•
Windows Server 2003 for Itanium-based Systems with Service Pack 2, or later
•
Windows Server 2008 for Itanium-based Systems, or later
•
Windows Server 2008 R2 for Itanium-based Systems, or later
NOTE:
The minimum requirements for running Microsoft® SQL Server® 2005 on Windows
Server 2008 R2 systems are found here:
NOTE:
If you are running Microsoft® SQL Server® 2005 "Server + CAL" licenses on a partitioned
server, you can only run the software on the number of partitions for which you have valid
software licenses. If you are running Microsoft® SQL Server® 2005 or 2008 "Per Processor"
licenses on a partitioned server, you can only run the software on the number of CPUs for which
you have valid software licenses.
NOTE:
For Microsoft® SQL Server® 2005 Enterprise Edition Software users:
You may only run the Microsoft SQL Server 2005 Enterprise Edition software in place of Microsoft
SQL Server® 2008 Enterprise software in order to exercise your Downgrade rights under the
SQL Server 2008 Enterprise License Terms. The SQL Server 2008 License Terms apply to your
use of the SQL Server 2005 Software.
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:
a.
Set the system
ACPI Config Flag
to Windows.
b.
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
.
c.
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:
a.
Check affinity masks. By default these are set to zero. Set them to actual CPU
configurations for all CPUs using Spconfigure.
b.
Confirm the degree of parallelism settings:
i.
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.
ii.
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:
a.
Confirm that you have enough network interface cards (NICs). If you have more than
10,000 packets/second on a NIC, add another NIC.
b.
Enable TCP and IP, and Rx and Tx checksum off-loading.
SQL Server 2005 Installation
71