Monitoring SQL query packets in real time

[Sosh123]

Hi,

I was wondering if there is a way with VS.NET and SQLsvr/MSDE to monitor
query activity in real time whilst I am debugging an ASP.NET
application. I want to see when queries are made to the SQL server, so
that I can check the effectiveness of my fragment caching.

Any info appreciated!

 

[Marina]

SQL Server comes with a Profiler application that let's you do just that.

 

[Sosh123]

Ah yes, works a treat. Had never used it before. Thanks!