Search Results for “failover cluster”

Training Week: Announcing Edwin’s New Class on Failover Clustered Instances

Last Updated April 11, 2018

This week, we’ve got a bunch of announcements about new training classes. Next up, Edwin Sarmiento: his 3-day Always On Availability Group class has been getting great reviews: “This class is fantastic. There is no filler, and no needless repetition, so be prepared to pay attention the entire duration. Edwin clearly is very passionate about…

1.4 Design Quorum for Failover Clusters (23m)

Last Updated March 14, 2021

Brent Ozar Unlimited Team

Before you touch anything with Always On in the name, you need to understand how cluster quorum works and how it can bring your SQL Server down. Learn how dynamic quorum and dynamic witness should be configured and see 3 real-world scenarios. Note: this class is from 2017, and I no longer update it. I’ve…

20. Failover Clustered Instances: Links to Free Online Labs, Install Instructions, Articles

Last Updated November 26, 2020

Brent Ozar Unlimited Team

Learn where you can test installing SQL Server on a cluster, get links to Microsoft’s installation guides, and learn lots more about virtualization and failover clustering. Get the PDF download here.

You’ll need a membership to access this course. Check out my training classes.

19. Failover Clustered Instances: Demo – Failing Over (18m)

Last Updated February 10, 2017

Brent Ozar Unlimited Team

See the settings for a failover cluster instance of SQL Server in the Cluster Manager and learn how the Windows Failover Cluster manages service status on cluster nodes. Watch a planned manual failover and a failover due to a node rebooting.

You’ll need a membership to access this course. Check out my training classes.

18. Failover Clustered Instances: Features, Requirements, and Licensing (20m)

Last Updated February 4, 2017

Brent Ozar Unlimited Team

Learn why clustering is a helpful tool, the required licensing for Windows and SQL Server, options and gotchas for “active/active” clusters, and more.

You’ll need a membership to access this course. Check out my training classes.

Introduction to SQL Server Failover Clusters (video)

Last Updated February 9, 2017

Kendra Little

Clustering, SQL Server

You’d love to know how to make your SQL Servers more highly available, but you’re just not sure what “clustering” is all about. We can help! In this 30 minute video Kendra Little shows you how failover clusters make your SQL Servers easier to manage. She uses diagrams and drawings to teach you the strengths…

SQL Server Failover Clusters

Last Updated July 25, 2017

Brent Ozar

Microsoft SQL Server Failover Clusters The options for high availability can get confusing, and we bet you’re having a hard time finding simple information on what a cluster does and the most common gotchas when planning a cluster. In these articles, we’ll explain what clusters are, what they’re good for, and why we like to…

Slow Startup, Failover, and Restore Times with In-Memory OLTP

Last Updated March 8, 2023

Brent Ozar

In-Memory OLTP (Hekaton)

When In-Memory OLTP came out, I worked with it briefly, and I remember coming away thinking, “Who in their right mind would actually use this?” I was so horrified that I wrote a presentation about it and gave it at a couple of conferences: Many laughs were had, but obviously that didn’t make me any…

New Windows Clustering Course for SQL Server DBAs by Edwin Sarmiento

Last Updated February 9, 2017

Brent Ozar

Clustering, SQL Server

The SQL Server community has been waiting a long time for an in-depth Windows clustering course on current versions of Windows. See, AlwaysOn Availability Groups as well as good ol’ Failover Clustered Instances both rely on Windows clustering in order to manage uptime. If you’re going to do an AG or an FCI, you gotta…

Common SQL Server Clustering, AlwaysOn, and High Availability Answers

Last Updated March 22, 2019

Brent Ozar

Always On Availability Groups, Clustering, SQL Server

Our live webcast topic this week was Q&A – you could bring any HA/DR questions, and we could avoid your answers. Just kidding. Here’s the webcast – we apologize for the audio, WebEx is still getting their act together. It cleans up after the first couple of minutes. And here’s the questions we couldn’t get…

Why Your SQL Server Cluster Shouldn’t Be Virtualized

