Why To Reboot the Server?
-
All,
We have a two-node cluster server (O.S. - Win2K Advanced Server) dedictated for SQL Server 2K. This server has total 4 GB RAM on it with 3/4 of it configured for SQL Server use. The memory usage of sqlserver.exe service is usually low (600 plus MB at the end of each week), with a weekly reboot schedule.
The server CPU time is about 45% during business hours and the memory usage is low. I wonder if the weekly reboot has any positive effect on the server performance or we should change to monthly/bi-monthly reboot. Can someone offer your comments and advice on what the best practice is?
Any input is greatly appreciated!
Yichang
-
I am happy that you are able to schedule weekly reboot. I think you should feel happy and lucky to have that type of privilege of rebooting your server. For years I have not been able to ask management approval to even do monthly reboots on any of my sql servers. We can only reboot if we have to put patches on the servers.
mom
-
It sounds like you have servers that will give you a lot of room to grow... I doubt that the reboots either help or hurt performance. There will be a small overhead each time you reboot. This overhead occurs as the stored procedures are re-compiled when they are first called. Memory allocation is pretty efficient and should not really be a factor.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
I guess your reboot-policy comes from an NT-4 era
We only reboot if fixes are planned and installed or if our production-plant has a planned downtime.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply