RPC:Completed Duration diffrent while running in web application and Managment studio

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alex-From-Montreal - 23 Jul 2008 20:03 GMT

Hi ,
I have web form calling stored procedure on sql2005
I use profler to trace execution, RPC:Completed duration is close to
8 minutes

When I execute this procedure with same or diffrent params from
managment studio
it takes 8-10 seconds to complite

procedure retun 4 rows of data
Since in both cases procedure executed on server ,execution time
should be similar.
Can I get more info from profler ?
Audit login event show same set options

Thanks
Alex

Reply to this Message

Andrew J. Kelly - 23 Jul 2008 20:20 GMT

Most likely you were getting blocked during the first execution and not on
the second. If this is consistent you need to trace it to see what is
different. It could be the client executing the sp is not functioning
properly either.

Signature

Andrew J. Kelly SQL MVP
Solid Quality Mentors

> Hi ,
> I have web form calling stored procedure on sql2005
[quoted text clipped - 13 lines]
> Thanks
> Alex

Reply to this Message