On our sql server, most of the times the queries run fast same query and the same query again taking too long to execute
and going into loop, on the reports it says loading and i wait almost an hour it doesn't time out.
I copied the exact query to sql server query analyzer and the same behaviour.
Not sure how to copy my activity monitor. here.
Please any suggestions advice.