Re: test/development databases

Yep, testing tools can help you do this. Their tools will let you record something that
your user does. then you need to go in and parameterize this 1 script and run it
100's of times w/ different data. This isn't always as easy as it seems. And some
programming can be required. Mercury's product to do "load testing of a server" is
called LoadRunner. It is a great tool to see if your dbase can support 50 users, or 100, or 1000's of users.
It gives you a way to set up repeatable tests that you can run over and over.
 It actually records the SQL statments to the dbase. Remember that none of this is as easy as it sounds and will take time to do. Esp.
to get valid tests. And Mercury is expensive. I don't know much about the other tools.
( I use to work for Mercury Interactive. ) Good luck
Stephanie

Dennis Reed wrote in message <6l9mf6$c9v1_at_news02.comp.pge.com>...
>I am in the process of migrating a SCO Unix / 7.1.4 database to NT4 /
>7.3.3. Before I roll the NT box into production and shut down Unix,
>my boss wants me to hammer the **** out of NT to make sure it won't
>die under load.
>
>Does anybody know a way to record transactions hitting an Oracle
>database for later playback against that or other databases? In
>other words, I want to simulate load by replaying real-time
>transactions instead of by wasting user time (more realistic, anyway).
>
>Thanks,
>Dennis Reed, djr3_at_pge.com
>DBA, Procedure Services
>Pacific Gas & Electric Co.
>
Received on Tue Jun 09 1998 - 00:00:00 CDT