每周一次或每月一次 [英] Once a week or once a month

问题描述

在客户端上使用Access 2000在Windows 2000服务器上运行SQL 7系统

计算机作为前端。系统管理员目前每月重启一次服务器

。昨天我们在数据库中遇到了一些奇怪的事情：

用户在尝试访问时遇到ODBC错误。重新启动了

服务器，一切都很好。建议他每周一次重启服务器

。他说他已经每月做一次了，这就足够了。


我的POV是这样的：a）每周做一次可能会阻止诸如昨天
; b）即使没有像昨天那样的情况，

的表现可能会在一个月内降低，而我们不会知道它，并且每周重启一次可能帮助表现。


对此有何想法？


谢谢！


Neil

解决方案

仅仅因为重新启动修复了问题并不意味着预防性的重新启动会阻止它发生。


首先可能不需要重启来解决问题。

可能是配置更改

或弹出服务可以解决它。我的建议是花一些时间来研究这个问题，如果你不能找到解决问题的办法，那就找一种方法来检测它并拥有它

执行最不具侵入性的纠正措施。


-Mike


" Neil" < no **** @ nospam.netwrote in message

news：5C ******************* @ newssvr29.news.prodigy。 net ...

在Windows 2000服务器上使用Access 2000在

客户端计算机上作为前端运行SQL 7系统。系统管理员目前每月重启一次

服务器。昨天我们对数据库有一些奇怪的事情

用户在尝试访问时遇到ODBC错误。重新启动

服务器，一切都很好。建议他每周重启一次

服务器。他说他已经每月做一次了，那就足够了。


我的POV是这样的：a）每周做一次可能防止昨天的情况如

; b）即使没有像昨天那样的情况，

的表现可能会在一个月内降低，而我们的b
没有意识到它，并且每周重启一次可能帮助表现。


对此有何想法？


谢谢！


Neil

他为什么要重启？


-

Tom


-------------------------------------- --------------

Thomas A. Moreau，理学士，博士，MCSE，MCDBA，MCITP，MCTS

SQL Server MVP

加拿大多伦多
https ：//mvp.support.microsoft.com/profile/Tom.Moreau

" Neil" < no **** @ nospam.netwrote in message

news：5C ******************* @ newssvr29.news.prodigy。 net ...

在客户端上使用Access 2000在Windows 2000服务器上运行SQL 7系统

计算机作为前端。系统管理员目前每月重启一次服务器

。昨天我们在数据库中遇到了一些奇怪的事情：

用户在尝试访问时遇到ODBC错误。重新启动了

服务器，一切都很好。建议他每周一次重启服务器

。他说他已经每月做一次了，这就足够了。


我的POV是这样的：a）每周做一次可能会阻止诸如昨天
; b）即使没有像昨天那样的情况，

的表现可能会在一个月内降低，而我们不会知道它，并且每周重启一次可能帮助表现。


对此有何想法？


谢谢！


Neil

好的，没关系。但我的POV是一般的重启，并重置

系统内存，这是一件好事。我认为你不同意？


" Michael Abair" < ma **** @ autotask.com写信息

新闻：eT ************** @ TK2MSFTNGP06.phx.gbl ...

只是因为重新启动修复了问题并不意味着预防性的重新启动会阻止它发生。

可能不需要重新启动来解决第一个

位置的问题。可能是配置更改

或弹出服务可能已经解决了。我的建议是花一些时间来研究这个问题，如果你不能找到解决问题的办法，那就找一种方法来检测它并拥有它

执行最不具侵入性的纠正措施。


-Mike


" Neil" < no **** @ nospam.netwrote in message

news：5C ******************* @ newssvr29.news.prodigy。 net ...

>在客户端计算机上使用Access 2000作为前端在Windows 2000服务器上运行SQL 7系统。系统管理员目前每月重启一次服务器。昨天我们在
数据库中遇到了一些奇怪的事情，用户在尝试访问时遇到了ODBC错误。
重新启动服务器，一切都很好。建议他每周一次重启服务器。他说他已经每月做一次，这已经足够了。

