Solved

how often to reboot

Posted on 2013-05-20
5
311 Views
Last Modified: 2013-05-23
for a commercial sql server what is the recommended interval for reboots?
1 week/ twice a month/once a month etc.. what are the benefits to do it often (every weekend) versus more spreadout?

does this depend on how much cores/memory the machine has? or a general principles that is applicable for any sql server?

thanks
0
Comment
Question by:25112
5 Comments
 
LVL 10

Assisted Solution

by:bigbigpig
bigbigpig earned 100 total points
Comment Utility
I only reboot my Windows servers when patches or other updates require it.  I do not have them scheduled on a set interval.  I cannot see any benefits of rebooting a SQL server on a set schedule if it's not necessary.
0
 
LVL 25

Assisted Solution

by:Lee Savidge
Lee Savidge earned 100 total points
Comment Utility
Why would you do a scheduled reboot at all? On a production server you wouldn't reboot unless you had to.
0
 
LVL 13

Assisted Solution

by:Alexios
Alexios earned 100 total points
Comment Utility
Unless it is really required you don't need to do it regularly. Few situations which requires Sql Service restart,

- If the tempdb grows abnormally and fills the disk space (you cannot even shrink), restarting Sql Server will help as tempdb will be recreated.
- Applying Hotfix/Patches/Service packs will require reboot
- Port change etc will require service restart
0
 
LVL 10

Assisted Solution

by:sqlservr
sqlservr earned 100 total points
Comment Utility
it not necessary to restart SQL Server unless and untill windows patching or SQL Server patching is done.
0
 
LVL 12

Accepted Solution

by:
sachitjain earned 100 total points
Comment Utility
With my experience I would suggest that you should reboot atleast once in a month. But other major maintenance activities that you need take care of include:
1.> Keep on applying all latest patches and service packs to your server's operating system.
2.> Have a legitimate backup plan in place for backing up databases and transaction logs
3.> Have maintenance plans or jobs in place for updating statistics and reorganizing/rebuilding indexes for all tables in all databases.
4.> Keep regular check on server level and sql instance level error logs. System's performance could be influenced by frequently occuring errors also.
5.> Perform regular database consistency checks over your database

These measures would help you keeping your databases in good shape.
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now