I have configured a win2k3 4 node active/active sql 2005 cluster. I am a bit
confused on the ative active part. Presently I have 1 virtual server, which
runs fine on one of the nodes. How do I take advantage of the other nodes ?
I want to utilize all the nodes, keeping in mind ...

Bascially, our applications seems freezing periodically when we perform the
loading test. During the test, the CPU usage is only 40% (4 processors),  
Page/Sec < 0.5, Network Usage is avg 10%. Our SQL Cluster has 8GB memory, and
the new application database size is only 12MB in ...

I'm trying to put a case together to encourage my employer to upgrade from
its SQL 2000 Enterprise farm to SQL Server 2005.
We're interested in Enterprise functionality, such as:
- Improvement in backups

I need a good online reference for setting up a SQL 2005 Windows 2003
multi-node cluster.  An explanation of the configuration and behavior of an
A-A-P cluster would be greatly appreciated.
Thanks!

Currently we have 4-NODE SQL Cluster as follows:
H/W = 32-Bit processors
Windows 2003 EE (32-Bit)
SQL 2000 EE (32-Bit)

We need to upgrade SQL Server 2K SP3a on our Windows Server 2003 SP1 two
nodes Cluster and I have a doubt regarding how to install the latest hotfix.
My intention is this:
For Service Pack:

I try to figure out whether - and if yes, how - it works to to set up an
active/active cluster with several SQL Server 2005 instances that are using
partitioned tables.
For example, a big table with orders:

I have a SQL server cluster running on Server 2003. I am in the process of
buying the SQL licenses. The difference in price between SQL Enterprise and
SQL Standard are a couple thousand dollars.
Does the cluster HAVE to be SQL Enterprise?

Could someone tell me how to install Reporting Services 2005 as a clustered
service?  I'm running SQL 2005 STD on Windows 2003 R2.  Any help would be
greatly appreciated.
Thank you

we are using:
Windows server 2003 R2 Enterprise edition SP1
SQL server 2005 Standard edition installed on shared cluster disk
2 Nodes server connecting and working with in the cluster

I've set up a win2003 enterprise 2 node cluster with an instance of sql
server on each node. It' s running SVC Pack1 and the SQL versions are 2000
with SP4 and SQL 2005 with SP1,both enterprise editions.
The above operating systems are guests on a win2003 enterpise server running

We have 2 clusters, both 2 node active/passive, both have SQL Server running
on the Active node.  I am using Idera's SQL Diagnostic Manager to monitor
and gather statistics on the SQL instances.
However, on one cluster, not all of the performance counters have been

Building a windows 2k3 Enterprise ITANIUM EDITION x64 cluster with SQL 2005.
First, is there any step by step guides I can follow for both the version of
windows I use as well as sql 2005 in regards to clustering?
Second, I know that SQL 2005 works off instances (assigned to ...

Does SQL Server 2005 Standard edition support  Active/Active(both servers
online) Cluster environment. When i check at features it mentioned fail over
(only two nodes), but it didnt mention about active/active.
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

Question - do I have a successful SQL 2005 cluster install?
I installed SQL 2005 Standard Edition on a two node cluster. However, I had
to hit ignore 4 times when the following error message appeared:
TITLE: Microsoft SQL Server 2005 Setup