473,503 Members | 2,167 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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!
Nov 19 '05 #1
2 1212
SQL Server comes with a Profiler application that let's you do just that.

"Sosh123" <so**@so9sh.com> wrote in message
news:uq**************@TK2MSFTNGP12.phx.gbl...
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!

Nov 19 '05 #2
Ah yes, works a treat. Had never used it before. Thanks!

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


Nov 19 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

24
5408
by: omlet | last post by:
omlet v4) wrote in message Dear DBA, You are cordially invited to test and review our windows native and 100% pure Java Oracle 9i/8i Monitoring Application (OMLET). OMLET is the Ultimate Visual...
3
3358
by: Geof | last post by:
Hello, I need to write an application to monitor incoming UDP packets on a specific port. This UDP port is already in use by a third party application. The goal is : to execute some code...
1
1568
by: ygy | last post by:
When I receive the UDP packets,and then Set the image pixel using Image::Setpixel(),but When I invalidate the interface to show the image,the UDP packets missed.How to solve the problem? thank you...
7
13362
by: Mark | last post by:
Hello, I have researched and tried every thing I have found on the web, in groups and MS KB articles. Here is what I have. I have a Windows 2000 Domain Controller all service packs and...
0
1368
by: Brian | last post by:
I've deployed a 'URL rewriter' version of our application almost two months ago and it is working great (.NET 1.1, Win2k, IIS5). Since then, I've gotten just FOUR exceptions that look like this: ...
5
2379
by: Björn Olsson | last post by:
Hello All. If I where to capture network traffic, dropping packets and modifying packets. I.e write firewall functionality. Which API or SDK would be the correct choice? I would prefer to do it...
5
1924
by: Ben | last post by:
I am building a web app using ASP.NET 2.0. One of the requirements is that we link to a third party vendor's site, display their content. let the user make choices on the vendors site and then...
0
1379
by: RSL101 | last post by:
*This maybe dup msg. My earlier post never show up! I like to get your input regarding UDB performance monitoring. Our environment is IBM AIX and some linux running web applications open to US...
2
1435
by: msdngroup | last post by:
Hi, All: Can you do something like cross-browser real-time message, remote JavaScript callback and monitoring browser states remotely? Can you ensure web browser running with super speed and...
0
7205
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7093
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
1
7011
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
5596
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
5023
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
3170
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1521
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
747
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
401
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.