Tag: windows-server-failover-clustering

PostThe Smart Way to Troubleshoot SQL Server Cluster and Always On Availability Group Outages

A few weeks ago, I was trying to figure out why my Korg X50 music workstation was not sending MIDI data to my MacBook Pro. While the Korg X50 has its own sound library and can function without the MacBook, the use of software made it easy for me to do audio recordings. But what […]

PostBeyond Technical Reasons: Running a Single Instance or a Multi-Instance SQL Server Failover Cluster

When asked about best practices on running multiple SQL Server failover clustered instances (FCI) on a multi-node Windows Server Failover Cluster (WSFC,) a common response from SQL Server experts might include the following: appropriately allocating enough hardware resources on all of the nodes in the WSFC appropriately configuring maximum server memory settings per SQL Server FCI […]

Post3 Reasons To Join My Online Course Windows Server Failover Clustering for the Smart SQL Server DBA

The Windows Server Failover Clustering for the Smart SQL Server DBA course was created in an attempt to help SQL Server DBAs and server administrators responsible for SQL Server Failover Clustered Instances (FCI) become more confident in what they do. This idea dawned on me as I was talking to customers who are unnecessarily spending money on hardware that […]

PostAvoid These Failover Clustering Mistakes That Can Cost a SQL Server DBAs Job

[callout]I would like to thank some of my customers who have provided me with really great content to share with the community.[/callout] I’ll never forget a conversation I had with a customer several years ago. I was asked to join a conference call to discuss a new SharePoint 2013 farm deployment. My involvement was limited […]

PostHow Well Do You Know Your Microsoft High Availability Technologies?

Are you up to the challenge? Do you have what it takes to design a highly available SQL Server system? Feeling helpless and confused when dealing with Windows Server Failover Clustering  (WSFC) for your SQL Server databases? You’re not alone. I’ve heard the same thing from thousands of SQL Server administrators throughout my entire career. […]

PostHow Attention To Detail Can Make Your Systems Highly Available

As my son was struggling to figure out how to download the Amazon Kindle app on his iPad, I can’t help but notice the email he got from Amazon. The email contains the URL link where to download the Kindle app. And the message said something like this: [callout]Download the free Kindle reading app on your […]

PostResources: Windows Server Failover Clustering (WSFC) for SQL Server DBAs

Last week at Live360, I have had the opportunity to deliver my workshop on Windows Server Failover Clustering (WSFC) for SQL Server DBAs. The workshop was based on an online course that I am about to re-release. One of the things I like about delivering presentations is that I learn a lot from the attendees […]

PostThe S.P.A. That Prevents Your Synchronous SQL Server Always On Availability Groups From Failing Over Automatically

This is a very common question that gets asked on the technical forums, newsgroups, social media, etc. when it comes to synchronous SQL Server Always On Availability Groups (AG): “Why did my AG not automatically failover?” Notice that I mentioned SYNCHRONOUS and not asynchronous. Only when Always On Availability Group replica databases are configured for synchronous commit […]

PostWhy We Need To Understand How Active Directory Affects SQL Server High Availability

But I’ll tell you what hermits realize. If you go off into a far, far forest and get very quiet, you’ll come to understand that you’re connected with everything. – Alan Watts – WARNING: There will be a ton of acronyms in this blog post. Make sure to keep your notebook handy for note-taking reference. […]

Copyright © 2018 Learn SQL Server High Availability & Disaster Recovery

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close