Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: clustering

New Cluster Testing – Best Practice

By adminPosted on March 14, 2023

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

By adminPosted on March 9, 2023

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

By adminPosted on March 4, 2023

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?

By adminPosted on February 27, 2023

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…”

By adminPosted on February 19, 2023

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

By adminPosted on February 18, 2023

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?

By adminPosted on February 15, 2023

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?

By adminPosted on February 8, 2023

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

By adminPosted on February 8, 2023

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?

By adminPosted on February 7, 2023

Question : I faced unusual behavior associated with automatic failover so that automatic failover does not work in the case […]

  • 1
  • 2
  • 3
  • …
  • 37

Recent Posts

  • Why should I create an ID column when I can use others as key fields? [duplicate]
  • Force NOW to return new timestamps without committing the transaction
  • MariaDB on Windows Server 2012 R2 – out of memory
  • How to easily convert a comma seperated list of ids into a table of rows
  • clusterdb stopped working for PostgreSQL database in Ubuntu 12.04 server
  • Slow MySQL query
  • Database design : hotel room and its detail
  • How to use GROUP BY in an efficient way without losing attributes? [closed]
  • Query execution time is random, need to identify the root cause
  • Returning data where all categories exactly match
  • Partitioning increases CPU usage in mariadb
  • How to script out push subscription creation at the subscriber?
  • Can a transitive join loop infinitely?
  • 2 similar queries in large sql server table – 1 takes too long
  • Select data from another database instance on the same server in sql server
  • Is it possible to get server roles and database roles in a same query/script?
  • UPDATE performance where no data changes
  • Can I parse a text value from a specific column in a query (MySQL)?
  • MSSQL Geography STIntersects returns 1 when 0 is expected
  • Shrinking log files with SMO

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding