Is it possible for both nodes in a SQL Server cluster to open up the same .MDF & .LDF file on the shared array simultaneously?

Question

Is it possible for both nodes in a SQL Server cluster to open up the same .MDF & .LDF file on the shared array simultaneously and still be able to perform standard SQL calls (SELECT, UPDATE & INSERT) without causing corruption, performance degradation and/or sharing issues. 

Answer

No, this is not possible. Microsoft clustering technology uses what is called a shared-nothing arrangement, which means that only one node of a cluster can access a shared array at a time.

Other vendors offer the ability, in their clusters, to allow multiple nodes to access the same database on the same shared disk array simultaneously, but not Microsoft. The reason Microsoft uses shared-nothing technology is because it is generally considered faster and more reliable that the alternatives.




Related Articles :

  • No Related Articles Found

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |