Hi,
I got a weird problem. I've created a sp that takes in the query analyzer 7 seconds to run. When i put in my code dataAdapter.Fill(dataSet.Tables(0)) it takes forever to finish!!
What's going on?
Any thoughts highly appreciated.
t.i.a.,
ratjetoes.
Hi ratjetoes,
To troubleshoot this problem, we can do the following:
1. Use Profiler to track every activity of the query, including opening the connection. Check in the trace log to see if it is the query that takes 7 sec.
2. If it is the query that takes long time running, please put it in Query Analyzer to see which part is blocking to whole query.
HTH. If anything is unclear, please feel free to mark the post as Unanswered and post your reply. Thanks.
No comments:
Post a Comment