Sorry for the delay in answering but I was out sick the last couple of days.
During the Pre-Sampling phase BMF is sending queries to the database, but any statistics captured during this time phase will not be stored in the repository. This phase is used to allow the system to get to steady state before capturing statistics. For the Sampling phase, BMF continues to send queries to the database, but all captured statistics will be stored in the repository after the iteration completes. Now typically the TPC-H is run as a Replay test, meaning that the user scenarios (streams) are executed only once, therefore the sampling period can not be set but BMF will execute the replay test with all querries being in sampling phase. Since BMF will run the complete stream, and thus all of the stream SQL querries, it can be in the Sampling phase for a long time if the querries are taking a long time, such is expected when running the TPC-H, especially at that high of a scale factor. If you want the TPC-H test to take less time to execute, you can execute it with a smaller scale factor.
I hope this helps.
|