RE: How to test the performance of a Database?
It all depends what you want to do , I use timex command
to time individual programs performance or for a SQL .
My last benchmark had a requirement of 2000 users running
10 different programs (order entry , AP , AR , EDI etc .. )
Each of the applications had a specific number of users which
were spilt into different groups some were typing much faster then others ,
also remember you must use data in a logical patter , you do not
want 500 users ordering the same item for the same customer at the same
time , all this to say that the captured program does much more then
sending pre-recorded characters into the pipeline , it has logic
which simulates as closely as possible what the users within a
organization would be doing .
Also this involves many machines and networking issues , managing
such a project would be impossible using shell scripts .....
Now if you looking to spent 4-6 millions on hardware/software and you
want to know which vendor will perform best, spending 100-200K is not
that much ...
> -----Original Message-----
> From: McKenzie Chris- [SMTP:Chris_McKenzie@europe36.mot.com]
> Sent: Friday, September 17, 1999 4:22 AM
> To: Mariusz Malogrosz; informix-list@iiug.org
> Subject: RE: How to test the performance of a Database?
>
> >>All those tools are very expensive , easy to spent 100K + on a
> benchmark
>
> Alternatively a cheaper (if less elegant option) is to create files which
> simulate user interaction (not sure how to simulate coffee spills etc
> though). To do this try
>
> $ tee somefilename | program (ie xxx.4ge)>
> This runs the program and captures the input into the file "somefilename".
> Use Interrupt to end the tee session.
>
> create a new file ie filename.run and put in it
>
> echo "the string from somefilename"
>
> Now to run you just do
>
> $ filename.run |program (ie xxx.4ge)>
> If you want to monitor the performance you can use time ie
>
> $ time filename.run |xxx.4ge>
> To simulate alot of users simply put the above into a script with a loop.
>
> It's quick it's dirty(ish) but it doesn't cost $100K and it does highlight
> any major performance issues
>
> Cheers,
>
> Chris.
>
> Ps those with better shell skills than me will probably improve on the
> above.
>
>
> -----Original Message-----
> From: Mariusz Malogrosz [mailto:mariuszm@tecsys.com]
> Sent: 16 September 1999 19:21
> To: informix-list@iiug.org
> Subject: Re: How to test the performance of a Database?
>
>
> I worked on benchmarks and used the following
>
> Mercury Loadrunner
> Performix
> Rational Prevue
>
> The way it works is that you can record ( capture ) a session of an
> application ,
> the replay it by # of users , the scripts are written in a "C" like
> language
> , usually
> you have to populate you dbs with pattern data and then you make the
> scripts
> generate the keys within the range of your data pattern .
>
> It allows not only to test you db performance but also your app
> performance
> ,
> data contention and the hardware itself .
>
> I know that Prevue also supports driect ODBC like connections to push
> SQL's to the dbs .
>
> All those tools are very expensive , easy to spent 100K + on a benchmark
> .
>
> Mariusz
>
>
>
> Chakri Paila <chakri@nortelnetworks.com> wrote in message
> news:37E0FD34.BD64564@nortelnetworks.com...
> > Hi all,
> >
> > I am trying to find out if there is a tool to generate queries (large
> > number) for doing some stress testing of the database.
> >
> > TIA
> > Chakri
> >