adspace


  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?

Question Posted / Shivangi Rastogi

Answer Posted / Shivangi Rastogi

SQL Server 2008 and 2008 R2 introduced several improvements to clustering compared to SQL Server 2005. Here are some key differences:

1. Network protocols: In SQL Server 2005, only TCP/IP network protocol was supported for cluster communications. Starting from SQL Server 2008, other protocols like Named Pipes and NetBIOS over TCP/IP can also be used for cluster communications.
2. Cluster resource types: SQL Server 2008 introduced a new resource type called 'SQL Server Application Resource' which allows you to manage multiple SQL Server instances as a single entity within the failover cluster. This feature is not available in SQL Server 2005.
3. Cluster Shared Volumes (CSV): CSV was first introduced in Windows Server 2008 and is supported by SQL Server 2008 and later versions. CSV allows for better I/O performance and scalability when using cluster shared disks to store data.
4. Failover Cluster Manager: The Failover Cluster Manager in SQL Server 2008 has a new user interface that provides more detailed information about the health of the cluster resources, as well as improved management capabilities.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to enter binary string literals in ms sql server?

1245

What kind of problems occurs if we do not implement proper locking strategy?

1500

What is acid mean in sql server?

1247

What is self contained sub query?

1141

Can we do dml on views?

1039

What are different types of constraints?

1002

What is the difference between for xml raw and for xml auto?

1119

When should you use an instead of trigger?

1054

What is a coalesce function?

1285

Is it possible to have clustered index on separate drive from original table location?

1041

Can we shrink data file in sql server?

1130

How do I find query history in sql server?

1025

What is subquery? Explain the properties of a subquery?

1063

Can you index views?

955

do you know how to configure db2 side of the application? : Sql server database administration

1125