Re: SQL Server too slow

From: Murtix Van Basten (nospam_at_nospam.org)
Date: 12/27/03

  • Next message: Kalen Delaney: "Re: SQL Server too slow" 
    Date: Fri, 26 Dec 2003 20:03:14 -0500

    How do I find out a database set to autoclose ?

    Murtix.

    "Erland Sommarskog" <sommar@algonet.se> wrote in message
    news:Xns945BF06B07F2BYazorman@127.0.0.1...
    > Pablo (pablopettis@yahoo.com) writes:
    > > When I query or browse databases or tables in SQL Server 2000 it works
    > > extremely slow. It started working like this from one day to another.
    > >
    > > I tried reinstalling but it stayed the same.
    > >
    > > Now I'm installing Service Pack 3, it's curious that executing
    > > replsys.sql, replcom.sql and repltran.sql scripts in the installation
    > > is extremely slow too.
    > >
    > > Did anyone experienced this or have any idea?
    >
    > 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.
    >
    >
    > --
    > Erland Sommarskog, SQL Server MVP, sommar@algonet.se
    >
    > Books Online for SQL Server SP3 at
    > http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

  • Next message: Kalen Delaney: "Re: SQL Server too slow"