Thread: recommended benchmarks
Hi all, I still have an dual dual-core opteron box with a 3Ware 9550SX-12 sitting here and I need to start getting it ready for production. I also have to send back one processor since we were mistakenly sent two. Before I do that, I would like to record some stats for posterity and post to the list so that others can see how this particular hardware performs. It looks to be more than adequate for our needs... What are the standard benchmarks that people here use for comparison purposes? I know all benchmarks are flawed in some way, but I'd at least like to measure with the same tools that folks here generally use to get a ballpark figure. Thanks, Charles
On Fri, 2006-09-22 at 13:14 -0400, Charles Sprickman wrote: > Hi all, > > I still have an dual dual-core opteron box with a 3Ware 9550SX-12 sitting > here and I need to start getting it ready for production. I also have to > send back one processor since we were mistakenly sent two. Before I do > that, I would like to record some stats for posterity and post to the list > so that others can see how this particular hardware performs. > > It looks to be more than adequate for our needs... > > What are the standard benchmarks that people here use for comparison > purposes? I know all benchmarks are flawed in some way, but I'd at least > like to measure with the same tools that folks here generally use to get a > ballpark figure. Check out the OSDL stuff. http://www.osdl.org/lab_activities/kernel_testing/osdl_database_test_suite/ Brad.
> On Fri, 2006-09-22 at 13:14 -0400, Charles Sprickman wrote: > > Hi all, > > > > I still have an dual dual-core opteron box with a 3Ware 9550SX-12 > sitting > > here and I need to start getting it ready for production. I also have > to > > send back one processor since we were mistakenly sent two. Before I do > > that, I would like to record some stats for posterity and post to the > list > > so that others can see how this particular hardware performs. > > > > It looks to be more than adequate for our needs... > > > > What are the standard benchmarks that people here use for comparison > > purposes? I know all benchmarks are flawed in some way, but I'd at > least > > like to measure with the same tools that folks here generally use to get > a > > ballpark figure. > > Check out the OSDL stuff. > > http://www.osdl.org/lab_activities/kernel_testing/osdl_database_test_sui te > / > > Brad. > Let me know what tests you end up using and how difficult they are to setup/run- I have a dell 2950 (2 dual core woodcrest) that I could probably run the same tests on. I'm looking into DBT2 (OLTP, similar to TPC-C) to start with, then probably DBT-3 since it's more OLAP style (and more like the application I'll be dealing with). What specific hardware are you testing? (CPU, RAM, raid setup, etc?) - Bucky
If the real world applications you'll be running on the box are Java (or use lots of prepared statements and no stored procedures)... try BenchmarkSQL from pgFoundry. Its extremely easy to setup and use. Like the DBT2, it's an oltp benchmark that is similar to the tpc-c. --Denis Lussier http://www.enterprisedb.com On 9/22/06, Bucky Jordan <bjordan@lumeta.com> wrote: > > On Fri, 2006-09-22 at 13:14 -0400, Charles Sprickman wrote: > > > Hi all, > > > > > > I still have an dual dual-core opteron box with a 3Ware 9550SX-12 > > sitting > > > here and I need to start getting it ready for production. I also > have > > to > > > send back one processor since we were mistakenly sent two. Before I > do > > > that, I would like to record some stats for posterity and post to > the > > list > > > so that others can see how this particular hardware performs. > > > > > > It looks to be more than adequate for our needs... > > > > > > What are the standard benchmarks that people here use for comparison > > > purposes? I know all benchmarks are flawed in some way, but I'd at > > least > > > like to measure with the same tools that folks here generally use to > get > > a > > > ballpark figure. > > > > Check out the OSDL stuff. > > > > > http://www.osdl.org/lab_activities/kernel_testing/osdl_database_test_sui > te > > / > > > > Brad. > > > > Let me know what tests you end up using and how difficult they are to > setup/run- I have a dell 2950 (2 dual core woodcrest) that I could > probably run the same tests on. I'm looking into DBT2 (OLTP, similar to > TPC-C) to start with, then probably DBT-3 since it's more OLAP style > (and more like the application I'll be dealing with). > > What specific hardware are you testing? (CPU, RAM, raid setup, etc?) > > - Bucky > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org >