Re: Very slow Responding SQL2000

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: lim (lim_at_discussions.microsoft.com)
Date: 07/04/04 

Date: Sat, 3 Jul 2004 23:03:01 -0700

Hello, Hari

I can say it's really slow......
Opening Enterprise Manager takes more than 40 second and any mouse clicking also spent more than 30 second.... and in the Query Analizer, any select or transaction take a lot of time rather than before....

but, i can't see like this probem on operating system..... all functionality is fine except SQL..

currently, there is no any block.... memory and CPU is stable condition...
i reinstalled SQL server yesterday,,,
when i intalled it again,,,, SQL application is very slow before attaching any DATABASE

Our server is on well protected network,,, and also i performed a remote virus scan
on my machine....

anyone can give me a clue !!!!

"Hari Prasad" wrote:

> Hi,
>
> Can you check the usage of Memory , CPU , DIsk I/O (Queue Length) etc...
> using the Performance monitor. In SQL Serevr execute sp_who and look into
> blk column for any blocks. Execute the select statements locally in the
> server and check the performance. If it executes fine localy then contact
> the network admin.
>
> How did you confirm that SQL Server is very slow?
>
> See the SQL Server performance counter details in below link:-
>
> http://www.sql-server-performance.com/performance_monitor_tips.asp
>
> Thanks
> Hari
> MCDBA
>
>
> "Lim" <s_kkkk@hanmail.net> wrote in message
> news:25a1b01c460cc$f39f1320$a401280a@phx.gbl...
> > Dear ...
> >
> > I have been running SQL2000 on Windows2000 server since
> > 2002.
> > Yesterday, Our SQL services are getting
> > slower ...extreamly slow...
> > Until now, i usally update a important servicepack and
> > security fix on there. also Virus protection are running
> > on system.
> >
> > Today, i had uninstalled a all SQL server on my system and
> > i installed it again.
> > But , symptom is same as before
> >
> > Windows 2000 status is quite good, only SQL is problem on
> > my system
> >
> > Anyone can help me!!!
>
>
>

Relevant Pages

  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... I moved every table I was able to move to the SQL ... closed connections - but all of these errors are in the version which used ... the SQL Server 2000 and everything worked ... communication between ODBC (OLEDB and Native Client, ...
    (microsoft.public.sqlserver.connect)
  • Re: try...catch execution issue
    ... If I execute a procedure, an error occurs, call the ... But I would suggest that when you use TRY-CATCH, you don't care about the ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.programming)
  • Re: Problem with bulk load security.
    ... go back read my previous post about using EXECUTE AS ... you need to impersonate a *server login*. ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.security)
  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... Rebuild the node in the failover cluster. ... Scenario 1" in SQL Server 2000 Books Online. ... This setup process updates to SP4 only the binaries on the new ...
    (microsoft.public.sqlserver.clustering)
  • Re: Starting up database customers every minute or so in SQL LOG
    ... Did you check the initial few lines of the sql log as I mentioned?If you are ... unable to find the location of the error log, then execute the below command ... priority class 'normal'(n CPU detected) " where n indicates the number. ... SQL Server MVP ...
    (microsoft.public.sqlserver.server)