SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


No More Downtime


No More Downtime

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (531K reputation)SSC Guru (531K reputation)SSC Guru (531K reputation)SSC Guru (531K reputation)SSC Guru (531K reputation)SSC Guru (531K reputation)SSC Guru (531K reputation)SSC Guru (531K reputation)

Group: Administrators
Points: 531931 Visits: 20696
Comments posted to this topic are about the item No More Downtime

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Robert Sterbal-482516
Robert Sterbal-482516
SSCrazy
SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)

Group: General Forum Members
Points: 2009 Visits: 327
I hope people remember that the downtime that matters is the experience that end user experiences, and not just the theoretical downtime of a system.

I host my wiki on a project that won't even let me document the downtime.

How do you document the downtime on your systems?
jasona.work
jasona.work
SSC-Dedicated
SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)

Group: General Forum Members
Points: 38034 Visits: 15406
While the idea sounds great in theory, it looks like (at present at least, on the Windows side,) this relies on a install of Windows Server 2016 Core (which is further stripped down by removing language packs and such.)

The issue for most people I think, is there seems to be very little adoption of Server Core. I came across a thread on Reddit over the weekend (r/Sysadmin) where someone was indicating the main reason they don't use Core is there's no good substitute for Device Manager (and that includes PowerShell,) making it very difficult to update drivers or install drivers. Personally, when we were planning our migration to Windows Server 2012R2 / SQL 2014, I was very tempted to go to Core simply to reduce the monthly patching I have to do. Unfortunately, many of the required software we have to have on our servers, won't work / install on Core...

Perhaps if MS can improve the tooling for managing Core installs, we'll see more organizations start using it, and then we'll start to get "zero" downtime patching...

But I'm not betting on it being soon.
Steve Jones
Steve Jones
SSC Guru
SSC Guru (531K reputation)SSC Guru (531K reputation)SSC Guru (531K reputation)SSC Guru (531K reputation)SSC Guru (531K reputation)SSC Guru (531K reputation)SSC Guru (531K reputation)SSC Guru (531K reputation)

Group: Administrators
Points: 531931 Visits: 20696
Yeah, core is going away, or at least not the time now. People aren't comfortable enough with PoSh. There is work to remove downtime in the main Windows Server release (and hopefully W10/11/etc desktop versions).

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
EdVassie
EdVassie
SSC-Forever
SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)

Group: General Forum Members
Points: 49420 Visits: 3955
I could moan about the addiction Windows has for reboots and remember the many months of uptime commonly seen on MVS/370 where a patch seldom required an outage. (I think I did just moan...)

It really is good that Microsoft are looking at how to move Windows to be a low or no downtime OS that is still patched and up to date. Windows Server 2019 looks like a good step along this road, but I hope it is not that last one that Microsoft take.

Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005. 14 Mar 2017: now over 40,000 downloads.Disclaimer: All information provided is a personal opinion that may not match reality.Quote: When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist. - Archbishop Hélder Câmara
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search