Re: SQL Server too slow

From: Pablo (pablopettis_at_yahoo.com)
Date: 12/26/03


Date: 26 Dec 2003 05:00:30 -0800

Erland Sommarskog <sommar@algonet.se> wrote in message news:<Xns945BF06B07F2BYazorman@127.0.0.1>...
> As Greg said, you have provided far too little information for any accurate
> advice. But two things to check for:
>
> o Make sure you have ODBC tracing off.
> o Make sure that no database is set to autoclose.

Tracing was ON, and that was causing the big delay!!
Thank you very Erland!



Relevant Pages

  • Re: Introducing the Sangean ATS909 - Anyone Got It?!
    ... Thank you so much for your post, particularly your advice regarding ... I have decided to go for the Grundig instead. ... I am amazed to see that Bushy Greg has fallen for your line but like ...
    (rec.radio.shortwave)
  • Re: Welding Instruction - in Tucson AZ
    ... classes that are offered on my non-working hours so I am trying to ... accident - apparently the instructor didn't know what they were doing. ... I have gotten some good advice there and I hope to get more. ... Greg ...
    (sci.engr.joining.welding)
  • Re: Root directory filling up...
    ... Nikolas Britton wrote: ... > What edition of The Complete FreeBSD do you have? ... > believe that greg would advice against using the handbook's ...
    (freebsd-newbies)
  • Re: Repairing cracked castings
    ... > Don't give up on us Greg. ... A glance at the archives will show that this ... > normally a very pleasant group and the advice I have received here has ... advice to try and help ...
    (uk.rec.engines.stationary)
  • Re: Is MSIE dead as a browser - if Microsoft does not patch it then it is as far as I am concerned!
    ... Hyperlinks are used to ensure advice remains current ... Sandi - Microsoft MVP since 1999 ... Greg R wrote: ...
    (microsoft.public.security.virus)