我的POV是这样的：a）每周做一次可能会阻止诸如
等情况那个昨天; b）即使没有像昨天这样的情况，
性能可能会在一个月内降低，而我们没有意识到它，并且每周重启一次可能有助于提高性能。

有什么想法吗？

谢谢！

Neil

Running a SQL 7 system on a Windows 2000 server using Access 2000 on client
machines as a front end. System administrator currently reboots the server
once a month. Yesterday we had some weird thing with the database where
users were getting ODBC errors when trying to access it. Rebooted the
server, everything was fine. Suggested to the sa that he reboot the server
once a week. He said he already does it once a month, and that''s sufficient.

My POV is that: a) doing it once a week might prevent situations such as the
one yesterday; b) even without situations like the one yesterday,
performance may be degrading over the course of the month, without our being
aware of it, and rebooting once a week might help performance.

Any thoughts on this?

Thanks!

Neil

解决方案

Just because the reboot fixed the issue doesn''t mean that a preventative
reboot will stop it from occuring.

A reboot might not have been needed to resolve the issue in the first place.
Possibly a configuration change
or bouncing a service could have resolved it. My advice is to spend some
time researching the issue and if
you cant find a way to resolve it then find a way to detect it and have it
perform the least intrusive form of corrective action.

-Mike

"Neil" <no****@nospam.netwrote in message
news:5C*******************@newssvr29.news.prodigy. net...

Running a SQL 7 system on a Windows 2000 server using Access 2000 on
client machines as a front end. System administrator currently reboots the
server once a month. Yesterday we had some weird thing with the database
where users were getting ODBC errors when trying to access it. Rebooted
the server, everything was fine. Suggested to the sa that he reboot the
server once a week. He said he already does it once a month, and that''s
sufficient.

My POV is that: a) doing it once a week might prevent situations such as
the one yesterday; b) even without situations like the one yesterday,
performance may be degrading over the course of the month, without our
being aware of it, and rebooting once a week might help performance.

Any thoughts on this?

Thanks!

Neil

Why does he reboot at all?

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Neil" <no****@nospam.netwrote in message
news:5C*******************@newssvr29.news.prodigy. net...
Running a SQL 7 system on a Windows 2000 server using Access 2000 on client
machines as a front end. System administrator currently reboots the server
once a month. Yesterday we had some weird thing with the database where
users were getting ODBC errors when trying to access it. Rebooted the
server, everything was fine. Suggested to the sa that he reboot the server
once a week. He said he already does it once a month, and that''s sufficient.

My POV is that: a) doing it once a week might prevent situations such as the
one yesterday; b) even without situations like the one yesterday,
performance may be degrading over the course of the month, without our being
aware of it, and rebooting once a week might help performance.

Any thoughts on this?

Thanks!

Neil

OK, that''s fine. But my POV is that rebooting in general, and resetting the
system memory, is a good thing to do. I take it that you disagree?

"Michael Abair" <ma****@autotask.comwrote in message
news:eT**************@TK2MSFTNGP06.phx.gbl...

Just because the reboot fixed the issue doesn''t mean that a preventative
reboot will stop it from occuring.

A reboot might not have been needed to resolve the issue in the first
place. Possibly a configuration change
or bouncing a service could have resolved it. My advice is to spend some
time researching the issue and if
you cant find a way to resolve it then find a way to detect it and have it
perform the least intrusive form of corrective action.

-Mike

"Neil" <no****@nospam.netwrote in message
news:5C*******************@newssvr29.news.prodigy. net...

>Running a SQL 7 system on a Windows 2000 server using Access 2000 on
client machines as a front end. System administrator currently reboots
the server once a month. Yesterday we had some weird thing with the
database where users were getting ODBC errors when trying to access it.
Rebooted the server, everything was fine. Suggested to the sa that he
reboot the server once a week. He said he already does it once a month,
and that''s sufficient.

My POV is that: a) doing it once a week might prevent situations such as
the one yesterday; b) even without situations like the one yesterday,
performance may be degrading over the course of the month, without our
being aware of it, and rebooting once a week might help performance.

Any thoughts on this?

Thanks!

Neil

这篇关于每周一次或每月一次的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！