Last Updated February 9, 2017

Brent Ozar

Clustering, Virtualization

When people buy my virtualization training video, one of the followup questions I get most often via email is, “Can I build SQL Server clusters in VMware and Hyper-V?” In theory, yes. Microsoft’s knowledge base article on SQL Server virtualization support says they’ll support you as long as you’re using configurations listed in the Server…

Everything You Know About Clustering is Wrong

Last Updated February 9, 2017

Brent Ozar

Clustering

Remember that weirdo in high school who had no social skills? Couldn’t get a date, worked at the fast food joint as a fry cook, face covered with zits – you know the one. Okay, actually, it was us. Anyway, the point is, we got our act together, didn’t we? So did Windows Failover Clustering. …

An Introduction to SQL Server Clusters

Last Updated February 9, 2017

Kendra Little

Clustering

339

The options for high availability can get confusing. I was lucky enough to begin working with SQL Server clusters early in my career, but many people have a hard time finding simple information on what a cluster does and the most common gotchas when planning a cluster. Today, I’ll tell you what clusters are, what they’re…

Cluster Node

Last Updated July 27, 2020

Brent Ozar

Clustering helps you achieve higher availability by wiring up more than one server to the same set of shared drives. If one server has a catastrophic problem like failures in Windows, the motherboard, the memory, the network cards, etc, then SQL Server will automatically restart on another server connected to the same storage. Clustering is…

[Video] Office Hours: Sunshine Edition

Last Updated December 12, 2023

Brent Ozar

Videos

You know how this works: you posta the questions at https://pollgab.com/room/brento, and I giva the answers: Here’s what you asked in this episode: 00:00 Start 03:18 DBA in VA: I recently discovered the “force order” query hint. I’m usually inclined to let the optimizer do its thing, but I have seen some of our code…

SQL ConstantCare® Population Report: Spring 2023

Last Updated July 7, 2023

Brent Ozar

SQL Server Population Report

Ever wonder how fast people are adopting new versions of SQL Server, or what’s “normal” out there for SQL Server adoption rates? Let’s find out in the spring 2023 version of our SQL ConstantCare® population report. Out of 3,002 monitored servers, here’s the version adoption rate: The big 3 versions are all within 1% of…

Office Hours: Questions That Didn’t Make the Cut

Last Updated March 23, 2023

Brent Ozar

Production Database Administration

Sometimes, y’all post questions at https://pollgab.com/room/brento and they don’t get a lot of upvotes, and reading through ’em, I bet it’s because other people don’t quite understand what you’re asking. I think there might actually be a good question at the heart of it, but … I’m just not sure what it is, and it needs…

[Video] Office Hours: Quickie Before Dinner

Last Updated January 29, 2023

Brent Ozar

Videos

Before heading out to dinner, I went through your highly-upvoted questions from https://pollgab.com/room/brento. Here’s what we covered in this episode: 00:00 Start 00:20 Mert: Hi Brent, what is the relation between AlwaysOn and Windows Failover Cluster? Is WFC an obligation or a choice for creating an Always On availability group? It will be nice if…

Office Hours: One-Word Answers Edition

Last Updated October 13, 2022

Brent Ozar

Production Database Administration

Some of the questions y’all post at https://pollgab.com/room/brento are pretty straightforward. Let’s get ‘er done. LetTheDbaHandleIt: My friend needs to track who has accessed what data. This is easy at OS and app level, but how can my friend verify that those who have direct DB access are not snooping on data inappropriately? e.g. payroll or…

Office Hours Speed Round, Text Edition

Last Updated August 10, 2022

Brent Ozar

Production Database Administration

Got questions for me? Post ’em at https://pollgab.com/room/brento and upvote the ones you’d like to see me cover. I filter out the ones that are too short for video answers, and here’s the latest batch: Corrupted: Should DBCC CheckDB be run on secondary replicas in AG as well ? Is it recommended to attach corrupted…

Search Results for “failover cluster”

Hi! I’m Brent Ozar.