Thanks James for your insight.... it really helps with my problem. I
think I notice a trend with your responses.
We have around1000 DB2 stored procedures and growing everyday but we
will only be using about 150 to 200 at a time for LOAD testing..These
usually make up about 75-80% of the transaction rate, cpu, IO, and
memory usage. We have a very rapidly growing SQL server, internal web,
and web service load, just depends on what part of multiple
applications we need to test. There will be more than 500 in a few
years...we create most of the scripts so that they are long term
reusable with minor changes. We are new to LoadRunner, but not
loadtesting. Most are low volume and won't be in the "load" test, but
we use load testing scripts for testing major new features and
functions at times too. Will already have the scripts, and it gives
us a head start on finding problems with non load changes. .Since DB2
stored procedures are written in a number of different languages, we
also need a wide range of samples in various tests for different
reasons, not just load testing. You can find a lot of issues with
OS, middleware, and DB upgrades or changes using a low volume and a
range of the same scripts as you use for load testing, we have been
VERY successful in finding (non LOAD related) problems using this
method without having to get lots of programmers and testers involved,
they still have to test but we can find and resolve most problems
before wasting their time.
We are in the process of adding QTP, Sprinter, and Service Test
scripts to other testing methods too. We did not have tools like those
before. These might not end up being so reusable due to the fast rate
of change in the applications front ends, but yes we know that there
are ways to help with that. We are just starting to learn, and I am
sure we will make a LOT of mistakes.
After sleeping on the issue, I have an idea what it might be, the new
pc's may not have the correct ODBC driver..it was recently updated and
these pc's were being used for something else. . I will check that
today. Thanks again James!
On Sep 22, 10:49 pm, James Pulley <
loadrunner-li...@jamespulley.com>
wrote: