Solved

disadvantage of frequent reboots

Posted on 2013-05-23
6
946 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 125 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 69

Assisted Solution

by:Scott Pletcher
Scott Pletcher earned 125 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
Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

 
LVL 35

Accepted Solution

by:
David Todd earned 125 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 125 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

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

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

I have a large data set and a SSIS package. How can I load this file in multi threading?
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

751 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