Win2000 Server performance problem

[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

 

[Pegasus \(MVP\)]

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

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.

 

[tlee]

Thanks alot.

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

tlee

 

[Pegasus \(MVP\)]

Thanks alot.

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

tlee

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.

 

[tlee]

Thank you very much for your help : )

tlee

 

[Pegasus \(MVP\)]

Thank you very much for your help : )

tlee

You're welcome.

 

[h.stroph]

In

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.

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?

 

[Pegasus \(MVP\)]

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?

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.