I am having a huge difference between the time a query/sp runs in query analyzer and when an application calls thesame procedure. I have used the query profiler to trace the procedure but couldn't see anything strange in the trace. Can somebody advice on what could be responsible?
Another possibility is network I/O on the client side. If the client is buried under network I/O, you could see a difference. It depends on how big a difference there is.
K. Brian Kelley @kbriankelley
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply