Re: SQL Profiler producing phantom traffic
From: Narayana Vyas Kondreddi (answer_me_at_hotmail.com)
Date: 08/31/04
- Next message: Jacco Schalkwijk: "Re: Deleted .LDF File how can the database be brought back online"
- Previous message: Sanjay: "Re: Delete via linked server"
- In reply to: Wex: "SQL Profiler producing phantom traffic"
- Next in thread: anonymous_at_discussions.microsoft.com: "Re: SQL Profiler producing phantom traffic"
- Reply: anonymous_at_discussions.microsoft.com: "Re: SQL Profiler producing phantom traffic"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 31 Aug 2004 20:58:33 +0100
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?
- Next message: Jacco Schalkwijk: "Re: Deleted .LDF File how can the database be brought back online"
- Previous message: Sanjay: "Re: Delete via linked server"
- In reply to: Wex: "SQL Profiler producing phantom traffic"
- Next in thread: anonymous_at_discussions.microsoft.com: "Re: SQL Profiler producing phantom traffic"
- Reply: anonymous_at_discussions.microsoft.com: "Re: SQL Profiler producing phantom traffic"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
