This is very interesting question. I will keep the answer of this question very simple. First of all there is no scientific research or white paper I can backup my results with. Answer contains part simple observation and part experience. The question: how often should a SQL Server reboot happen?
There is no need to reboot SQL Server. Once it is on it is ON!
However, I have heard that frequent reboot improves performance.
In my company our network administration department has policy to reboot all the servers every 15 days. We reboot all the servers at every 15 days. Regarding performance improvement, our servers are always up and running as great as they can.
Published by Pinal Dave on SQLAuthority. More of my work at pinaldave.com.
3 Comments. Leave new
Interesting. I took a new position about 20-months ago. One of the first utilities they had me write was a VB program that used WMI to poll ALL computers on our network and obtain stats (OS version, memory config, disk space, etc.) and write to a database. One of the stats I pulled was date of last reboot. I noticed our primary SQL Server had not been rebooted in over 9-months. We are a small state hospital with about 400 employees using medical record tracking, medication tracking, HR tracking applications, as well as employee certification, training and license tracking. Quite impressive.
9–months!!! amazing.. what is the configuration of ur server..? and how many GB is ur production database..
We have few SQL Servers that have not been rebooted for over a year, one of the is running a production 130gb database (that one is SQL2000 on Win2003).