Win2000 Server performance problem

  • Thread starter Thread starter tlee
  • Start date Start date
T

tlee

I have a PC installed MS win2000 server(SP4) with SQL 2000 server.

Problem:
1) I find its respond (data access from client PC) becomes slow after
serveral weeks running.

2) could i need to run the defragment in win2000 server? (AD implemented)

Thanks
tlee
 
tlee said:
I have a PC installed MS win2000 server(SP4) with SQL 2000 server.

Problem:
1) I find its respond (data access from client PC) becomes slow after
serveral weeks running.

2) could i need to run the defragment in win2000 server? (AD implemented)

Thanks
tlee
Click to expand...

Defragging the disk might help but it would not cause the gradual
deterioration. This could be caused by a memory leak. Since it
takes several weeks for the speed to drop noticeably, you might
take a pragmatic approach and reboot the server automatically
every Saturday night.
 
Thanks alot.

Could you inform me how to do the setting of auto reboot each couple days?

tlee
 
tlee said:
Thanks alot.

Could you inform me how to do the setting of auto reboot each couple days?

tlee
Click to expand...

Start a Command Prompt and type

shutdown

to see the syntax for this command, then use the Task Scheduler
via the Control Panel to schedule the shutdown command.
 
In
Pegasus (MVP) said:
Start a Command Prompt and type

shutdown

to see the syntax for this command, then use the Task Scheduler
via the Control Panel to schedule the shutdown command.
Click to expand...

If one is already at the prompt, why not just use the "at" command instead
of going through all the hullabaloo of starting yet another graphical
interface to the same thing?
 
h.stroph said:
In

If one is already at the prompt, why not just use the "at" command instead
of going through all the hullabaloo of starting yet another graphical
interface to the same thing?
Click to expand...

Indeed - if you're comfortable with the command line syntax of
at.exe and are aware of some of its restrictions (which, incidentally,
are a frequent subject in these help groups). And if you're very
fond of console commands then you should have a look at the
successor of at.exe - schtasks.exe from WinXP.
 
Back
Top