DB Stored Procedure Performance Help

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

DB Stored Procedure Performance Help

Anil Gaur
Hi All,

I want to do performance testing for DB stored procedures using Jmeter. As per requirement I have multiple DB stored procedures and need to identify the performance of all these.

 Can someone help me that how can I achieve this .
Also what different type of test I can do using Jmeter for these stored procedures.



Thanks
Anil

Reply | Threaded
Open this post in threaded view
|

Re: DB Stored Procedure Performance Help

Yngvi Þór Sigurjónsson
Hi
Few years back I had to test some Oracle stored procedures, What you need
to consider is that databases are sometimes lazy and don't actually do
anything until they need to. So if the procedures are returning
cursors/ResultSets you will need to exhaust the ResultSet to get the real
execution time of the procedure.

I had to do some scripting to loop over the ResultSet to make sure all
execution time was accounted for. I actually had to make make a patch for
jmeter at the time to add the Handle ResultSet option so that you could
specify that Result Sets are stored as Objects, and not as String, so that
you can use it in your script. I also added the Count Records option to
loop through result set, but I believe someone changed it so that it does
not actually iterate the result set but rather calls last() on it and that
method is not implemented on Oracle JDBC at least.

I still have the config I used back home but I don't really know when I
have the time to check it. But possibly it was all done on a clients system.

Regards
Yngvi


On Thu, Apr 12, 2018 at 12:33 PM Anil Gaur <[hidden email]> wrote:

> Hi All,
>
> I want to do performance testing for DB stored procedures using Jmeter. As
> per requirement I have multiple DB stored procedures and need to identify
> the performance of all these.
>
>  Can someone help me that how can I achieve this .
> Also what different type of test I can do using Jmeter for these stored
> procedures.
>
>
>
> Thanks
> Anil
>
>
Reply | Threaded
Open this post in threaded view
|

Re: DB Stored Procedure Performance Help

Anil Gaur
Any one have another approach for above scenario?


Thanks
Anil Gaur
________________________________
From: Yngvi ??r Sigurj?nsson <[hidden email]>
Sent: Thursday, April 12, 2018 1:48 PM
To: JMeter Users List
Subject: Re: DB Stored Procedure Performance Help

Hi
Few years back I had to test some Oracle stored procedures, What you need
to consider is that databases are sometimes lazy and don't actually do
anything until they need to. So if the procedures are returning
cursors/ResultSets you will need to exhaust the ResultSet to get the real
execution time of the procedure.

I had to do some scripting to loop over the ResultSet to make sure all
execution time was accounted for. I actually had to make make a patch for
jmeter at the time to add the Handle ResultSet option so that you could
specify that Result Sets are stored as Objects, and not as String, so that
you can use it in your script. I also added the Count Records option to
loop through result set, but I believe someone changed it so that it does
not actually iterate the result set but rather calls last() on it and that
method is not implemented on Oracle JDBC at least.

I still have the config I used back home but I don't really know when I
have the time to check it. But possibly it was all done on a clients system.

Regards
Yngvi


On Thu, Apr 12, 2018 at 12:33 PM Anil Gaur <[hidden email]> wrote:

> Hi All,
>
> I want to do performance testing for DB stored procedures using Jmeter. As
> per requirement I have multiple DB stored procedures and need to identify
> the performance of all these.
>
>  Can someone help me that how can I achieve this .
> Also what different type of test I can do using Jmeter for these stored
> procedures.
>
>
>
> Thanks
> Anil
>
>