OK, I managed to dig up stuff that I was planning to release to TR forums dated 2009/11! (procrastination at its best)
The database pattern that you are looking for is, as SR.com stated when they updated to Testbench3, pretty arbitrary. I personally think it is pretty lame. It is 100% access (1 row) with 8KB size where 67% is reads and 100% random. Instead of trying attach the files to web file lockers and stuff, I have decided to post my work here. It was back then when I got my shiny new 785G+SB710 and I wanted to
it to ICH9 and stock MS vs Intel/AMD drivers.
So here's the readme that I wrote up for the zip file package (I have updated the links for reference):
The "test setups" were my own definition for my own testing. If we use the same setups then we can compare our results, or at least that was what I was hoping. Configs #4 and up are my own recreation based on the links. I have re-created the older (and deprecated) patterns, plus I added new patterns (#9-11) that I thought to be useful at the time. Why 2 .icf files? More on that later.
trforums_single.icf file. Just copy and paste in your favourite text editor.
Version 2006.07.27
'TEST SETUP ====================================================================
'Test Description
TR Forums - Single Core CPU
'Run Time
' hours minutes seconds
0 10 0
'Ramp Up Time (s)
20
'Default Disk Workers to Spawn
1
'Default Network Workers to Spawn
NUMBER_OF_CPUS
'Record Results
ALL
'Worker Cycling
' start step step type
1 1 LINEAR
'Disk Cycling
' start step step type
1 1 LINEAR
'Queue Depth Cycling
' start end step step type
1 256 2 EXPONENTIAL
'Test Type
CYCLE_OUTSTANDING_IOS
'END test setup
'ACCESS SPECIFICATIONS =========================================================
'Access specification name,default assignment
Default,NONE
'size,% of size,% reads,% random,delay,burst,align,reply
2048,100,67,100,0,1,0,0
'Access specification name,default assignment
All in one,NONE
'size,% of size,% reads,% random,delay,burst,align,reply
512,5,100,0,0,1,0,0
512,5,75,0,0,1,0,0
512,5,50,0,0,1,0,0
512,5,25,0,0,1,0,0
512,5,0,0,0,1,0,0
4096,5,100,0,0,1,0,0
4096,5,75,0,0,1,0,0
4096,5,50,0,0,1,0,0
4096,5,25,0,0,1,0,0
4096,5,0,0,0,1,0,0
16384,5,100,0,0,1,0,0
16384,5,75,0,0,1,0,0
16384,5,50,0,0,1,0,0
16384,5,25,0,0,1,0,0
16384,5,0,0,0,1,0,0
32768,5,100,0,0,1,0,0
32768,5,75,0,0,1,0,0
32768,5,50,0,0,1,0,0
32768,5,25,0,0,1,0,0
32768,5,0,0,0,1,0,0
'Access specification name,default assignment
File Server,ALL
'size,% of size,% reads,% random,delay,burst,align,reply
512,10,80,100,0,1,0,0
1024,5,80,100,0,1,0,0
2048,5,80,100,0,1,0,0
4096,60,80,100,0,1,0,0
8192,2,80,100,0,1,0,0
16384,4,80,100,0,1,0,0
32768,4,80,100,0,1,0,0
65536,10,80,100,0,1,0,0
'Access specification name,default assignment
Web Server,ALL
'size,% of size,% reads,% random,delay,burst,align,reply
512,22,100,100,0,1,0,0
1024,15,100,100,0,1,0,0
2048,8,100,100,0,1,0,0
4096,23,100,100,0,1,0,0
8192,15,100,100,0,1,0,0
16384,2,100,100,0,1,0,0
32768,6,100,100,0,1,0,0
65536,7,100,100,0,1,0,0
131072,1,100,100,0,1,0,0
524288,1,100,100,0,1,0,0
'Access specification name,default assignment
Database - Read,ALL
'size,% of size,% reads,% random,delay,burst,align,reply
8192,100,67,100,0,1,0,0
'Access specification name,default assignment
Database - Write,ALL
'size,% of size,% reads,% random,delay,burst,align,reply
8192,100,33,100,0,1,0,0
'Access specification name,default assignment
Workstation - SR,ALL
'size,% of size,% reads,% random,delay,burst,align,reply
8192,100,80,80,0,1,0,0
'Access specification name,default assignment
Workstation - X-bit labs,ALL
'size,% of size,% reads,% random,delay,burst,align,reply
512,1,0,100,0,1,0,0
1024,2,0,100,0,1,0,0
2048,1,0,100,0,1,0,0
4096,50,60,80,0,1,0,0
8192,4,50,100,0,1,0,0
16384,6,50,100,0,1,0,0
20480,2,50,100,0,1,0,0
24576,2,50,100,0,1,0,0
28672,1,50,100,0,1,0,0
32768,13,70,70,0,1,0,0
49152,1,50,100,0,1,0,0
53248,1,50,100,0,1,0,0
65536,14,80,60,0,1,0,0
66048,2,50,100,0,1,0,0
'Access specification name,default assignment
Streaming Writes - THG,ALL
'size,% of size,% reads,% random,delay,burst,align,reply
65536,34,100,0,0,1,0,0
131072,33,100,0,0,1,0,0
262144,33,100,0,0,1,0,0
'Access specification name,default assignment
Streaming Reads - THG,ALL
'size,% of size,% reads,% random,delay,burst,align,reply
65536,34,0,0,0,1,0,0
131072,33,0,0,0,1,0,0
262144,33,0,0,0,1,0,0
'END access specifications
Version 2006.07.27
At the time, I did not know if single vs multiple core CPUs would make a difference in the benchmarks, so I created 2 profiles. To spawn as many workers as CPUs, just change the "Default Disk Workers to Spawn" field to "NUMBER_OF_CPUS" (minus quotes). I think what I found was that it made very little, if at all any, difference.
Hope this helps.
PS. I actually made a summary with all my results back then, ready for forum posting. I did a lot of combos (ICH9 vs SB710, stock IDE vs stock AHCI vs vendor AHCI drivers, Win7 vs Win2K3)!