
A Principled Technologies test report 4
Database performance and resiliency in the Intel processor-powered
Dell PowerEdge R630 running Microsoft SQL Server 2014
times as many OPM, with each database providing many more OPM than the original
HDD-configuration databases provided.
Figure 3: SQL Server 2014 performance for the 20-ms think HDD server configuration and four 20-ms think
time SSD configurations.
We found that by using multiple SQL Server instances when using more
databases at the eight-database and 24-database configurations, we were able to
achieve higher OPM.
When we looked at the variability with SSDs, we found it to be significantly
lower than with HDDs—under 5 percent with all database counts. Having a balanced
service level shows that the database server had sufficient performance capacity on the
storage to be able to service all our test clients equally (see Figure 4).
Comentários a estes Manuais