SQL Server too slow

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

  • Next message: Greg D. Moore \(Strider\): "Re: SQL Server too slow"
    Date: 24 Dec 2003 06:10:19 -0800
    
    

    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.


  • Next message: Greg D. Moore \(Strider\): "Re: SQL Server too slow"

    Relevant Pages

    • Re: SQL Server too slow
      ... > When I query or browse databases or tables in SQL Server 2000 it works ... > Now I'm installing Service Pack 3, ... > is extremely slow too. ... Books Online for SQL Server SP3 at ...
      (microsoft.public.sqlserver.security)
    • Re: SQL Server too slow
      ... > When I query or browse databases or tables in SQL Server 2000 it works ... What do you consider "extremely slow" ... > Now I'm installing Service Pack 3, ... I just did a SP3a upgrade last night and some of the replication scripts ...
      (microsoft.public.sqlserver.security)
    • Re: Cursors in functions
      ... >> When I want to loop through a result in sp I use Cursor ... >Server are extremely slow. ... >statements can be slow by itself, since SQL Server has to ... >may be able to offer a set-based solution. ...
      (microsoft.public.sqlserver.programming)
    • Re: Coping with slow SQL Servers in ASP.NET
      ... We have situations occasionally where the SQL server is extremely slow to ... The problm is that the user is left with loading page and has no ... try-catch to handle the sql exception. ...
      (microsoft.public.dotnet.framework.aspnet)
    • Detecting network trouble?
      ... to connect with an in house SQL Server. ... The app runs extremely slow on ... bits/secto the specific SQL Server from my machine? ...
      (microsoft.public.windowsxp.general)