Thanks marina,
No its query time only, because i can see SPID of .net app in sysprocess
table in runnable state for long time.
There is no transaction going on.
Moreever why query analyzer is executing same query faster from the same
client machine.
Thanks
"Marina Levit [MVP]" <so*****@nospam.com> wrote in message
news:uH**************@TK2MSFTNGP04.phx.gbl...
Are you sure that is just the query running time, or is other processing
taking place as well.
Also, is there any thing else going on, transactions, etc?
"vicky" <v@v.com> wrote in message
news:eI**************@TK2MSFTNGP03.phx.gbl...I have a query which runs under 15 sec. through query analyzer. But when
same query is getting executed by .net console application, using ado.net,
it takes 10-15 min. What can be the problem?