Is there a way to view real-time query requests received by sql server from my application?

Question

Is there any VS debugging tool or option that I can use to monitor all the queries that my C # application issues to SQL Server? I would like to know how effective my C # and ORM code is in building queries, for example, how many SELECT sends at a certain time / situation, and based on this, you can issue raw queries if ORM creates complex / multiple queries.

Answer 1

Yes. SQL Profiler

Answer 2

SQL Profiler , SQL Express . FYI.

SQL Server Management Studio ( )

Tools -> SQL Server Profiler

Answer 3

Management Studio 2008. node " ". , , , :

http://msdn.microsoft.com/en-us/library/ms175518.aspx