Re: SQL Profiler producing phantom traffic

From: Gert E.R. Drapers (GertD_at_SQLDev.Net)
Date: 09/07/04 

Date: Tue, 7 Sep 2004 16:13:28 +0200

On which socket port? Profiler is using a regular client connection to fetch
the result set and the server does not ping a client, unless you are using
SQL Server "Yukon" with query notification.

GertD@SQLDev.Net

Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2004 All rights reserved.

<anonymous@discussions.microsoft.com> wrote in message
news:3a8e01c48f9b$635934f0$a501280a@phx.gbl...
> The SQL server is trying to "ping" the client machine. The
> firewall is doing its job and stopping the packets. The
> only reason we know it is a profiler issue is because when
> profiler was shut down on the client machine the pinging
> from the server stopped. I already looked for server side
> traces, but none were present. Server in question is
> clustered.
>>-----Original Message-----
>>Can you show us what sort of traffic you are referring to?
>>
>>Could it be that there was a server side trace running?
> You can verify this
>>using fn_trace_getinfo function.
>>--
>>Vyas, MVP (SQL Server)
>>http://vyaskn.tripod.com/
>>
>>
>>"Wex" <anonymous@discussions.microsoft.com> wrote in
> message
>>news:3a4d01c48f8d$25b38820$a601280a@phx.gbl...
>>> 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: What doesnt lend itself to OO?
    ... >> proxy and instructs the server to constuct the real object. ... rather than client code. ... If 'clock' is instantiated in the server, ... > for the server interface at the OOA level. ...
    (comp.object)
  • This is going straight to the pool room
    ... or not the client has privilege to do what they're trying to do, ... The server environment is this: ... 3GL User action Routines that Tier3 will execute on your behalf during the ... Routine Name: USER_INIT ...
    (comp.os.vms)
  • [Full-Disclosure] R: Full-Disclosure Digest, Vol 3, Issue 42
    ... Full-Disclosure Digest, Vol 3, Issue 42 ... SD Server 4.0.70 Directory Traversal Bug ... Arkeia Network Backup Client Remote Access ...
    (Full-Disclosure)
  • Re: performance of 2 queries
    ... That depends on which way this app will need to scale. ... A db server will be much more ... get sub-second results even on modest client PCs and without a round-trip to ... >> I've looked at the profiler utility and from what I can tell the first ...
    (microsoft.public.sqlserver.programming)
  • Re: performance of 2 queries
    ... That depends on which way this app will need to scale. ... A db server will be much more ... get sub-second results even on modest client PCs and without a round-trip to ... >> I've looked at the profiler utility and from what I can tell the first ...
    (microsoft.public.vb.database)