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 […]

Un-Install a SQL Server Cluster: Step-by-Step

If SQL Server Cluster Install ends up in errors and fails, consider doing a clean up of the cluster install and then re-start it. Here is a step-by-step process which gives a clean un-install of a SQL Server Cluster environment. Step-1 Execute sqlrem.bat Execute sqlrem.bat with following parameters on each node: Syntax: sqlrem.bat <sql install […]

What is New with SQL Server Clustering on Windows 2003

Security Patch – Server Accessibility If latest security patches are not installed on SQL Server, you may see following error message in event log. You are running a version of Microsoft SQL Server 2000 or Microsoft SQL Server 2000 Desktop Engine (also called MSDE) that has known security vulnerabilities when used in conjunction with the […]

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 […]
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 |