SQL Server Clustering

Should You Upgrade Your Current SQL Server Cluster to a SQL Server 2005 Cluster?

If your organization is like many organizations, it may have some older version SQL Server clusters in production. If so, at some point you will have to make a choice about how to upgrade them to SQL Server 2005. Your available options include: Don’t upgrade. Perform an in-place SQL Server 2005 upgrade. Rebuild your cluster […]

How to Create Nonkey Columns in Nonclustered Indexes in SQL Server 2005

Let’s say for example that we have a table that contains these columns. (This example has been simplified to make it easier to follow.) Primary_Key Customer_No Customer_Name Customer_Address Let’s assume that the Primary_Key column is a monotonically increasing integer and that the last three columns are VARCHAR columns. Let’s also assume that there is a […]

Does SQL Server 2005 Clustering Really Make Sense for My Organization’s Needs?

As the forum administrator for SQL-Server-Performance.Com, I see hundreds of questions from DBAs on SQL Server clustering. What always surprises me is how misunderstood clustering is. So exactly what do I, and Microsoft, mean when we refer to SQL Server 2005 clustering? Here’s a good working definition: Microsoft SQL Server 2005 clustering is a high-availability […]

How to Configure Virtual Server 2005 in Order to Setup a Test SQL Server Cluster

Introduction There are a lot of DBAs who want to learn how to cluster SQL Server. There are also a lot of companies who may have a production SQL Server cluster, but not a test SQL Server cluster. In both cases, the reason for this is that clustering hardware is very expensive, and setting up […]

SQL Server 2000 & 2005 Clustering

Chapter 1 – Basics of SQL Server ClusteringIf your AAA critical SQL server faces a memory board failure, how long will be the outage? How much will this cost your business in productivity and data availability to the users? Being a SQL Server DBA can be demanding and stressful, as the success of your application […]

How to Attain SQL Server High Availability at Minimal Cost

You may find it hard to believe, but it is possible to maintain SQL Server high availability and not spend a fortune. In fact, you can spend a fortune and still not get SQL Server high availability. Sound like a paradox? Not really. SQL Server high availability is not a direct function of how much […]

Basics of SQL Server Clustering

If your AAA critical SQL server faces a memory board failure, how long will be the outage? How much will this cost your business in productivity and data availability to the users? Being a SQL Server DBA can be demanding and stressful, as the success of your application is often a function of your database […]

How Clustering Works

In a two-cluster node Active / Active setup, if any one of the nodes fail, then the another active node will take over the active resources of the failed instance. It is always preferred while creating two-node cluster using Windows 2000 Advanced Server and Microsoft Clustering Service, that each node be connected to a shared […]

Designing your SQL Server Cluster

Preparing Cluster Resource Groups As a first step, the DBA should list all server-based applications and services that will run within the cluster environment, regardless of whether they will need high availability. Applications and services that need to be highly available should be placed into resource groups. Other applications should be tracked, and their interactions […]

Installation of SQL Server Clustering

Pre-Installation Spot Verification Review the Windows Event Log, it should not have any errors before you begin the SQL Server clustering installation. Ping from one node to another to verify a good connection and a latency of less than 500ms. In regard to the services listed under Pre-Install Preparation Checklist above, make sure all of […]
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 |