SQL Profiler producing phantom traffic

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Wex (anonymous_at_discussions.microsoft.com)
Date: 08/31/04 

Date: Tue, 31 Aug 2004 12:03:05 -0700

I have a user who is running SQL Profiler on their client
machine. During the devlopment phase of this project they
used profiler to help with their coding. Now that we have
taken the project to staging and production they no longer
have the necessary rights to run profiler.

Here is the problem: Our firewall is blocking traffic
between the users machine and the SQL server. Regardless
of which machine the user connects to with profiler (he is
using it for other projects), there is traffic that is
produced about every second as the SQL server tries to
respond to profiler. The user is NOT trying to run any
traces against the SQl Server. Even if he was, our
firewall blocks the traffic.

Thanks

Does any one have any ideas how to stop this unnecessary
traffic?

Relevant Pages

  • Re: Sql 2005 Profiler
    ... Jasper Smith (SQL Server MVP) ... the server reported both duration and CPU ... I'm using a trc file to do the load testing through profiler. ...
    (microsoft.public.sqlserver.tools)
  • Re: SQL Profiler
    ... > ich verwende SQL Server 2000. ... > die mir mit SET STATISTICS ON; ... > Ich habe im SQL Profiler unter "Leistung" Execution Plan, ...
    (microsoft.public.de.sqlserver)
  • Re: Sql 2005 Profiler
    ... In SQL Server 2000, the server reported both duration and CPU time ... I'm using a trc file to do the load testing through profiler. ...
    (microsoft.public.sqlserver.tools)
  • Re: Clueless in 80040e31 land
    ... Locks event in Profiler to see if this is the case. ... Using SQL Profiler was no help. ... single quote, or something that is difficult to catch, but after many ... You should turn on NOCOUNT to avoid sql server sending informational ...
    (microsoft.public.inetserver.asp.general)
  • Re: ADO.NET query execution much slower than SQL Management Studio
    ... Stats being compiled on SQL Server ... If you are dynamically adding statements in a sproc, ... compare this to the profiler command (meaning what is actually run in the ... Duration: 440 ...
    (microsoft.public.dotnet.framework.adonet)