?
Solved

how often to reboot

Posted on 2013-05-20
5
Medium Priority
?
320 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 10

Assisted Solution

by:bigbigpig
bigbigpig earned 400 total points
ID: 39181065
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 400 total points
ID: 39181067
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 400 total points
ID: 39181079
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:Ramesh Babu Vavilla
Ramesh Babu Vavilla earned 400 total points
ID: 39183726
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 400 total points
ID: 39186438
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

Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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 …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

777 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