Dell H730P Manual do Utilizador descarregar pdf (Página 3)

A Principled Technologies test report 3

Database performance and resiliency in the Intel processor-powered

Dell PowerEdge R630 running Microsoft SQL Server 2014

Figure 1: SQL Server 2014

performance for the HDD

server configuration with two

different think times.

Note that the bars in Figure 1 are more uniform in size with the longer think

time and less uniform with the shorter think time. Figure 2 shows the specific number of

OPM each client achieved. With the more intense workload due to shorter think time,

variability increased. In other words, because of higher variability, application service for

the users degraded.

Scenario

HDD – 4 DB

(100 ms)

HDD - 4 DB

(20 ms)

Client 1

5,567

4,719

Client 2

6,055

7,376

Client 3

4,823

7,628

Client 4

4,291

4,362

Total OPM

20,736

24,085

Variability

29.1%

42.8%

Figure 2: Performance and variability for the 100-ms and 20-ms scenarios with HDDs.

SSD configuration

As Figure 3 shows, replacing the Dell PowerEdge R630 HDDs with SSDs boosted

performance dramatically. Compared to the 20-ms think time HDD scenario with four

databases, the SSD configuration with four databases delivered 7.7 times as many OPM.

We ran multiple SQL Server instance and database count combinations to see which

combinations would deliver the best performance. Fewer SQL Server instances are more

common in practice, so first we ran eight databases with two SQL Server instances. The

eight-database SSD configuration using two SQL Server instances delivered 10.1 times as

many and the 24-database configuration with four SQL Server instances delivered 10.5

1 2 3 4 5 6 7 8 ... 17 18

Comentários a estes Manuais

Sem comentários

Dell H730P Manual do Utilizador Página 3

Comentários a estes Manuais

Manuais e produtos relacionados com Software de bases de dados Dell H730P