Dell PowerEdge SDS 100 Configuratie - Pagina 3

Blader online of download pdf Configuratie voor {categorie_naam} Dell PowerEdge SDS 100. Dell PowerEdge SDS 100 16 pagina's. Statement of volatility
Ook voor Dell PowerEdge SDS 100: Aan de slag handleiding (12 pagina's), Handmatig (38 pagina's), Handmatig (29 pagina's), Handmatig gebruiken (16 pagina's), Handmatig (10 pagina's)

Pagina afdrukken

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