How to replay or create scripts for standard benchmarking database objects, TPC-C, TPC-H, etc. (4297644)
7. In the drop down menu, choose "TPC-C". ... Then check the box for "Show creation objects." ... 8. Scroll through the items and check off the create index transactions listed. ... Select Next, Finish.
Duplicate Data in Transactions Statistics with Multiple Agents. (4344442)
Upon executing the TPC-C test with multiple agents running, the "Transactions Statistics" data for each agent is identical. ... WORKAROUND:
Getting error ""Missing Agent(s) to use for testing" when doing capture (4335350)
Getting error ""Missing Agent(s) to use for testing" when doing capture Error Message:"Missing Agent(s)", means that the agent(s) need to be configured for the test.<br>Click on the word 'Missing Agents' and it will bring up the Agent setup dialogue.
Getting error "Userload of XXX exceeds license amount" when doing capture (4251537)
Getting error "Userload of XXX exceeds license amount" when doing capture ... "Userload of XXX exceeds license amount" means that an additional virtual license pack needs to be purchased in order to run this test.
Compare Results tab does not show imported test results. (4223740)
Compare Results tab does not show imported test results.
When creating a profile and choosing SQL Server ODBC driver, you have to manually type in source (4236585)
When creating a profile and choosing SQL Server ODBC driver, you have to manually type in source. ... Manually type in the source ... STATUS: ... Issue fixed in version 5.0.1.
Getting incorrect results when using parameter values in Test SQL for Scalability BMF test. (4228648)
The load scenario user is using is Test SQL for Scalability, then user is using the Create Custom user scenario. ... User is working with Benchmark Factory using UDB v8.x on Windows XP. User is testing BMF and using basic sample queries.
How can you manually create the indexes for a TPC-C job on Oracle 12c? (4243787)
How can you manually create the indexes for a TPC-C job on Oracle 12c? <p>Please run the following statements against the database:</p><p>CREATE UNIQUE INDEX C_Warehouse_I1 ON C_Warehouse(w_id);<br>CREATE UNIQUE INDEX C_District_I1 ON C_District(d_w_id, d_id);<br>CREATE UNIQUE INDEX C_Customer_I1 ON C_Customer(c_w_id, c_d_id, c_id);<br>CREATE INDEX C_Customer_I2 ON C_Customer(c_last, c_w_id, c_d_id, c_first);<br>CREATE UNIQUE INDEX C_New_Order_I1 ON C_New_Order(no_w_id, no_d_id, no_o_id);<br>CREATE UNIQUE INDEX C_Order_I1 ON C_Order(o_id, o_w_id, o_d_id);<br>CREATE UNIQUE INDEX C_Order_Line_I1 ON C_Order_Line(ol_o_id, ol_w_id, ol_d_id, ol_number);<br>CREATE UNIQUE INDEX C_Item_I1 ON C_Item(i_id);<br>CREATE UNIQUE INDEX C_Stock_I1 ON C_Stock(s_i_id, s_w_id);<br></p>
What happens if the license expires. (4277711)
There are 2 types of license. ... What happen when the license expires? ... 1. If Product license is expired, then you must enter another valid product license in order to use Benchmark factory (otherwise it will stop working).
Get "...we temporarily cannot process your request..." message downloading (4238021)
The following message is received when trying to download an installer. ... Sorry for the inconvenience, we temporarily cannot process your request. ... Please log out, close your browser and reinitiate your session.
What's new in Benchmark Factory 8.3.x? (4241342)
This article contains some new features released Benchmark Factory 8.3.x? ... This release of Benchmark Factory includes the following new features and enhancements. ... If using the Benchmark Factory Agent for Linux to test against a Microsoft SQL Server database, ensure the unixODBC and msodbcsql Client are installed on the same Linux machine as the Agent.
Should Benchmark Factory be installed on a production server? (4285368)
Should Benchmark Factory be installed on a production server? ... Are there server performance impacts that running BMF on would have? <div>Running Benchmark Factory will have a big impact on a production server.
How to upload a file into the Service Request (4326641)
It can be uploaded via email if the attached file is a small one,</p><p>2. ... If the file is larger than 10 Mb. it could best to upload it directly into the case, by following these steps : </p><p></p><p> i. Go to : https://support.quest.com/</p><p> ii.
Is there an agent installation for AIX server (4307176)
Is there a benchmark agent that can be installed on an AIX 7 server? ... There are no plans to provide an agent for AIX.
With remote agent, Benchmark Factory gives error "Not all configured Agent(s) have connected in a timely manner (4275063)
Setting up both local and remote agent will cause the following error when running a test with a remote agent. ... Not all configured Agent(s) have connected in a timely manner. ... The test will completely with no results and the following message.
Error: "ORA-01406: fetched column value was truncated" when executing a select statement with Raw (4346685)
Error received when executing a SQL statement that calls a table with a "RAW" datatype column. ... If the binary raw data is at it's maximum length, Benchmark Factory will truncate the data. ... WORKAROUND:
The TPC H Result QphH@Size is missing in the report in v7.1 (4243321)
It does still show in the reports for TPC-C tests. ... WORKAROUND: ... None. ... Waiting for fix in a future release of Benchmark Factory this should be addressed in v7.3 BMF-329
Does Benchmark Factory have performance counters to monitor parameters such as CPU usage while tests are being run? (4275137)
Does Benchmark Factory have performance counters to monitor parameters such as CPU usage while tests are being run? <div>Benchmark Factory does not have any performance counters; however Spotlight (whether it be Spotlight on Oracle or Spotlight on SQL Server) can be used alone side Benchmark Factory to monitor the test environment while load is being generated by Benchmark Factory.</div><div></div><div>Trial versions of the Spotlight family of products can be downloaded here:</div><div></div><div> https://www.quest.com/products/</div>
Attempting to replay load scenario from SQL Server trace table gives error "Could Not Generate Tr (4303922)
Make sure the trace table, created in Microsoft SQL Profiler, has a valid SQL name, containing no spaces, and preferably no numbers or special characters.
Where is it best to keep a trace file? (4279272)
Where is it best to keep a trace file for replay? ... On a network Disk or Local drive where Benchmark Factory is installed. ... The answer is Network drive and it is for the following reason: Assuming that you have ten 60GB trace files to replay.
Benchmark Factory for Database (BMF) trace file replay limit (4311630)
Can BMF handle up to 60 GB trace file replay? ... BMF 6.1.1 and below has been exclusively tested and certified to handle trace file replays in the range of 5 to 10GB. ... It should be able to handle 60GB trace file replay but the chances are that it's performance will be extremely slow.
"Execute after prepare" checkbox not checked when importing a workload replay from an Oracle t (4321962)
When importing a workload replay from an Oracle trace file all the contained statements appear as PrepCursors only, without actual execution. ... WORKAROUND: ... None ... STATUS: ... Waiting for a fix to be released in a future version of Benchmark Factory for Databases.
How to change the MyDocuments\MyBenchmarkFactory folder location (4341689)
How to change the path for BMF files after install ? ... How to change the path where everything goes; at the moment everything goes into My Documents\My Benchmark Factory folder on C drive but what to do if you are running out of space there, what is the way to change the path where everything goes (Datafiles, error logs, scripts etc ...).
Error: "There is an invalid input or missing input" (4279399)
Getting the error message "There is an invalid input or missing input" when inputting License key for Benchmark Factory. ... License key format invalid. ... Request for a new license key.
When trying to load data to Netezza database, it fails to load into H_LINEITEM and H_ORDER due (4250299)
When trying to execute TPC-H standard benchmark using ODBC data source to connect to Netezza database, the tables get created successfully but when loading data, it fails to load into two tables: H_LINEITEM and H_ORDER due to failure when inserting data on column of TIMESTAMP datatype.
新产品关联性