A new version of the DVD Store database test has been posted to linux.dell.com/dvdstore.linux.dell.com/dvdstore. This version contains a simple, trigger-based inventory replenish mechanism in both the SQL Server and Oracle versionsimplementations to keep the percentage of items in stock at the same level throughout a test, thus keeping the rollback rate constant.

Additionally, we have added many features for SQL Server 2005 including 4 new indexes, 4 new statistics, and new code/instructions for creating a 3-tiered application with ASP.NET.

Finally, since many users are now using the large (100GB) version we have added more build scripts, etc. for this version.

Here's a complete list of changes:

ds2xdriver.cs: Changed "target_hostname" to "windows_perf_host" for clarity; modified description in code and in ds2driver_doc.txt

Oracle: Modified PURCHASE stored procedure in oracleds2_create_sp.sql to keep rollback rate constant Added extra try/catch statement to dspurchase.jsp

SQL Server: ds2sqlserverfns.cs: added Connection Timeout=120 to sConnectionString; recompiled ds2sqlserverdriver.exe sqlserverds2_create_all_*.sql: replaced create code with new code from build directory added separate create all scripts for medium and large (with 2 and 4 LUNs) databases build: sqlserverds2_create_db*.sql: changed dbf filesizes for SQL Server 2005 changed LUN nomenclature (data on G: and H: (and I: and J:if necessary); logs on L:) added separate build files for LARGE database with 2 or 4 LUNs added RESTOCK trigger to keep rollback rate constant sqlserverds2_create_ind*.sql: Added added 4 new indexes and 4 statistics from SQL Server Tuning Advisor created separate ind files for small, medium and large databases (differ in location of Fulltext files) sqlserverds2_cleanup*.sql: added delete rows of REORDER table added and recreate RESTOCK trigger load: added TABLOCK parameter to load files web: changed aspx files for SQL Server 2005 and Visual Studio 2005; added detailed instructions for setting up web site