How can i test my SPs and Functions

Hi,
I want to Know How can i test my SPs and functions for load and
performance. Is there any third party Tools available for this .
Thanking you
Aneesh
could look at OStress as per below
http://support.microsoft.com/default...b;en-us;887057
I've also used SQLLS that used to be in the Back Office 4.5 / SQL 7 Resource
Kit to good effect
cheers,
Andy.
"AR" <aneesh.r@.eostek.com> wrote in message
news:eote$Oc3EHA.536@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I want to Know How can i test my SPs and functions for load and
> performance. Is there any third party Tools available for this .
> Thanking you
> Aneesh
>