
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).
Kommentare zu diesen Handbüchern