Re: SQL Server too slow
From: Erland Sommarskog (sommar_at_algonet.se)
Date: 12/24/03
- Previous message: Richard Waymire [MSFT]: "Re: Converting to SQL authentication"
- In reply to: Pablo: "SQL Server too slow"
- Next in thread: Pablo: "Re: SQL Server too slow"
- Reply: Pablo: "Re: SQL Server too slow"
- Reply: Murtix Van Basten: "Re: SQL Server too slow"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 24 Dec 2003 22:39:37 +0000 (UTC)
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
- Previous message: Richard Waymire [MSFT]: "Re: Converting to SQL authentication"
- In reply to: Pablo: "SQL Server too slow"
- Next in thread: Pablo: "Re: SQL Server too slow"
- Reply: Pablo: "Re: SQL Server too slow"
- Reply: Murtix Van Basten: "Re: SQL Server too slow"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
