Re: Profiler Interaction with SQL Server-Documentation

Tech-Archive recommends: Fix windows errors by optimizing your registry

Actually, the problem is with a Blocking Process. When the trace is on, the
process functions normally. When the trace is off, then we experience
extremely sporadic blocks where one process is holding up an entire string of
others that are attempting to access the same table.


"David Gugick" wrote:

>
> SQL Trace should not cause any problems with SQL Server operation.
> Profiler just uses SQL Trace (in a rather inefficient, underperforming
> way) to view database activity. Depending on the level of detail you are
> collecting and the query load on the server, you may be causing a
> performance hit on SQL Server which is slowing down transaction enough
> that you might not be seeing some problems like Deadlocks any longer.
>
> What issues are you having?
>
>
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
>
>
.

Relevant Pages

  • Re: How to distinguish b/w normal trace file and different Sessions enabled SQL trace files?
    ... Suppose more than two users generate their tracefiles through SQL Trace ... would we tag their trace files through a method as you said. ... Windows Professional Server. ...
    (comp.databases.oracle.server)
  • Re: Problem with SQL Server
    ... Since you got nothing from the SQL trace, ... with the Trace Properties. ... Security Audit / Audit Login and Audit Logout has been added to the right ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: One Web Service updates SQL, another cant?
    ... section of the Trace Properties dialog. ... And then I start getting the database closed errors on subsequent calls. ... > The error suggests that somehow the connection to SQL Server is being ... Could we have a look at your connection string? ...
    (microsoft.public.sqlserver.security)
  • RE: cannot delete a record in sql server 2005 through asp program
    ... Using trace script he provided and trace file created by the script. ... SQL Server database by the asp application. ... Microsoft Online Community Support ... a Microsoft Support Engineer within 2 business day is acceptable. ...
    (microsoft.public.sqlserver.programming)
  • Re: Profiler Security
    ... There's no way to restrict what a user of trace can see - if they ... etc. coming into SQL Server. ... >> want to assign the developers the sys admin sql role. ...
    (microsoft.public.sqlserver.security)