Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jalijack
Starting Member
2 Posts |
 Posted - 2008-01-24 : 06:36:16
|
Hi,I have a web application using Stored Procedure (SP). I see that there's a SP taking long time to execute. I try to capture it by Profiler Tool, and find out that with the same SP on the same db with the same parameter. The duration of executing by my web app is far bigger than the duration of executing on SQl server management studio - query windowPlease see the image attached Any ideas for this issue?Thanks a lot |
|
|
pootle_flump
1064 Posts |
Posted - 2008-01-24 : 07:16:22
|
| Try recomiling the procedure and try both again. |
 |
|
|
jalijack
Starting Member
2 Posts |
Posted - 2008-01-24 : 21:54:32
|
| Thank you,I'm trying |
|
|
|
|
|
|
Stored Procedure executing durations are different