Re: SQL Server too slow
From: Greg D. Moore \(Strider\) (mooregr_at_greenms.com)
Date: 12/24/03
- Next message: Roy Goldhammer: "Execute premmition"
- Previous message: Pablo: "SQL Server too slow"
- In reply to: Pablo: "SQL Server too slow"
- Next in thread: Erland Sommarskog: "Re: SQL Server too slow"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 24 Dec 2003 14:26:42 GMT
"Pablo" <pablopettis@yahoo.com> wrote in message
news:47ae7cc6.0312240610.7cddde5c@posting.google.com...
> 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.
- Next message: Roy Goldhammer: "Execute premmition"
- Previous message: Pablo: "SQL Server too slow"
- In reply to: Pablo: "SQL Server too slow"
- Next in thread: Erland Sommarskog: "Re: SQL Server too slow"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
