Dell PowerEdge SDS 100 Konfiguration - Seite 3

Blättern Sie online oder laden Sie pdf Konfiguration für Server Dell PowerEdge SDS 100 herunter. Dell PowerEdge SDS 100 16 Seiten. Statement of volatility
Auch für Dell PowerEdge SDS 100: Handbuch "Erste Schritte (12 seiten), Handbuch (38 seiten), Handbuch (29 seiten), Handbuch verwenden (16 seiten), Handbuch (10 seiten)

Seite drucken

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