Dell PowerEdge External Media System 1434 Konfiguracja - Strona 3

Przeglądaj online lub pobierz pdf Konfiguracja dla Serwer Dell PowerEdge External Media System 1434. Dell PowerEdge External Media System 1434 16 stron. Statement of volatility
Również dla Dell PowerEdge External Media System 1434: Podręcznik dla początkujących (12 strony), Podręcznik (38 strony), Podręcznik (29 strony), Korzystanie z instrukcji (16 strony), Podręcznik (10 strony)

Drukuj stronę

Dell PowerEdge External Media System 1434 Konfiguracja

1. Internal Storage Controller (Perc H710P Mini) Settings

Dell SMB Reference Configuration for Microsoft SQL Server 2012 Fast Track Data Warehouse on

PowerEdge R720xd

Contents

Introduction ............................................................................................................. 4

Microsoft SQL Server Fast Track Data Warehouse ................................................................ 4

Dell Fast Track Data Warehouse Reference Architecture ....................................................... 4

Hardware Component Architecture .............................................................................. 5

Internal Storage Controller (PERC H710P Mini) Settings ...................................................... 7

Application Configuration ........................................................................................ 10

Performance Benchmarking ......................................................................................... 11

Baseline Hardware Characterization using Synthetic I/O ................................................... 11

Fast Track Database Validation ................................................................................. 13

Fast Track Database Validation with Column Store Index (CSI) ........................................... 14

Reference Architecture Performance Details ................................................................. 14

Conclusion ............................................................................................................. 15

References ............................................................................................................. 16

Tables

Table 1.

Dell Fast Track Reference Architecture Solution Details ........................................... 4

Table 2.

Tested Dell Fast Track Reference Architecture Component Details .............................. 5

Table 3.

Mount Point Naming and the Storage Enclosure Mapping ........................................... 9

Table 4.

Performance Metrics ..................................................................................... 14

Figures

Figure 1.

Proposed Dell Fast Track Reference Architecture.................................................... 5

Figure 2.

Memory Slot Locations .................................................................................... 6

Figure 3.

Virtual Disk Settings ....................................................................................... 7

Figure 4.

Internal Storage Controller Settings .................................................................... 8

Figure 5.

RAID Configuration ......................................................................................... 8

Figure 6.

Storage System Components ........................................................................... 10

Figure 7.

SQLIO Line Rate Test from Cache (Small File) ...................................................... 12

Figure 8.

SQLIO Real Rate Test from Disk (Large File) ........................................................ 13