Sql Server Profiler trace gives timeout in webapplication

Question

I'm trying to run a trace with Sql Server Profiler against an Asp.NET Website Application running in Visual Studio development server.

However, whenever the trace is running, all db requests from the web application fails giving me the error message:

"Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."

If I stop the trace, the web application works again.

Any input on this is appreciated.

Answer 1

You just need to increase the CommandTimeout on the sql connection while you are debugging and the application pool timeout values as well.