Monitoring SQL query packets in real time

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!

re: Monitoring SQL query packets in real time

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

"Sosh123" <sosh@so9sh.com> wrote in message
news:uq72nyrZFHA.3572@TK2MSFTNGP12.phx.gbl...[color=blue]
> 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![/color]

re: Monitoring SQL query packets in real time

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

Marina wrote:[color=blue]
> SQL Server comes with a Profiler application that let's you do just that.
>[/color]