Re: SQL Client

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

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 02/25/04 

Date: Wed, 25 Feb 2004 23:33:33 +0100

Also, having autogrow turned on for the databases can make EM dead slow... 

-- 
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Sebastian K. Zaklada" <szaklada-dont-like-spam@skilledsoftware.com> wrote
in message news:e6XYzI9%23DHA.712@tk2msftngp13.phx.gbl...
> > This is my first message.
> > I'm looking for a faster SQL Server client. I dont like the enterprise
> > manager because it's slow.
>
> What do you exactly mean by "slow"? Please post more details.
>
> See "ODBC Tracing to SQL.LOG Can Slow SQL Server or Consume All Disk
Space"
> article Q268591
> http://support.microsoft.com/default.aspx?scid=kb;EN-US;268591
>
> Having ODBC Tracing turned on can result in two problems:
> The SQL.LOG file can grow very large and consume all existing disk space
on
> the drive where it resides.
> There may be a high input/output (I/O) overhead associated with ODBC
Trace,
> and that can seriously impact the performance of the ODBC application or
any
> application running on the computer where the trace is done.
>
> sincerely,
> --
> Sebastian K. Zaklada
> Skilled Software
> http://www.skilledsoftware.com
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
>

Relevant Pages

  • Re: can not delete odbc tracing file
    ... It appears that not only should one disable odbc tracing - in order to ... "Robert Sundström" wrote in message ... >> I can not delete the odbc manager tracing file. ... >> There is no other runing programm or sql server job. ...
    (microsoft.public.data.odbc)
  • Re: C++ slows down EM
    ... See "ODBC Tracing to SQL.LOG Can Slow SQL Server or Consume All Disk Space" ...
    (microsoft.public.sqlserver.tools)
  • Re: cant delete odbc tracing file..
    ... ODBC Tracing to SQL.LOG Can Slow SQL Server or Consume All Disk Space' ... <start quote> ... > I can not delete the odbc manager tracing file. ...
    (microsoft.public.sqlserver.odbc)
  • Re: cant delete odbc tracing file..
    ... ODBC Tracing to SQL.LOG Can Slow SQL Server or Consume All Disk ... Stop all ODBC applications, and stop SQL Server. ...
    (microsoft.public.sqlserver.odbc)
  • Re: SQL Client
    ... See "ODBC Tracing to SQL.LOG Can Slow SQL Server or Consume All Disk Space" ... There may be a high input/output overhead associated with ODBC Trace, ...
    (microsoft.public.sqlserver.server)