Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

disadvantage of frequent reboots

Posted on 2013-05-23
6
Medium Priority
?
1,082 Views
Last Modified: 2013-05-29
would there be any specific disadvantage to reboot sql server often?
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
6 Comments
 
LVL 5

Author Comment

by:25112
ID: 39191915
the management has the policy that a reboot every saturday night helps. .this may be true for personal pcs..

but is there any specific disadvantage from sql server's perspective? to do a scheduled reboot every 7th day?
0
 
LVL 16

Assisted Solution

by:Surendra Nath
Surendra Nath earned 500 total points
ID: 39191932
unless, your sql server is storing data, which will be used by an online client at the scheduled re-boot time, there should be no issue.

i.e. imagine google is storing data in your sql server and you re-booted your machine and the while google website goes down for that period of time, until your machine is back.

Apart from the above scenario, there are cases where if there are any uncommited transactions and database restores happening, or any other data base activity will get affected and even  some of the database may get corrupted because of this....

But if you can ensure that no users are getting to the server at that period then there will be no issue at all.
0
 
LVL 70

Assisted Solution

by:Scott Pletcher
Scott Pletcher earned 500 total points
ID: 39192022
The main thing would be that the SQL system will be much slower at restart initially because all caches and buffers have been flushed (obviously, since the re-boot loses everything that was in RAM before).  All code must be recompiled and all data read from disk rather than from a buffer.

Presumably it wouldn't affect a scheduled job, since you presumably avoided doing a planned reboot at the same time a (critical) job was supposed to be started.

Any other applications/code extensions would also have to reloaded from scratch, which might slow them down as well.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 35

Accepted Solution

by:
David Todd earned 500 total points
ID: 39192303
Hi,

While its not a bad thing, its not a good thing either.

If a personal PC doesn't restart, there is little to no impact.

If a server doesn't restart, who is there to catch it? Do you have lights out management on your servers - each manufacturer calls them something different - and can power the server up remotely, or does it require a human to put big fat finger on red button to power the server back up?

So, if you are doing this every week, sooner or later the server will fail to restart, and then you'll have an extended outage that could be very bad for business.

My few thoughts ...

Regards
  David
0
 
LVL 25

Assisted Solution

by:jogos
jogos earned 500 total points
ID: 39193343
adding to all of the above

Less weekend-time left for non disturbing maintenance like backup or optimizing your sql  by keeping your indexes  in shape.
0
 
LVL 5

Author Comment

by:25112
ID: 39205377
good points- will be useful- thx
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

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.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

670 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