Does it gone till your DB (all applications) to stp working?

i want the table structure and exact select query to help you.

Meanwhile check the joins is it operating on the indexes of the respective tables. when even you face time out is anything running on the server?

Try profiler to find out the poor query (even query in SP) using the running time.