You talking about me? đ Thanks
Carl Webster Citrix Technology Professional | iGel Tech Community Insider | Parallels VIPP http://www.CarlWebster.com<http://t.sidekickopen01.com/e1t/c/5/f18dQhb0S7lC8dDMPbW2n0x6l2B9nMJN7t5XYgdV8QRW2zWLDn4XrdjzW7fK3rs56dwxZf67wwsR02?t=http%3A%2F%2Fwww.carlwebster.com%2F&si=6012126861197312&pi=4311b7b1-332d-4242-8585-36954b184dc7> The Accidental Citrix Admin From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Kurt Buff Sent: Thursday, August 17, 2017 3:00 PM To: ntsysadm <ntsysadm@lists.myitforum.com> Subject: Re: [NTSysADM] A new task for me - setting up a SQL Server cluster on vSphere 6.0 Who was just on a list asking for help with VMware configuration? Hmmmm? đ¤ Kurt On Thu, Aug 17, 2017 at 10:59 AM, Webster <webs...@carlwebster.com<mailto:webs...@carlwebster.com>> wrote: Everyone has their faults. đ Webster -----Original Message----- From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> [mailto:listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com>] On Behalf Of Michael B. Smith Sent: Thursday, August 17, 2017 12:52 PM To: ntsysadm@lists.myitforum.com<mailto:ntsysadm@lists.myitforum.com> Subject: RE: [NTSysADM] A new task for me - setting up a SQL Server cluster on vSphere 6.0 Yes, it will work. I cannot say anything whatsoever about VMware. I'm a Hyper-V guy. -----Original Message----- From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> [mailto:listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com>] On Behalf Of Kurt Buff Sent: Thursday, August 17, 2017 1:18 PM To: ntsysadm Subject: Re: [NTSysADM] A new task for me - setting up a SQL Server cluster on vSphere 6.0 Right. Server Datacenter. Knew that. Habit to type Enterprise. The rest is stuff I'm trying to figure out, since I haven't played around much with real SQL Server since the 2000 edition, and not even much with Express since then. We are planning a 2-node cluster, so it sounds like Windows Server 2016 Standard and SQL Server 2016 (2017?) Standard will do exactly what we want. We do have restrictions in our EA regarding the number of licenses for SQL Server (2), and we also want to reduce the clutter of old versions of SQL Standard and SQL Express scattered amongst our servers. I intend to deploy on our VMware cluster (vSphere 6.0 Standard, 6 nodes, backed by a Nimble SAN), unless testing indicates it's a bad fit. Kurt On Thu, Aug 17, 2017 at 8:53 AM, Michael B. Smith <mich...@smithcons.com<mailto:mich...@smithcons.com>> wrote: > I think yâall are confusing yourselves. Words mean things. > > > > For the purposes of this discussion, there is no such thing as > âWindows Server Enterpriseâ. > > > > The editions are Windows Server Standard and Windows Server Datacenter. > Since Windows Server 2012, both Standard and Datacenter include > Windows Failover Clustering (WFC). (So does Nano Server in Windows > Server 2016, but I digress.) > > > > There ARE features that a SQL installation may want to use, such as > SOFS (Scale-Out File Servers), that may require Windows Server > Datacenter; but WFC itself does not require Datacenter. > > > > SQL Server also comes in two editions, for the purposes of this discussion. > They are Standard and Enterprise. > > > > SQL Server Standard supports WFC for EXACTLY two nodes (this is also > called SQL Server Always On Failover Clustering). No more nodes than > two. SQL Server Standard does NOT support Always On Availability Groups. > > > > SQL Server Enterprise supports WFC for the operating system maximum > number of nodes. SQL Server Enterprise supports Always On Availability Groups. > > > > Define the deployment plan FIRST, then you can determine the necessary > software. Alternately, the licenses you have may restrict your > deployment plan. > > > > Regards, > > Michael B. > > > > From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> > [mailto:listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com>] > On Behalf Of D R > Sent: Thursday, August 17, 2017 11:00 AM > > > To: ntsysadm@lists.myitforum.com<mailto:ntsysadm@lists.myitforum.com> > Subject: Re: [NTSysADM] A new task for me - setting up a SQL Server > cluster on vSphere 6.0 > > > > According to the Techs and Sales people in my org, it seems that they did. > > > > They are telling me that every SQL Clustering needs Enterprise on > 2016, or it's a 'no go'. > > > > Daniel > > > > On Thu, Aug 17, 2017 at 9:22 AM, Micheal Espinola Jr > <michealespin...@gmail.com<mailto:michealespin...@gmail.com>> wrote: > > As best as I can recall, it was listed as a requirement in the last > SQL clustering requirements doc I read on Microsoft's website. I > thought it was up-to-date, but perhaps I am mistaken? > > > > > > On Aug 17, 2017 6:55 AM, "Melvin Backus" > <melvin.bac...@byers.com<mailto:melvin.bac...@byers.com>> wrote: > > Windows clustering doesnât require Enterprise any more. It moved to > std with 2012. We run both LB and FO clusters on 2012 std. Please > donât tell me they went back with 2016. L > > > > -- > There are 10 kinds of people in the world... > those who understand binary and those who don't. > > > > From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> > [mailto:listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com>] > On Behalf Of Micheal Espinola Jr > Sent: Wednesday, August 16, 2017 9:24 PM > To: ntsysadm@lists.myitforum.com<mailto:ntsysadm@lists.myitforum.com> > Subject: Re: [NTSysADM] A new task for me - setting up a SQL Server > cluster on vSphere 6.0 > > > > The minimum requirement would be Windows. > > > -- > Espi > > > > > > On Wed, Aug 16, 2017 at 6:07 PM, Kurt Buff > <kurt.b...@gmail.com<mailto:kurt.b...@gmail.com>> wrote: > > Windows or SQL or both? > > > On Wed, Aug 16, 2017 at 5:27 PM, D R > <drod...@gmail.com<mailto:drod...@gmail.com>> wrote: >> Well, for 1, I think you're going to need Enterprise Edition for your >> server clustering. >> >> >> On Wed, Aug 16, 2017 at 6:04 PM, Kurt Buff >> <kurt.b...@gmail.com<mailto:kurt.b...@gmail.com>> wrote: >>> >>> Does anyone have a good reference on setting up a 2-node cluster >>> like this? >>> >>> I'll be putting up SQL Server 2016 on Server 2016 Standard. >>> >>> I've found a starting place: >>> >>> >>> https://kb.vmware.com/selfservice/microsites/search.do?language=en_U >>> S&cmd=displayKC&externalId=2147661 >>> >>> This is going to be a replacement for all of the little SQLServer >>> Standard/Express/WID implementations we have scattered about. >>> >>> But - does anyone have preferred documentation for implementation? >>> Any preferred configurations, and perhaps reasons why? Any nasty >>> little gotchas to avoid? >>> >>> Thanks, >>> >>> Kurt >>> >>> >> >> >> >> -- >> Daniel Rodriguez >> drod...@gmail.com<mailto:drod...@gmail.com> > > > > > > > > > > -- > > Daniel Rodriguez > drod...@gmail.com<mailto:drod...@gmail.com>
