The results of our validation and load testing show that this database solution provides:
- The capability to consolidate 11 dedicated legacy servers and a traditional storage array down to four S2D nodes—You can retire legacy servers to a small 4U footprint and centralize management to ease the burden on your IT team. With each traditional server hosting one simulated production database, we consolidated all 12 databases to just four S2D nodes running SQL Server 2017.
- Fast sub-millisecond response times driven by all-flash S2D nodes—The average response time for reads and writes was well below 1 millisecond (ms).
- Near-linear scalability—PowerEdge R640 all-flash servers, providing both database and storage services, maintained excellent performance in load tests for eight databases in parallel.
- The capability to fully back up a 431 GB SQL Server database in 3.8 minutes and restore the same database in 9.25 minutes—You can quickly back up and restore your critical databases by integrating a Dell EMC Data Domain DD6300 appliance with the solution.