Home | About | Contact

HP ProLiant DL980 G7 Technical White Paper

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

Brand: HP

Category: Network Hardware , 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
Page 1
background image

 
 

Technical white paper  

HP 85 TB reference 

architectures for Microsoft SQL 

Server 2012 Fast Track Data 

Warehouse: HP ProLiant DL980 

G7 and P2000 G3 MSA Storage 

 

Table of contents 

Executive summary ..................................................................................................................................................................................... 2

 

Fast Track reference architecture ............................................................................................................................................................. 2

 

Important points and caveats ............................................................................................................................................................... 2

 

Solution criteria ............................................................................................................................................................................................ 4

 

Storage options ........................................................................................................................................................................................... 5

 

Capacity summary .................................................................................................................................................................................. 7

 

Database configuration ......................................................................................................................................................................... 8

 

SQL Server 2012 performance metrics ............................................................................................................................................... 8

 

Measured performance.......................................................................................................................................................................... 8

 

Queue Depth settings ............................................................................................................................................................................ 9

 

LUN layout ............................................................................................................................................................................................... 9

 

Volume Read Ahead settings .............................................................................................................................................................. 11

 

Multi Path I/O (MPIO) ................................................................................................................................................................................. 11

 

SQL Server settings ................................................................................................................................................................................... 12

 

MAXDOP parameter.............................................................................................................................................................................. 12

 

Resource Governor ............................................................................................................................................................................... 13

 

High Availability ......................................................................................................................................................................................... 13

 

Additional storage requirements ........................................................................................................................................................ 15

 

Manual storage mapping ..................................................................................................................................................................... 16

 

Disaster recovery ....................................................................................................................................................................................... 19

 

Bills of materials ........................................................................................................................................................................................ 20

 

High Availability ..................................................................................................................................................................................... 21

 

Disaster recovery .................................................................................................................................................................................. 22

 

Implementing a proof-of-concept .......................................................................................................................................................... 23