Sql Server Profiler traces timeout in web application

Question

I am trying to run a trace with the Sql Server Profiler against an Asp.NET web application running on a Visual Studio development server.

However, whenever the tracing is done, all the db requests from the web application do not give me an error message:

"The timeout period has passed. The timeout period expires before the operation completes or the server does not respond."

If I stop tracing, the web application is working again.

Any input on this basis.

Answer 1

You just need to increase the CommandTimeout on the sql connection during debugging and application pool timeout values.

Answer 2

- , ( , ).

, IO - /. . , .

( sql server 2005) , (DTA), .

sql-....

http://www.red-gate.com/products/SQL_Response/offers/mastering_sql_profiler_ebook.htm

, , DTA , , , .

, , , 10-20- .

-, sql , .

Answer 3

, ?

:

ALTER DATABASE [database name] SET MULTI_USER;