July 1, 2009 at 6:18 am
I am just curious how often other organizations reboot their production sql servers. once a month? quarterly? Never?
July 1, 2009 at 6:29 am
We do ours every month due to server patches
July 1, 2009 at 6:41 am
Its the same with our servers. Monthly patch weekend 🙂
July 1, 2009 at 6:48 am
Generally reboot production server at weekends or after any new patch.
July 1, 2009 at 7:19 am
We tend to only for service packs, which means we reboot about once or twice a year for this site. Rarely unless there are isses, and it seems in IT, there are a few issues a year.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
July 1, 2009 at 7:34 am
Minimum once a year during our annual power down, but in general we try to keep them up as long as possible. In practice, it's probably 2-3 times a year for service packs or specific patches.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
July 1, 2009 at 7:40 am
The majority of our environments are clustered enabling us to easily rollout monthly patching runs without interruption to service.
Grant, an “Annual Power Down” sounds like some sort of dance party 🙂 although I’m sure it’s not quite that exciting.
July 1, 2009 at 7:55 am
John Sansom (7/1/2009)
The majority of our environments are clustered enabling us to easily rollout monthly patching runs without interruption to service.Grant, an “Annual Power Down” sounds like some sort of dance party 🙂 although I’m sure it’s not quite that exciting.
Yep. Nothing quite as exciting as running DBCC on something like 100 instances all at the same time. I really wish PowerShell was threaded.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
July 1, 2009 at 8:21 am
Thanks all for your replies .. you have provided me with the needed ammo .. 😎
July 1, 2009 at 10:05 am
So sounds like not everyone is applying the server patches - in our place the server and security team insist on them?
July 1, 2009 at 10:13 am
Monthly for patches - per SLA. This is insisted at the monthly frequency by the IT Team.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 1, 2009 at 10:26 am
We reboot servers when it is needed for patches, hardware or software installation, or other specific need.
When people suggest that we do it on some regular basis “because SQL Server needs it”, I tell them no.
July 1, 2009 at 10:34 am
I get the reason "because the server OS needs it and it is Microsoft after all" approach.
My response is typically along the lines "uh-huh sure".
At least I don't get the "Because SQL Server needs it" approach, they know better by now.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 1, 2009 at 10:42 am
Every 24hours. Due to high volume of data and proprietary software. The clustered nodes must be restarted to clear any errors. Our programmers didn't do a good job of keeping the servers from BSoDs when we stop the programs. We have learned that restarting the nodes every 24hours will stop it. Sucks.
July 1, 2009 at 10:53 am
Every 24hrs? Developer related?
Ouch - but can sympathize.
Good Luck with that :crying:
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 15 posts - 1 through 15 (of 15 total)
You must be logged in to reply to this topic. Login to reply