Clustering
MSSQL provides solid high availability (HA) failover clustering support. However, MSSQL performance, in share nothing clustering is very limited, its administration and design is very complex. All clustering views should be redesigned and rebuild in order to scale the cluster out.
We discussed in previous paragraph the major MSSQL limitations in Clustering and High availability and also how MSSQL server share nothing and view based cluster works.
Oracle 10g adds RAC/Grid based clustering that can be easily scaled out even in standard edition. This is one of the notable advantages of Oracle 10g compared with MSSQL 2005.
Oracle provides a new, built-in software storage management solution called ASM (Automatic Storage Management) that assists with RAC/Grid based cluster deployment. In addition, Oracle provides proprietary and free (!) cluster file system on Linux and Windows platforms that helps in avoiding the use of raw devices.
©2004 WisdomForce Technologies, Inc.......
Join Now or Login to view the rest of this paper.
Approximate Word Count: 471
Approximate Pages: 2 (260 words per double-spaced page) |