Res. time of store procedure
we are testing an application who's info as follows
1. vb as frontend and sQL/Oracle as backend.
2. Application uses dsn less connection to connect the backend.
We did with Oracle (2tier)and ODBC protocol and is getting result.
In that response time of store procedure is coming as consolidated one.
we want to find the response time for each and every query of the store Procedure.
How can we achive this?
thanks in advance.
Re: Res. time of store procedure
Use a SQL profiler tool, filtered to the relevant stored procs. Ensure that you are capturing start and end time as well as duration.
This will give you your timings.