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 (http://blog.SQLAuthority.com)

About these ads

5 thoughts on “SQL SERVER – Frequency of SQL Server Reboot and Restart

  1. 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.

  2. Pingback: SQLAuthority Author Visit Report - Tech Meetings - Recession - Job Market - Consolidation of Servers - OS Choice - Server Reboots - Performance Optimization - Backup and Restore Journey to SQL Authority with Pinal Dave

  3. Pingback: SQL SERVER – Weekly Series – Memory Lane – #046 | Journey to SQL Authority with Pinal Dave

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s