• If you're looking to track how long each query is taking you can have profiler log to a table or a file and then do averages on the duration. If you're logging to file you can use fn_trace_gettable to access the information in a query window.

    Don't forget to take the network into account when considering the cause of problems like this. Do either the client or the server have any errors in Event Viewer when this is happening?