You will no longer receive e-mail notifications from this forum.
Log-In to post
I've been trying to run Benchmark Factory against both the Open Source PostgreSQL and the EDB Postgres Advanced Server via ODBC. On both I get the following error when creating objects for TPC-C:
Started test Create Objects for TPC-C
ODBC Error (42P07,7) - ERROR: relation "tpc_c_properties" already exists;
Error while executing the query
Any ideas on how to get past this? The tables appear to have all been created.
I'm new to the product (i'm actually trialing it to see if we use it across our organisation) and I was hoping for some assistance in setting up a test to cover our key needs.
I'd like to be able to run executions of our most used stored procs at the same time (i.e. EXEC usp1; EXEC usp2 & EXEC usp3) and then scale that up to running those three usp's (at the same time) for up to 100 simultaneous users.
How do i configure the test to get the three usp's to run at the same time on one test ? If i configure multiple statements in a Scalability test they run one after each other.
I'm running tpc-e test, test completes without errors, but at the end of the run says: "No results found in the repository for this test run".
Checked error logs at: C:\Users\Administrator\Documents\My Benchmark Factory\Error Logs
But could not see any related error.
Just getting started with Benchmark Factory sp apologies in advance for the stupid question - maybe I'm coming at this completely the wrong way
I want to test a stored procedure that executes a lot of comoplicated stored procedures. This Main stored procedure takes a single integer parameter value ("key Value")
To provide a list of viable Key values to be passed to the the SPROC I have created a lookup table of 1 million rows (1 million unique key vals) each with a sequential rownum for use as a means of generating a good keynnum value for the parameter to the sproc. Table looks like this (the keyvals are non sequential and basically random trying to to randomly pick a keyval would have a high miss rate)
RowNo KeyVal1 3625525
The plan is to pass a random number to the BF scalability job that calls the stored procedure (I want to test something like $BFURandRange(1,1000000) ) and then the agent uses that random number to go to the lookup table table and get the key value for the matching RowNo value and pass it to the sproc via the bound sproc parameter value
However the problem is that it just picks the same number every time and so I end up erroring out after 5 rows. How can I make it pick a different random number for Rowno each time so that I can get a different keyVal each time?
And to really put the bonus icing on the cake how can I guarantee that it never picks the same random number more than once?Thanks a million for any insight - as I say, maybe I'm coming at this completely the wrong way
I have Benchmark Factory 7.3 installed. I am new to this. when I was trying to create a new connection for a SQL 2008 database, I only see oracle from the drop down list, there is no SQL server I can select, why?
I have been working on capturing and playing back workloads. I tried a simple test where I captured a work load consisting of several select statements and was able to play it back successfully.
Next I captured 20 minutes of users testing their application. The capture went ok but when playing it back it fails with the following error :-
ORA-06550: line 1, column 7:PLS-00306: wrong number or types of arguments in call to 'DESCRIBE_PROCEDURE'
Any ideas as to how I would get past this problem ?
After capture workload finished, i tried to reply this on oracle database server
File does not contain any SQL to import that was not a dependent statement"
we should enable something on database server to get on all sql statements which run on database???
from where BMF will get on all sql statement which run before on oracle database server
I want to test database server hardware resources during workload such as CPU , Memory, I/O percentage usage (%)
How much database consume CPU, memory during workload from benchmark factory for databases
when i try to using benchmark factory for databases to capture workload from oracle database.
I shared folder in benchmark client machine to use this folder share in both directory server & client directory
but i don't know how write network path
the issue in capture directory
Shared folder "everyone can access this folder full control"
I would appreciate your help, I am doing a case study database comparison. I utlizando Factory realizanção benchmark for TPC-C test. My biggest difficulty is to understand the results generated by the test could give me a brief explanation of what each one of them? And which of them consider to put in my documentation?
sorry my english!!!
I don't understand result summary when run TPC test
there is 3 axes, one of them indicate to user load & the other is response time but what about the last one in the right indicate for what ?
and also response time is very high for 1 user load ..how this happen
for 1 user load...response time was 9.25 ms
for 10 user load..response time was 3.25 ms
The curve of tps I got is always as follow, bouncing from zero to the peak value.
Is this normal? Why zero appears?
The Performance Metric for TPCE is expressed in transactions-per-second-E (tpsE). But I cannot find the value of tpsE even in the detail report.
Moreover, the report of TPCC shows the response time of each transaction and 90th percentile, but I cannot find that in the report of TPCE as well.
So, should I setup something to make these displayed, or BF cannot show these now?
Hey Guys! II am encountering an error when running the benchmark in MySQL Enterprise database, well I can run TPC-C with 1,4,6 .. When I use up 10+ user loads, the following message appears
Agent (PRED 40-152) Error: New Order: Getting Timed Out Order Number Transaction "New Order Transaction" run failed by one virtual user agent in one of PRED40-152
I'm using 10 agents, my database is 10GB (Windows)
Note: I have tested it with more agents and the message is the same
Sorry my English!
Hi guys!I have a question about 2 results of my test. Could give a brief introduction of the meaning of termsAvg "Think Time":Avg "Keying Time":
Sorry my English.
I didn't understand we use SQL stability test to test specific SQL statement when more than users working on database or what?
When i used benchmark factory to capture workload from SQL server production, i don't know how replay this capture file against test environment
please help me in details how do this?
which transaction is used during benchmark standard test, if the test run query or what?
and if the test run query which SQL statements is used?
I wanna to know the concept for this tool when i use benchmark standard tests which SQL statements used during test
how the tool test the database by virtual users? what type of load is using "execute SQL statement or what?
Please i want to know where we have to install agent on test database server or where exactly?