Toad World® Forums

Problems w/ Benchmark Factory tool .

We are facing below problems w/ Benchmark Factory tool .

1)Installed BMF on a machine and registered the license but when we login to same machine w/ different credentials it shows the tool is installed but shows trail mode for other users.

2)Running BMF TPC-H Test for MS SQL SERVER w/ Scale factor of 30 which should create database of Size ~30 GB but actually it creates Database size of more than 60 GB excluding logs.

3)Also when we run test for 3 mins by execution it actually runs for more than 24 mins .

Thanks

Abhimanyu

Comments inline below:

From: manyu.pune [mailto:bounce-manyupune@toadworld.com]

Sent: Tuesday, December 03, 2013 3:29 AM

To: bmf@toadworld.com

Subject: [Benchmark Factoryfor Databases - Discussion Forum] Problems w/ Benchmark Factory tool .

Problems w/ Benchmark Factory tool .

Thread created by manyu.pune

We are facing below problems w/ Benchmark Factory tool .

1)Installed BMF on a machine and registered the license but when we login to same machine w/ different credentials it shows the tool is installed but shows trail mode for other users.

[BERT] BMF licenses are per “named user” so this is correct behavior.

2)Running BMF TPC-H Test for MS SQL SERVER w/ Scale factor of 30 which should create database of Size ~30 GB but actually it creates Database size of more than 60 GB excluding logs.

[BERT] This was a known issue and should be corrected in the upcoming 6.93 release.

3)Also when we run test for 3 mins by execution it actually runs for more than 24 mins .

*** [BERT] In most cases when BMF tests run long there are a database config/setup or optization/tuning issues. For example if I run 300 GB TPC-H on Oracle without collecting
statistics the queries run 24 hours without completing – and with statistics collected the benchmark runs in 45 minutes.***

Thanks

Abhimanyu

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Benchmark Factory - General
notifications altogether.

Benchmark Factoryfor Databases - Discussion Forum

Flag
this post as spam/abuse.

Hi Bert,

Thanks for quick response.

Regarding question 3 :Below are the configuration for SQL Server database on which TPC-H test is running.

1)Database has 4 datafiles /4 index files /1 log file and 1 primary data file and all are on different drives

2)Updated the statistics as well

3)Rebuild the index as well.

But still the test run’s for more than 25 mins.

Regards

Abhimanyu

The tool is working as intended. Read this blog. www.toadworld.com/…/benchmarking-reality-vs-perception.aspx

BMF does one thing - stress the database. If the stress induced does not work as fast or well as you expect - then BMF did it’s job - it exposed a DB problem. Then it’s up to the DBA and their dianostic/performance tools to correct.