Posted by Neil on 12/06/07 21:30

See my response to Michael in this thread.

"Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
news:%23LFLkcEOIHA.4196@TK2MSFTNGP04.phx.gbl...
> 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" <nospam@nospam.net> wrote in message
> news:5CY5j.76025$YL5.36846@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
>
>

[Back to original message]