The SQL query is a single select statement and the execution plan is not showing multiple queries, I don't see any evidence of looping or RBAR.

Excuse my ignorance, but the sp_WhoIsActive procedure is telling me that the wait type is ASYNC_NETWORK_IO. Does that not mean that the query as already been run and the data...

Okay, so I have started using sp_WhoIsActive instead of sp_who/sp_who2, thanks for that, it really is an awesome tool.

I am now trying to determine what is causing the queries to...

Thanks guys. I will give those suggestions a try and revert back later (the server is in the US, they are only waking up later:-))

Thanks for the quick reply.

I believe the application is timing out because of a long wait on SQL Server for a response. I think these suspended queries are blocking other...

Okay, great, thanks for the response