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 |
|
amolrk7
Starting Member
1 Post |
 Posted - 2008-04-22 : 03:50:11
|
| Hi I have a SP which is running slow, when traced in SQL Profiler, SP:Completed shows 6.3 secs and SQL:StmtCompleted shows 30 secs. I used Print statements (to print start and end time) in the SP in the very beginning and end and when executed shows time time diff of only 6.3 secs but overall execution takes 30 secs. Why is this happening?Any suggestions?-- Amol |
|
|
coolerbob
Aged Yak Warrior
841 Posts |
Posted - 2008-04-22 : 08:16:28
|
| Can you show us the query? |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-22 : 23:10:52
|
| Did you check execution plan? |
|
|
|
|
|
|
Performance Issue