Monitoring SQL query packets in real time

  • Thread starter Thread starter Sosh123
  • Start date Start date
S

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!
 
SQL Server comes with a Profiler application that let's you do just that.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to update the sql query data in the background silently? 2
Am I disturbing a machine in production floor if I access its database remotely? 4
persistent cache in SQL Server 17
ASP 1.1 and SQL 2005 2
Can web "page refresh" make the sql statemens execute? 3
sql timeout from web application problem (works good in sql server 2
IIS Health Monitoring via ASP.NET 1
Session State Sql with webDev.webserver SLOW 2

Back
Top