HP ProLiant DL980 G7 Technical White Paper

Download Technical white paper of HP P2000 G3 Network Hardware, Server for Free or View it Online on All-Guides.com.

Brand: HP

Category: Network Hardware , Server , Storage , Transceiver

Type: Technical white paper

Model: HP P2000 G3 , HP ProLiant DL980 G7

Pages: 24

Download HP P2000 G3 Technical white paper

HP P2000 G3 Technical white paper - Page 1
1
HP P2000 G3 Technical white paper - Page 2
2
HP P2000 G3 Technical white paper - Page 3
3
HP P2000 G3 Technical white paper - Page 4
4
HP P2000 G3 Technical white paper - Page 5
5
HP P2000 G3 Technical white paper - Page 6
6
HP P2000 G3 Technical white paper - Page 7
7
HP P2000 G3 Technical white paper - Page 8
8
HP P2000 G3 Technical white paper - Page 9
9
HP P2000 G3 Technical white paper - Page 10
10
HP P2000 G3 Technical white paper - Page 11
11
HP P2000 G3 Technical white paper - Page 12
12
HP P2000 G3 Technical white paper - Page 13
13
HP P2000 G3 Technical white paper - Page 14
14
HP P2000 G3 Technical white paper - Page 15
15
HP P2000 G3 Technical white paper - Page 16
16
HP P2000 G3 Technical white paper - Page 17
17
HP P2000 G3 Technical white paper - Page 18
18
HP P2000 G3 Technical white paper - Page 19
19
HP P2000 G3 Technical white paper - Page 20
20
HP P2000 G3 Technical white paper - Page 21
21
HP P2000 G3 Technical white paper - Page 22
22
HP P2000 G3 Technical white paper - Page 23
23
HP P2000 G3 Technical white paper - Page 24
24
Technical white paper | HP ProLiant DL980 G7 and P2000 G3 MSA Storage
13
Resource Governor
Resource Governor settings control the amount of CPU or memory resources that can be allocated to a given query. For
running workloads with higher parallelism on the DL980 G7, the “default” workload group can be modified to reduce the
maximum amount of memory that can be allocated to a query from the default of 25% to 5-6% for example. Our testing
with this setting has shown to improve I/O throughput and response on our high parallel workloads. The following query in
Figure 6 can be run to implement this policy and turn Resource Governor on with an example setting of 5%.
Figure 6. Resource Governor
High Availability
HP has designed and tested a High Availability (HA) solution for all its Fast Track solutions. This HA solution leverages
Microsoft Windows and SQL Server failover clustering to provide local, shared storage failover capability.
Failover clustering utilizes a shared SAN storage model whereby 2 or more servers connected to the same set of storage
arrays act as a single SQL application server. The 2 nodes communicate via an Ethernet “heartbeat” in order to detect when
one of the servers has a problem or hardware failure. In the case that the heartbeat is not received by one of the servers,
the cluster will initiate an automatic failover to the standby node. This failover is transparent to the user, and results in a
temporary pause in SQL Server activity as the resources are brought online to the secondary server, and SQL Server
transactions are replayed and brought back to the exact state before the failover occurred.
To ensure cluster communication, and proper failover, the SQL failover cluster must reside in the same local area network
or site. Figure 7 below depicts the connectivity between both cluster nodes and the connectivity between the servers and
storage for this DL980 G7 solution.
Note: For practical purposes, the picture below depicts only 4 P2000 arrays. This DL980 G7 configuration uses a total of 16
arrays. Table 9 below depicts the overall wiring guidance for this HA solution.
Table 9. DL980 G7 Wiring Guidance
Components
Fibre Switch
Ethernet Switch
P2000 Arrays
Arrays 1-8 port A1
8/40 Switch #1
Arrays 1-8 port A2
8/40 Switch #1
Arrays 1-8 port B1
8/24 Switch #2
Arrays 1-8 port B2
8/24 Switch #2
Arrays 9-16 port A1
8/40 Switch #2
Arrays 9-16 port A2
8/40 Switch #2
Arrays 9-16 port B1
8/24 Switch #1
Arrays 9-16 port B2
8/24 Switch #1
Mgmt Port A
2510-48G Switch
Mgmt Port B
2510-48G Switch
DL980 G7 Server
iLO Ethernet
2510-48G Switch
ALTER WORKLOAD GROUP "default"
WITH (REQUEST_MAX_MEMORY_GRANT_PERCENT = 5)
GO
ALTER RESOURCE GOVERNOR RECONFIGURE
GO