The DVD Store Version 2 (DS2) is a complete, online e-commerce test application, with a back-end database component, a Web application layer, and driver programs. The goal in designing the database component as well as the mid-tier application was to utilize many advanced database features (transactions, stored procedures, triggers, referential integrity) while keeping the database easy to install and understand. The DS2 workload may be used to test databases or as a stress tool for any purpose. The distribution includes code for Microsoft SQL Server, Oracle, MySQL, and PostgreSQL databases. Included in the release are data generation programs; shell scripts to build data for 10 MB, 1 GB, and 100 GB versions of the DVD Store; database build scripts and stored procedures; PHP Web pages; and a C# driver program.DVD Store Version 2.1 was released December 2010 and includes enhancements allowing for the creation of any size database, running a single driver program against multiple targets with consolidated and broken-out stats, better error handling, auto creation of driver program config file, and updated data with current dates. DVD Store 2.1 is also included as one of the workloads in VMmark 2.0 - a multi-host virtualization benchmark from VMware.The code is freely available to all under the GPL from linux.dell.com. Documentation is included in the kit.Please use the "Threads" link below to ask questions, post solutions, or describe how you are using the DVD Store in your organization.Authors: Dave Jaffe and Todd MuirheadNew version available (December 2011). Added support for PostgreSQL DB. Click for download. Details in ds21_documentation.txt in main tarball.
PowerEdge R910 SQL OLTP Virtualization Study - Performance and performance/watt of SQL virtual machines (VMs) on VMware with Xeon 7500 and E7-4800 series processors
EqualLogic Demo Video - Shows VSS Snapshot integration with SQL Server
VMware – Results with Oracle database on VMwareVMware and DB2 - Performance testing of DB2 virtual machines (VMs) on ESX
Anandtech – Intel processor comparisonsJBoss – Demo of their JEE Application Server platformc't MagazineDell IT – Uses it for much of their Oracle testing as well as for Microsoft SQL Server testingDell Enterprise Technology Center – Most of the papers you see here used the DVD Store workload in one form or another
Return to Dell TechCenter Home Page