Question : We’ve finished setup of a 4-node SQL Server 2005 cluster. We are using Windows 2008 R2 as the […]
Apply SQLServer Service Pack to a Single Node Cluster
Question : I have to apply a SQL Server 2008 R2 Service Pack to a Single Node Cluster. The other […]
Would SQL Server in a Cluster failover if it is running out of RAM
Question : I have a SQL Server 2008 R2 in a Cluster in an active-passive mode. The server is running […]
Shouldn’t Windows Server Failover Clustering already take care of SQLServer Failover Clustering?
Question : After reading this question, Are “Always On Failover Cluster Instances” and “SQL Server Failover Clustering” the same thing? […]
SQL Server 2012 Install error “The instance selected for installation is already installed and clustered on computer…”
Question : I am trying to setup a new environment for SQL Server 2012 AlwaysOn. I inadvertently used some SQL […]
Convert MyISAM to InnoDB in PXC master master
Question : I have 3 nodes PXC 5.6 master master cluster. I have few tables that are using MyISAM. Total […]
Can we use VMDK for FCI on SQL Servers?
Question : Can I share a VMDK among 2 nodes for an active passive setup for a SQL Server Failover […]
How to optimize and estimate DB recovery times?
Question : Would like to optimize recovery time for db’s after failover to passive node in high availability cluster. Assuming […]
MongoDB multi-datacenter deployment and shard keys
Question : I am trying to check my understanding after reading docs and some older questions, so my question is […]
Why automatic failover does not occur when I turn off SQL Service in SQL Server Failover Cluster Instance?
Question : I faced unusual behavior associated with automatic failover so that automatic failover does not work in the case […]