SQL Server too slow

[Pablo]

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?

Thanks in advance.

[Greg D. Moore \(Strider\)]

"Pablo" <pa*********@yahoo.com> wrote in message
news:47**************************@posting.google.c om...

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.

What do you consider "extremely slow"

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.
Again, what do you consider slow?

I just did a SP3a upgrade last night and some of the replication scripts
took several minutes to run.

On the other hand, this server normally processes 10s of millions of queries
a day in subsecond speed.

So, some things are just plain slow.

Did anyone experienced this or have any idea?
No, since you really haven't provided enough detail.


Thanks in advance.

[Erland Sommarskog]

Pablo (pa*********@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, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

[Pablo]

Erland Sommarskog <so****@algonet.se> wrote in message news:<Xn**********************@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!

[Murtix Van Basten]

How do I find out a database set to autoclose ?

Murtix.

"Erland Sommarskog" <so****@algonet.se> wrote in message
news:Xn**********************@127.0.0.1...

Pablo (pa*********@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, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

[Erland Sommarskog]

Murtix Van Basten (no****@nospam.org) writes:

How do I find out a database set to autoclose ?

For a single database you can do:

exec sp_dboption db, 'autoclose'

To check all databases use:

exec sp_helpdb

But since the autoclose information is hidden in the middle, this may
be simpler:

select name from master..sysdatabases
where databasepropertyex(name, 'IsAutoClose') = 1

You can also view it in Enterprise Manager, but it is left as an exercise
to the reader to find out how.

--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp