Re: Very slow Responding SQL2000
From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 07/04/04
- Next message: Jessica: "Controlling log file size"
- Previous message: Hari Prasad: "Re: Win XP Pro + SQL Server 2000 (evaluation) - logon problem"
- In reply to: lim: "Re: Very slow Responding SQL2000"
- Next in thread: Lim: "Re: Very slow Responding SQL2000"
- Reply: Lim: "Re: Very slow Responding SQL2000"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 4 Jul 2004 19:51:02 +0530
Hi,
Can you install the SQL Server client tools remotely (in any PC) and connect
the SQL Server databases
using both Enterprise manager as well as Query ANalyzer and check the Query
response.
I had an instance before when ever I query from server it was slow but from
remote it was fast. That problem
was solved after recreating the windows os profile. You can also verify this
by login in using a diffrent user in
OS.
One more thing is uncheck (disable) the AUTOCLOSE option for all databases
if enabled. You can do this using the Enterprise manager and select
properties -- option for each database or use sp_dboption stored procedure
Thanks
Hari
MCDBA
"lim" <lim@discussions.microsoft.com> wrote in message
news:4A51265A-AD31-4C04-9B99-6B48A15F152B@microsoft.com...
> 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!!!
> >
> >
> >
- Next message: Jessica: "Controlling log file size"
- Previous message: Hari Prasad: "Re: Win XP Pro + SQL Server 2000 (evaluation) - logon problem"
- In reply to: lim: "Re: Very slow Responding SQL2000"
- Next in thread: Lim: "Re: Very slow Responding SQL2000"
- Reply: Lim: "Re: Very slow Responding SQL2000"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
