where can i download a sql load test program?

Question

is there any where to download a sql load test program

I am a sql developer, I would like to have a simple program where I could execute a sql script and know the performance. Like "we can select 1000 different customer profiles a minute" I would like it to be a general tool which would both give me general stats, and be able to very the data. Lets say select a number between 1 and 1000 each time, so we were select different profiles.

does anyone know about a simple tool like this?

Answer 1

Hi, can you emphasize on the SQL Load Test Program. For instance what is your outcome to use such application.

To test if the sql connection is valid within an application, the drivers JDBC/ODBC/ADO which are the main ones 99% people use them.. already deal if the database connection method failed. If it failed it will return false.

So look into your api for the sql application your doing and see what the connect method returns.

Sorry if i answered your question differently, please clarify things :)

Answer 2

the tool depends on the database. for example, programs that work for oracle may not work for ms sql server. you will need to specify the database server you need a tool for

import your data into excel. excel has many charting features and you can use vb script to add customized functions.

there are many freeware ODBC tools, but many just for querying.

try eclipse and the web reporting: BIRT http://www.eclipse.org/birt/phoenix/