SQL Server Clustering

SAP SQL database cluster

Hi Our sap configuration include two nodes on win 2003 cluster/ The cluster using us for SQL 2005 . I need to upgrade the hardware. It is possible to add two new nodes to the cluster ? It is downtime necessary if i want to replace one of the nodes ? it possible to install the sap software when...

How many tempdb's necessary in our clustered environment?

We have a clustered environment with three nodes and five instances. Each node has eight CPU's, and we are wondering how many tempdb's are necessary for each instance. Do you do the calculation on the total number of CPU's, all 5 instances failed over to one node or some other variation that I...

Removing a node from a working SQL Server 2005 cluster

I have Windows Server 2003 with SQL Server 2005 Standard Edition. We have seven divided instances, with each using only two of the three nodes. However, node one has to be taken out of the cluster; what steps should be taken to insure no significant loss in performance?

Multiple instances with SQL Server

Is it adviceable to put SQL 2000 and 2005 in one single CLuster by putting them in different instances?

cluster

what's the steps to use ( Clustering ) in any SQL Server 2005 System??

Virtualizing a SQL Server cluster in a production environment

What is Microsoft's official position in using virtualization (Virtual servers such as VMWare, etc.) for a SQL Server cluster (two node Active Passive) in a production environment? What are the best practices?

Federated Fabric cluster

Can any one help me out on how to setup a federated fabric cluster using SQL 2005 + windows 2003

Upgrading clustered SQL 2005 64 bit standard to enterprise

Does anyone have any steps on how to upgrade a clustered SQL 2005 64 bit standard edition to a clustered 64 bit enterprise edition ??

Clustering in SQL Server 2005/Windows Server 2003

Does clustering become Active/Active when using SQL Server 2005 and Windows Server 2003?

Command to display virtual nodes hosted by a physical server.

We have a four node (N+1)SQL 2005 cluster. From a DOS prompt, is there a command that can be run on each of the physical servers that will show you if it is hosting one of the virtual nodes of the cluster?

Setting up failover notifications in SQL Server 2005 cluster

We are new to clustering. We have recently successfully implemented a four-node (active/passive config) SQL Server 2005 cluster. How can I be automatically notified when a node within the cluster fails over to the passive standby or other node within the cluster? Thanks, JGalt

clustered sql 2000 to sql 2005 upgrade

What can I expect when upgrading a clustered SQL 2000 box to SQL 2005?

Can SQL Server 2005 32-bit and SQL Server 2005 64-bit co-exist on the same cluster machine?

Can SQL Server 2005 32 bit and SQL Server 2005 64 bit co-exist on the same cluster machine?

How to install a passive node on an active/active SQL Server cluster

We have a SQL cluster server running with SQL Server 2005 Enterprise Edition SP2 on Windows 2003 Enterprise Edition. Currently the cluster has 2 nodes with Active/Active. Now I need to add a new node as a Passive node. So once I’m done, the cluster will be a Active/Active/Passive cluster. ...

What are the steps to install multiple instances of SQL Server 2005 on Windows Server 2003 SP1 cluster?

What are the steps to install multiple instances of SQL Server 2005 on Windows Server 2003 SP1 cluster?

load balancing in sql server

Is there any Load Balancing in SQL Server 2005 to distribute CPU load between more than one server?

SQL 2005 Active/Active/Passive

We have a SQL cluster server running with SQL 2005 Enterprise Edition SP2 on Windows 2003 Enterprise Edition. Currently the cluster has 2 nodes with Active/Active. Now I need to add a new node as a Passive node. So after I have done it, the cluster will be a Active/Active/Passive cluster. ...

SQL Server 2005 multi-instance cluster

I need to set up a 2 node multi-instance SQL Server 2005 cluster (active/active). Since each node will failover to the other, can I use SQL Server 2005 Standard Edition on each node or do I need to use Enterprise Edition?

Using Veritas for SQL clustering

I would like to know if anyone is using VCS for SQL clustering and, if so, what their real-world experiences and thoughts are on VCS versus Microsoft SQL Clustering.