SQL SERVER – Frequency of SQL Server Reboot and Restart

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.

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.

Reference : Pinal Dave (https://blog.sqlauthority.com)

Database, DBA, SQL Server Security
Previous Post
SQLAuthority News – Book Review – SQL Server 2005 DBA Street Smarts: A Real World Guide to SQL Server 2005 Certification Skills
Next Post
SQLAuthority News – Scrum: Agile Software Development for Project Management

Related Posts

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.

    Reply
  • karthikeyan T(chennai)
    January 2, 2009 10:37 am

    9–months!!! amazing.. what is the configuration of ur server..? and how many GB is ur production database..

    Reply
  • 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).

    Reply

Leave a Reply

Menu
Exit mobile version